May 31, 2019
Im trying to setup a connection to an API using powerquery, but so far i've been unable to get it right, im trying to make a POST request to a site called detrack.com.
Specifically its the "view all" im trying to connect to: https://www.detrack.com/api-do.....llections/
I tried following this guide, without much luck though
I hope one of you can help me, it'd be greatly appreciated!
November 8, 2013
You have an example here using a custom header to pass the api key. (Set Custom HTTP header ‘X-API-KEY‘ with your Detrack API key instead of [Headers=[#"X-Auth-Token"=Token]] from that example.)
If you use this method, pass the json into content:
Source = Json.Document(Web.Contents(URLString,
But you can use method 1 described in documentation, building the api key into url.