Forum Discussion
Solved
Connect API with Header ApiKeyName not going through
Dear community, Im trying to connect my Excel/PowerBI and is not working. I read the entire forum and I could not reach the right answer for it. My provider gave me the following instructions...
Perhaps this might work too:
I am not an expert, but my quick research suggests that the header name should be "X-API-KEY" and its value being API-KEY. Now you have header name "Authorization" and value "X-API-KEY:YOUR_KEY".
Try something like this
let
Http_query = Json.Document(Web.Contents("<Your URL>",
[Headers=
[X-AP-KEY ="<Your API KEY>"]
]
)),
Data = Http_query{0}
in
DataLet me know, if it works. I think this is the right direction.
Perfect, thank you!