topic unable to prase array data in json in Talend Studio

unable to prase array data in json

nrao1693561508 — Tue, 11 Jun 2024 05:56:28 GMT

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

Re: unable to prase array data in json

Shicong_Hong — Wed, 12 Jun 2024 10:10:10 GMT

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

Re: unable to prase array data in json

nrao1693561508 — Thu, 13 Jun 2024 04:03:43 GMT

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

please suggest what we need to define tFileInputJson component

Re: unable to prase array data in json

Shicong_Hong — Thu, 13 Jun 2024 09:19:07 GMT

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