You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-07-13 15:25:11

mr2001
Member
4 posts

mr2001 said:

How to extract JSON (multiline) child records?

Hello,
I have the following JSON metadata (see  attached picture).

As you can see, there are multiple "child" records for every main record.
The corresponding child records are arrays: ["2104-12-05T19:36:14Z","2104-12-05T19:37:49Z", ...etc] and ["Approved","Resolved",..etc]


This is my project (see attached picture)
It should extract records from ClearQuest using REST and copy then to SQL Server (doesn't work though as design is wrong because of the issue above).

What I need are single records to be inserted into the SQL Server database. Please advise.
Regards,
M.R.
mini_blob.pngmini_blob_20160713-0741.png

Last edited by mr2001 (2016-07-13 15:41:21)

Offline

#2 2016-08-01 08:26:13

xdshi
Talend Team


xdshi said:

Re: How to extract JSON (multiline) child records?

Hi,
Sorry for delay!
Could you please post your expected result into forum?
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy