How to use GET requests when using data from web API?

[Chartist]

I am trying to extract information from a finance site API. I went to Data > From Web, and pasted the site's provided URL. But now nothing happens.

On the site instructions it says use these commands:

GET /exchange/ticker

GET /exchange/v1/markets

How can I use these commands to fetch the data into Excel?

Thanks.

 

[Chartist]

Does it have to be put in VBA code somewhere?

 

[John_w]

I went to Data > From Web, and pasted the site's provided URL

Are you pasting the full URL?

If it's this API:

API Reference

Documentation for the CoinDCX API

coindcx-official.github.io

Then you must prepend the base URL to the endpoints to get URL for Power Query, like this:

https://api.coindcx.com/exchange/v1/markets