topic Re: How to extract JSON (multiline) child records? in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-extract-JSON-multiline-child-records/m-p/2305581#M77220 Hi,<BR />Sorry for delay!<BR />Could you please post your expected result into forum?<BR />Best regards<BR />Sabrina Mon, 01 Aug 2016 08:26:13 GMT Anonymous 2016-08-01T08:26:13Z How to extract JSON (multiline) child records? https://community.qlik.com/t5/Talend-Studio/How-to-extract-JSON-multiline-child-records/m-p/2305580#M77219 <P>Hello,<BR />I have the following JSON metadata (see&nbsp; attached picture).<BR /><BR />As you can see, there are multiple "child" records for every main record.<BR />The corresponding child records are arrays: ["2104-12-05T19:36:14Z","2104-12-05T19:37:49Z", ...etc] and ["Approved","Resolved",..etc]<BR /><BR /><BR />This is my project (see attached picture)<BR />It&nbsp;should&nbsp;extract records from ClearQuest using REST and copy then to SQL Server (doesn't work though as&nbsp;design is wrong because of the issue above).<BR /><BR />What I need are single records to be inserted into the SQL Server database. Please advise.<BR />Regards,<BR />M.R.<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFNH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150694iEA5B6C1E567E82A5/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFNH.png" alt="0683p000009MFNH.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFW8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147840iB506706D39F673D1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFW8.png" alt="0683p000009MFW8.png" /></span></P> Wed, 13 Jul 2016 15:25:11 GMT https://community.qlik.com/t5/Talend-Studio/How-to-extract-JSON-multiline-child-records/m-p/2305580#M77219 Anonymous 2016-07-13T15:25:11Z Re: How to extract JSON (multiline) child records? https://community.qlik.com/t5/Talend-Studio/How-to-extract-JSON-multiline-child-records/m-p/2305581#M77220 Hi,<BR />Sorry for delay!<BR />Could you please post your expected result into forum?<BR />Best regards<BR />Sabrina Mon, 01 Aug 2016 08:26:13 GMT https://community.qlik.com/t5/Talend-Studio/How-to-extract-JSON-multiline-child-records/m-p/2305581#M77220 Anonymous 2016-08-01T08:26:13Z