Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nrao1693561508
Contributor II
Contributor II

unable to prase array data in json

Hi ,

can anyone please guide me how pass array data in JSON in talend, column name " contentMakers"

 

""published": true,
"contentMakers": [
{

"name": "Prime",
"designation": null,
"type": "author"
}

 

nrao1693561508_0-1718085295728.png

 

Labels (1)
  • v7.x

2 Solutions

Accepted Solutions
nrao1693561508
Contributor II
Contributor II
Author

Hi 

PREVIEW
 

Actually data coming as below, need to parse record by record

please suggest what we need to define tFileInputJson component

nrao1693561508_0-1718251334704.png

 

View solution in original post

Shicong_Hong
Support
Support

You can follow the wizard to create a json file metadata. In the Repository view, expand the Metadata node, right click File JSON, and select Create JSON Schema from the contextual menu to open the New Json File wizard, for more detailed steps, see 

https://help.talend.com/en-US/studio-user-guide/7.3/centralizing-json-file-metadata

 

View solution in original post

3 Replies
Shicong_Hong
Support
Support

Hello 

What's the desired output result? Set the Loop Json query expression as below on tFileInputJson component,  you should be able to extract all the values in array.

"$.contentMakers[*]"

 

Shicong_Hong_0-1718186860692.png

 

nrao1693561508
Contributor II
Contributor II
Author

Hi 

PREVIEW
 

Actually data coming as below, need to parse record by record

please suggest what we need to define tFileInputJson component

nrao1693561508_0-1718251334704.png

 

Shicong_Hong
Support
Support

You can follow the wizard to create a json file metadata. In the Repository view, expand the Metadata node, right click File JSON, and select Create JSON Schema from the contextual menu to open the New Json File wizard, for more detailed steps, see 

https://help.talend.com/en-US/studio-user-guide/7.3/centralizing-json-file-metadata