Set dynamic API URL

ben0109 — Wed, 04 May 2022 08:00:52 GMT

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!

Re: Set dynamic API URL

danielrozental — Thu, 05 May 2022 22:13:44 GMT

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

Qlik Sense URL is

Check this example

Re: Set dynamic API URL

ben0109 — Fri, 06 May 2022 06:39:30 GMT

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

topic Re: Set dynamic API URL in Integration, Extension & APIs

Set dynamic API URL

Re: Set dynamic API URL

Re: Set dynamic API URL