topic Re: How can I use JSON file to call API Rest ? in Talend Studio

How can I use JSON file to call API Rest ?

Eric_Talend — Sat, 16 Nov 2024 02:02:10 GMT

Hello,

I have a difficulty and I can't get it to work.

I would like to call a API Rest with a JSON File.

The scheme :

mysql data -----> Json File -----> API Rest to add in database

My problem is the structure of the Json Field.

Kind regards.

Re: How can I use JSON file to call API Rest ?

manodwhb — Mon, 29 Jun 2020 10:46:53 GMT

@Eric_Talend, you need to use the below like record by record from mysql and use twritejson or tHmap to convert the data into json and the use tRestClient.

tMySqlInput>>tFlowtoIterate>>tWritejson>>tJavaRow>>tRestClient

Re: How can I use JSON file to call API Rest ?

manodwhb — Mon, 29 Jun 2020 10:46:53 GMT

@Eric_Talend, you need to use the below like record by record from mysql and use twritejson or tHmap to convert the data into json and the use tRestClient.

tMySqlInput>>tFlowtoIterate>>tWritejson>>tJavaRow>>tRestClient