How to process the data save in SQL DB from tRestClient on Talend Open Studio for Big Data

Four Stars

How to process the data save in SQL DB from tRestClient on Talend Open Studio for Big Data

Hello Everyone,

 

I am very new to everithing here Talend,Talend community,Rest,JSON,XML. 

Having said that, I needed to pull data from Zoho CRM using reporting API. 

I found a way to do it using tRestClient (data fetch working perfectly fine). Below is the screenshot of the job. 

 

But I am facing issue in saving this data into a table in MySQL DB. 

Need help in understanding which components I should use to bring data into a format that I can save into DB table. 

 

Also attached the data sheet I received after running the above job. 

csv_output.PNGcsv output configurationcsv_output_1.pngrest_client.pngtrestclient configuration

Thanks in advance...!!

 

Tags (1)