Set dynamic API URL

[ben0109]

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!

[danielrozental · Accepted solution]

If you're using a Web File you should try URL is.

Qlik Sense URL is 

Check this example 

[ben0109]

Thank you! I added this in the WITH CONNECTION section and it works perfectly.
WITH CONNECTION (
Url "$(vUrl)"
)