How to read JSON file with multiple arrays in a node

[Anonymous]

I am using Talend for BigData 6.3.1 and trying to read JSON file with below format using tFileInputJSON(JsonPath without Loop) and tExtractJSONFields(XPath). I am able to extract records up to one level but unable to split it further. Now I need help to extract data under the fields rows, cells and field_def. 

Sample.json

{
columns {}
top_level_rows [1,2,...10]
rows:{
1 {
ref
child_refs -- empty array []
id
}
....
10 {
ref
parent_ref
child_refs
id
}
}
cells
[[ --(embedded array [])
[[
{
id
value
id
name
row
},
....
{
id
value
id
name
row
}
]],
[[
{
id
value
id
name
row
},
....
{
id
value
id
name
row
}
]],, ....
]]
field_def:
{
11: {
ref
table
}
.....
20: {
ref
table
}
}
}

I am new to Talend and need help to proceed. I googled a lot but unable to find anything for such scenarios.

Regards,

Keerthi

[Anonymous]

Hello,

Please try to two tExtractJSONField components in your job design.

Could you please take a look at this topic about:https://community.talend.com/t5/Design-and-Development/JSON-Array-values-to-Rows-is-there-a-better-w... to see if it is OK with your use case?

Best regards

Sabrina

[Anonymous · Accepted solution]

Thanks Sabrina. This link help me to understand further.

Perfect solution I was looking for is in https://community.talend.com/t5/Design-and-Development/Parsing-JSON-with-tExtractJSONFields/m-p/1596...

Just posting here so that it might help others

[Anonymous]

Thanks for cross-referencing and posting the solution