dynamic json field with nested arrays

rk2019 — Sat, 16 Nov 2024 01:52:37 GMT

Hi Team,

I have a source file in json where I am getting dynamic array having extra field and some with nested array and some doesn't have nested array , can you please suggest how I can approach this scenario .

Need is to convert into psv file and then load into redshift Table. Appreciate your help, Thanks!.

Here is the sample json

[ { "Manufacturer Name": "ABC Corp",

"SML ID": "S935309333",

"EBP ID": "195558332",

"AID": "A5",

"Registration Status": "NotInvited",

"Qualification Status": "Qualified",

"Integrated to ERP": "Integrated",

"name2" : "ABC",

"name3" : "XYZ"

{ "Manufacturer Name": "GHY Corp",

"SML ID": "J878333",

"EBP ID": "998433332",

"AID": "A7",

"Registration Status": "Invited",

"Qualification Status": "Qualified",

"Integrated to ERP": "Integrated",

"Department": [

{

"Qualification Status": "Qualified",

"Preferred Status": "",

"Category": "7838383",

"Region": "APAC",

"Unit": null,

"Item ID": null,

"Process Type": null

{

"Qualification Status": "Qualified",

"Preferred Status": "",

"Category": "7838383",

"Region": "APAC",

"Unit": null,

"Item ID": null,

"Process Type": null

]

Re: dynamic json field with nested arrays

vikramk — Fri, 17 Jul 2020 04:53:06 GMT

Talend doesn't support Dynamic schema for json files, here you can Talend data mapper if you are using Enterprise edition or else you can use with multiple input json files. For example for this requirement, only for Department you can use separate input file define the root for this, for remaining fields you can use one input json file.

topic Re: dynamic json field with nested arrays in Talend Studio

dynamic json field with nested arrays

Re: dynamic json field with nested arrays