How can I use JSON file to call API Rest ?

[Eric_Talend]

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.

[manodwhb]

@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

[manodwhb]

@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