How to connect to an API?

Hi Anonymous 

You can retrieve data from a REST API by issuing HTTP requests to it, usually just to a specific URL.  I've never had to specify a port.

You need to write a query that issues the request and the form of the query depends on the API.  Some are straightforward to connect to, others require a more complicated authentication process.

You will need to study the documentation of the API you want to connect to, to understand what is required.

Once the query is written it will work as any other query, hit refresh to get the next lot of data.  Depending on what you are trying to retrieve, you may need to write more than 1 query or you could just do somethign like use parameters to get the data you want.

Further reading 

https://www.myonlinetraininghub.com/tag/power-query-api

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.