API with different token name did not work ( Web.Contents function)

Do5779 — Fri, 05 Aug 2022 09:28:22 GMT

Hi Experts,

I am searching for hours, watching tutorials and also have no idea how to get the right answer. So I hope you can help me:

I want to get the informations of this website per API: Documentation | Exchange Rates API,
e.g. for the latest prices. So thats the documentation:

https://api.exchangeratesapi.io/v1/latest
    ? access_key = API_KEY
    & base = USD
    & symbols = GBP,JPY,EUR

At first I try to connect the Webservice with the surface of power BI, but this didn't work because of the name of the key ( access_key) instead of Authorization. Now my plan was to take the code, how it was offerd in the blog (Power Query Web.Contents cheat sheet walkthrough | by Oscar Martinez | PowPCo) at Example No. 5 but i don't get it. How I can adress the freaking name of the token?

It seems to me something like :

let Source = Json.Document( Web.Contents( "https://api.exchangeratesapi.io/v1/latest", [ Query = [ access_key = "123" ]])), in Source

let Source = Json.Document(Web.Contents( "https://api.exchangeratesapi.io/v1/latest", Query =[ ApiKeyName="access_key", apikey = "123" ] )) in Source

In this solution I should only set the "Key Name" and set the Key at the login screen. But It also did not work. Is the key incorrect or did I some mistakes?

Get Data through API - Microsoft Power BI Community

Code:

let Source = Json.Document(Web.Contents( "https://api.exchangeratesapi.io/v1/latest", [ ApiKeyName="? access_key"] )) in Source

Screen:

The Key "123" is only for the understanding.

Thanks a lot 😭

Re: API with different token name did not work ( Web.Contents function)

lbendlin — Sun, 07 Aug 2022 00:59:29 GMT

Your first option is most appropriate but you are missing the other query components. You need to supply base and symbols too.

topic API with different token name did not work ( Web.Contents function) in Developer

API with different token name did not work ( Web.Contents function)

Re: API with different token name did not work ( Web.Contents function)