topic tRestClient Configuration to extract Data from API in Talend Studio

tRestClient Configuration to extract Data from API

Anonymous9 — Tue, 10 Jan 2023 10:27:44 GMT

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!

Re: tRestClient Configuration to extract Data from API

Anonymous — Wed, 11 Jan 2023 08:50:52 GMT

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

Regards

Shong

Re: tRestClient Configuration to extract Data from API

Anonymous9 — Wed, 11 Jan 2023 10:20:39 GMT

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?startPeriod=2022-12-25". 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