API Key set in Web.contents

[jdchipps]

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 I need to get my report back online as soon as possible?

jsonDoc= Json.Document(
Web.Contents(
"https://**************/api/v1/***/****tory", [RelativePath="/?&start=" & Number.ToText(n)])),
result = jsonDoc[result],
records = result[records],
tmpTbl = Table.FromList(records, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

Thanks

[v-xicai]

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.

[lbendlin]

Your relative path structure is slightly inaccurate.  But you can extend it as needed

jsonDoc= Json.Document(
Web.Contents(
"https://**************/api/v1/***/****tory", [RelativePath="/?APIKey=" & key & "&start=" & Number.ToText(n)])),