Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I am extracting the data from the ECB API and wanted to configure the dynamic settings for the Source and Target Currency.
I have the Source Currency table where I have a list of 10 currencies that I need to convert into EURO which acts as Base currency and I would like to iterate oly these 10 currencies as of now which is there in the table.
I can iterate the Source currencies in a separate pipeline but need to integrate with the ECB URL "https://sdw-wsrest.ecb.europa.eu/service/data/EXR/D.CHF+CNY+CZK+HUF+RON+TRY+USD.EUR.SP00.A?startPeriod=2022-12-25". In short, would like to remove the manual input of the currencies from the URL and use it from a Source table.
Appreciate your help.
Thank you!
Hi
Can you take an example to explain what you need to remove the manual input of the currencies from the URL?
Regards
Shong
Hi @Shicong Hong ,
I wanted to remove the "https://sdw-wsrest.ecb.europa.eu/service/data/EXR/D.CHF+CNY+CZK+HUF+RON+TRY+USD.EUR.SP00.A?startPeri...". currencies defined here (CHF+CNY and so on...) and instead wanted to extract the information from the db and iterate the currencies which are there in the column. in a table.
In the below example I have a db table with 4 currencies and i am able to iterate them but not sure how to configure the column in REST client URL. Hope this helps.
Thank you and Best Regards