topic How to read JSON file with multiple arrays in a node in Talend Studio

How to read JSON file with multiple arrays in a node

Anonymous — Sat, 16 Nov 2024 07:26:40 GMT

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

Re: How to read JSON file with multiple arrays in a node

Anonymous — Mon, 22 Oct 2018 04:18:53 GMT

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-way/m-p/52229 to see if it is OK with your use case?

Best regards

Sabrina

Re: How to read JSON file with multiple arrays in a node

Anonymous — Thu, 30 May 2019 15:54:32 GMT

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/159610#M97394

Just posting here so that it might help others

Re: How to read JSON file with multiple arrays in a node

Anonymous — Thu, 30 May 2019 16:44:27 GMT

Thanks for cross-referencing and posting the solution