Forum Discussion
Connect API with Header ApiKeyName not going through
- 8 years ago
Perhaps this might work too:
Perhaps this might work too:
A new message because I want to clarify something here. IT WORKED Michal!!!. One thing only, its case sensitive. So for some reason, Ive tried x-api-key and DID WORK instead of X-API-KEY. Thank you God and this community.
Ty Michael.
Have a wonderful week everyone :).
- Michal_cwiok8 years agoResolver II
jasonfordxThis is great! Thank you clarifying that it is case sensitive!
Would it be possible for you to paste the M/Power Query code from advanced editor? This would be helpful for solving future problems. Thanks!
- jasonfordx8 years agoHelper II
Yes, off course. It is working like this:
let
Source = Json.Document(Web.Contents("URL", [Headers=[#"x-api-key"="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]])),
#"Converted to Table" = Record.ToTable(Source)
in
#"Converted to Table"- Anonymous7 years agoNot applicable
Very Niiice jasonfordx !!
But I have a question, you posted in the workspace and managed to put automatic update???