Navigation Tree Download in Excel VBA

[Shlodge]

Hi,

I am trying to find out which round the "Tennis Game" belongs in the Tournament.

I have tried "ListMarketCatalogue" but it doesn't contain this information.

Is there anything that says "MenuPath" or "Event Hierarchy"?


Here is the original query
I am trying to retrieve "Navigation Data for Applications" Download. I have found the documentation below.

https://api.developer.betfair.com/se...r+Applications

Can someone please help me write a "VBA" version of the "Input Statement" that I can send through using Excel?

I am familiar with the codes such as
{"jsonrpc": "2.0", "method": "SportsAPING/v1.0/listMarketBook", "params": {"marketIds":["1.113421376"],"orderProjection":"EXECUTABLE","EXECUTION_COMPLET E", "matchProjection":"ROLLED_UP_BY_PRICE"}, "id": 1}

However, this documentation is kind of confusing. What is "Accept", what is "Connection", why are we using X-Application: instead of "App Key"

Any help or guidance to get my started will be greatly appreciated.

Thanks,
Xpresson