Forum Discussion

jdchipps's avatar
jdchipps
Frequent Visitor
6 years ago

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 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

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    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)])),

     

     

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    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.