Forum Discussion

Helper III

5 years ago

Solved

Beginner - exchange rate API

Hi I'm brand new to PBI, and i'm trying to find a solution to making a exchange rate table. I found a model in here where the API endpoint has been updated. Im trying to reach this endpoint...

Need Help

NickA01
5 years ago
DennisSchlein
We are all always learning;
if you just open Advanced editor then you can replace your code with mine - remember to add in the key.
Get Data --> From Web -- Click on Advanced
Another option to get data for multiple dates would be to use the timeseries mentioned in the documentation but this looks like it is dependent on the subscription you have.

Regarding getting data for different dates, as mentioned by amitchandak Chris Webbs cross join blog will help.

DennisSchlein

Helper III

5 years ago

Hi amitchandak ,

I have not tried Oauth.

As I read the documentation for exchangeratesapi.io, i get (a static? API access key)

So I would think I just need to create the text string matching the url, addding dates from ym date table:

So I think I just need to create the syntax for it to be like this:

S Source = Json.Document(Web.Contents("https://api.exchangeratesapi.io/v1/"& Date &"?access_key=b5b562191a8c1fea37bcef334834395d"&"?base="&C&"")),

Or, do I completely misunderstand?