Parse JSON with “empty key”

Anonymous — Sat, 16 Nov 2024 05:06:07 GMT

Hi Team,

We are having a scenario in which we have a JSON with “empty key”. We are unable to parse data for the corresponding key.

Sample data as below.
{
"firstName": "John",
"lastName" : "doe",
"age" : 26,

"address" : {
"streetAddress": "naist street",
"city" : "Nara",
"postalCode" : "630-0192"
},
"phone.Numbers": [
{
"type" : "iPhone",
"number": "0123-4567-8888",
"" : "abcd",
},
{
"type" : "home",
"number": "0123-4567-8910",
"" : "pqr",
}
]
}
We are using JSON query for the same to parse in tFileInputJSON.
Please help if anyone came across with this scenario.

Regards,
Niraj

Re: Parse JSON with “empty key”

Anonymous — Thu, 01 Aug 2019 21:29:30 GMT

Hi @uganesh ,

You cannot read JSON with empty key.

My suggestion would be first replace all empty keys of the file using some pre-processing.

For example Read the whole file and replace '"" : ' with '"Empty_Key" : ' and create a new Json File and parse that file.

Thanks and Regards,

Subhadip

topic Re: Parse JSON with “empty key” in Talend Studio

Parse JSON with “empty key”

Re: Parse JSON with “empty key”