Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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