Forum Discussion

TheChilOne's avatar
TheChilOne
Regular Visitor
5 years ago

First time API connection - Base64 Encoded

I am trying to connect to a URL; however, I get a credential error.  I have passed the Base64 encoded APIKEY and Session TOKEN through the header using the Power Query Advanced Editor, and there are ...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi TheChilOne ,

 

If the API method is get, please refer to this blog.

https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/ 

If the API method is post, you also need to refer to these:

https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/ 

https://social.msdn.microsoft.com/Forums/en-US/029fed1d-56fe-476a-9d7d-f367c5036b6e/posting-xml-to-a-restful-service?forum=dataexplorer 

 

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