topic API call with tRest in Talend Studio

API call with tRest

NAdams1602707007 — Sat, 16 Nov 2024 01:17:11 GMT

Hey everyone,

I'm new with doing API calls and I need to create a workflow in Talend to get json data and load the data into a database table. I have been given the API key and the Terminal ID of my source but not sure how to format the tRest component in the headers section. Any pointers?

Re: API call with tRest

Ravi_Rajagopal — Tue, 20 Oct 2020 14:54:41 GMT

Did you get your question answered? This is a long winded discussion. You will have to setup through the API designer, to consume the API. You then use that API designer in your tRest component and then you extract the data from the JSON request.

Re: API call with tRest

kakooo16 — Tue, 20 Oct 2020 15:44:52 GMT

Hi , you have to test your api call in for example (in my case) Postman to view the response of the api . Then once you have the related informations (Headers ,etc .. )

You can view the result by matching the tRest with a tLogRow .

After that you can match a tMap the result will be

then you can use tExtractJsonFields to extract the columns needed .

The final thing to do is :

tRest -- tMap -- tExtractJsonFields -- DB

Greetings