unable to prase array data in json

[nrao1693561508]

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"
}

[Shicong_Hong]

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[*]"

[nrao1693561508 · Accepted solution]

Hi 

Shicong_Hong

PREVIEW

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

please suggest what we need to define tFileInputJson component

[Shicong_Hong · Accepted solution]

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