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