https://community.qlik.com/t5/Talend-Studio/How-to-process-the-data-save-in-SQL-DB-from-tRestClient-on/m-p/2365904#M129460 <P><SPAN>Hello Everyone,</SPAN></P> <P>&nbsp;</P> <P><SPAN>I am very new to everithing here Talend,Talend community,Rest,JSON,XML.&nbsp;<BR /></SPAN></P> <P><SPAN>Having said that, I needed to pull data from Zoho CRM using reporting API.&nbsp;</SPAN></P> <P><SPAN>I found a way to do it using tRestClient (data fetch working perfectly fine). Below is the screenshot of the job.&nbsp;</SPAN></P> <P>&nbsp;</P> <P><SPAN>But I am facing issue in saving this data into a table in MySQL DB.&nbsp;<BR /><BR />Need help in understanding which components I should use to bring data into a format that I can save into DB table.&nbsp;</SPAN></P> <P>&nbsp;</P> <P><SPAN>Also attached the data sheet I received&nbsp;after running the above job.&nbsp;<BR /><BR /><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="csv output configuration" style="width: 845px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lwh3.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148019i61205E3A5FD20166/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lwh3.png" alt="0683p000009Lwh3.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">csv output configuration</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="csv_output_1.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LwhD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134579iEFF0724217B3EFD9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LwhD.png" alt="0683p000009LwhD.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="trestclient configuration" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LwgG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147985iEDFACB3EBE4992B2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LwgG.png" alt="0683p000009LwgG.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">trestclient configuration</SPAN></SPAN><BR /><BR />Thanks in advance...!!</SPAN></P> <P>&nbsp;</P> Sat, 16 Nov 2024 08:25:25 GMT Anonymous 2024-11-16T08:25:25Z https://community.qlik.com/t5/Talend-Studio/How-to-process-the-data-save-in-SQL-DB-from-tRestClient-on/m-p/2365904#M129460 <P><SPAN>Hello Everyone,</SPAN></P> <P>&nbsp;</P> <P><SPAN>I am very new to everithing here Talend,Talend community,Rest,JSON,XML.&nbsp;<BR /></SPAN></P> <P><SPAN>Having said that, I needed to pull data from Zoho CRM using reporting API.&nbsp;</SPAN></P> <P><SPAN>I found a way to do it using tRestClient (data fetch working perfectly fine). Below is the screenshot of the job.&nbsp;</SPAN></P> <P>&nbsp;</P> <P><SPAN>But I am facing issue in saving this data into a table in MySQL DB.&nbsp;<BR /><BR />Need help in understanding which components I should use to bring data into a format that I can save into DB table.&nbsp;</SPAN></P> <P>&nbsp;</P> <P><SPAN>Also attached the data sheet I received&nbsp;after running the above job.&nbsp;<BR /><BR /><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="csv output configuration" style="width: 845px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lwh3.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148019i61205E3A5FD20166/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lwh3.png" alt="0683p000009Lwh3.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">csv output configuration</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="csv_output_1.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LwhD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134579iEFF0724217B3EFD9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LwhD.png" alt="0683p000009LwhD.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="trestclient configuration" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LwgG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147985iEDFACB3EBE4992B2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LwgG.png" alt="0683p000009LwgG.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">trestclient configuration</SPAN></SPAN><BR /><BR />Thanks in advance...!!</SPAN></P> <P>&nbsp;</P> Sat, 16 Nov 2024 08:25:25 GMT https://community.qlik.com/t5/Talend-Studio/How-to-process-the-data-save-in-SQL-DB-from-tRestClient-on/m-p/2365904#M129460 Anonymous 2024-11-16T08:25:25Z