API call with tRest

[NAdams1602707007]

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?

[Ravi_Rajagopal]

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.

[kakooo16]

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