Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Parse JSON with “empty key”

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

Labels (3)
1 Reply
Anonymous
Not applicable
Author

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