Rewriting of an array from one local JSON file to another problem.

Anonymous — Sat, 16 Nov 2024 10:15:06 GMT

Hi guys,
I have a problem with Talend with creating a JSON file. I'm trying to extract the array from locally stored JSON file and rewrite it to another local JSON file excluding one of the field ( the most important is the rewriting the complete array in the same structure). I tried it with tExtractJSONfields but the result was like this. What I'm getting is an object in the field with all the data at the same time or separated fields without array structure.
I've tried all the tutorials but it's simply not working.
Is anyone knowing how to do it? And able to post a small guidance how to configure the components.

Orginal JSON file:

{
"product":[
{
"eventId": "222-ewq-222-erwf",
"partName": "aaaaaaaa",
"attributeGroup":[
{
"groupId": "GroupNaterId:123456768",
"name": null
},
{
"groupId": "GroupNaterId:123456768",
"name": "noName"
}

]
},
{
"eventId": "111-ewq-111-erwf",
"partName": "bbbbbbb",
"attributeGroup":[
{
"groupId": "GroupNaterId:1245543",
"name": null
},
{
"groupId": "GroupNaterId:1247777",
"name": "productName1"
},
{
"groupId": "GroupNaterId:12333333",
"name": "productName2"
}
]
}
]
}

Regards: Peter

Re: Rewriting of an array from one local JSON file to another problem.

vapukov — Wed, 16 Nov 2016 11:17:22 GMT

as variant, something like this:
in Your case You can test 2 lines:

$.product[1].eventId
$.product[1].attributeGroup[_star_]

product[1] - first event, and etc
attributeGroup - will be transferred as single element with all dependencies, if need parse them also - need edit, like

$.product[1].attributeGroup[1].groupid
$.product[1].attributeGroup[1].name

after this single record easy parsed to flat structure or other JSON file, just loop over all
it small example from HubSpot project, in Your case result[XXX] need change to product[XXX]

topic Re: Rewriting of an array from one local JSON file to another problem. in Talend Studio

Rewriting of an array from one local JSON file to another problem.

Re: Rewriting of an array from one local JSON file to another problem.