tRestClient Configuration to extract Data from API

[Anonymous9]

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!

[Anonymous]

Hi

Can you take an example to explain what you need to remove the manual input of the currencies from the URL?

Regards

Shong

[Anonymous9]

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