Forum Discussion

Snap's avatar
Snap
Frequent Visitor
5 years ago

Schedule refresh fail - API with token

Hi,    I have followed some instructions on getting a dynamic token to pull some information from a webiste. The function sends my credentials in order to get a token. This token then gets used for...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Snap ,

 

Please use something like:

 

Source = Json.Document(Web.Contents("xxxxxxxx", [
  RelativePath="api/accounts",
  Query=[token=#"Get Token"()]
 ]))

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

  • Snap's avatar
    Snap
    Frequent Visitor
    5 years ago

    Seems to still give me a smilar error. It refreshes in desktop but as soon as I publish (that works) and try to refresh it gives me the below error. 

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      5 years ago

      Hi Snap ,

       

      Not very sure about your issue since I can't reproduce it in my environment.  I think may be you have contains password and username in the url directly in your token function. I suggest you refer to  https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/  to modify your code and try again.

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      Best Regards,

      Dedmon Dai