Forum Discussion
How to use API using Free access key in power query
Hello guys,
I found a code and pbix file here to create Historical currency exchange rates but when i tried to run that file it is showing error for API access key. I have access key but i have never used API in power query before so i am not able to undrstand where and how to put this key . I shall be thankful if anybody can help me regarding that. I am attaching the snapshots and the pbix file here. A function is created to get historical ratyes using API and a Query has been used to create a table of dates
Thanks in advance
Hey Amar-Agnihotri ,
I took a look at the instructions provided by exchangeratesapi as there are many ways an API call could work depending on how it is setup. To write out the key for this API you will need to put the key in right after your date so it will look like this:
http://api.exchangeratesapi.io/v1/2013-03-16?access_key=key goes here&symbols=USD,AUD,CAD,PLN,MXN&format=1One thing to note is that the free key does not allow for you to set the base so you'll need to remove that from your code if you're using the free version.
Quickstart Guide | exchangeratesapi API
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
1 Reply
Hey Amar-Agnihotri ,
I took a look at the instructions provided by exchangeratesapi as there are many ways an API call could work depending on how it is setup. To write out the key for this API you will need to put the key in right after your date so it will look like this:
http://api.exchangeratesapi.io/v1/2013-03-16?access_key=key goes here&symbols=USD,AUD,CAD,PLN,MXN&format=1One thing to note is that the free key does not allow for you to set the base so you'll need to remove that from your code if you're using the free version.
Quickstart Guide | exchangeratesapi API
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.