Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I want to get access to historical exchange rate data by using the ExchangeRate-API in Qlik Sense.
The API URL structure is like this:
https://v6.exchangerate-api.com/v6/YOUR-API-KEY/history/USD/YEAR/MONTH/DAY
I am unsure on how to create the setup for this, as I don't see parameters being passed. Is there a way that I can setup part of the connection and add/join the remainder of the call in the load script?
Ideally, it would be great if I can setup the connection just as "https://v6.exchangerate-api.com/v6/YOUR-API-KEY/history/USD/" and then add the date as a variable.
I need data for the past five years and I don't want to setup 1525+ connections just to get the data.
Alternatively, is there another reliable exchange rate API that anyone can recommend that makes it a bit easier and more dynamic?
Thanks in advance!
If you're using a Web File you should try URL is.
Check this example
Thank you! I added this in the WITH CONNECTION section and it works perfectly.
WITH CONNECTION (
Url "$(vUrl)"
)