Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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. 

0683p000009Lwh3.pngcsv output configuration0683p000009LwhD.png0683p000009LwgG.pngtrestclient configuration

Thanks in advance...!!

 

Labels (5)
0 Replies