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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Parsing JSON columns having dot

I am trying to parse a JSON message that has attributes with period ("."), e.g. store.code

"properties": {
"path": "/abc/*",
"parentLocation": "/abc/xyz",
"location": "xxxxxx",
"status.message": "xxxxxx.",
"store.code": xxxx
}

I use tFileInputJSON and JSONPath Query to get the attributes value. When I use "$.properties.store.code" as Jsonpath query, I get the following error:

"can't find any data with JSONPath $.properties.store.code"

I also tried:

$.properties['store.code']

That doesn't work either.

Could somebody help me with this? I am using TOS 5.6.

Thanks,

 

Labels (3)
1 Reply
Jesperrekuh
Specialist
Specialist

I dont think its possible.

This advanced use of JSON keys are referred as complex types.

In javascript its not a problem but while reading... you are not the only one face this type of problem.

 

Suggest adjusting the json / reshape to work with it.

Or write some custom code using JSON Pointer ... you then work with //properties/store.code :

JSON Pointer API