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

Highlighted
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)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read