Forum Discussion
API Key set in Web.contents
I have an API that now needs an API key for authentication. I have been trying all morning to get this to work but do not know where in the below I need to set the API Key, can anyone help please as...
Hi jdchipps ,
You may try codes like below.
jsonDoc= Json.Document(
Web.Contents(
"https://**************/api/v1/***/****tory", [RelativePath="/?&start=" & Number.ToText(n)], [ApiKeyName="APIToken"]) ),
result = jsonDoc[result],
records = result[records],
tmpTbl = Table.FromList(records, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
For reference:
https://blog.crossjoin.co.uk/?s=web.contents&submit=Search
https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.