Parsing JSON columns having dot

Anonymous — Mon, 27 Aug 2018 21:49:54 GMT

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,

Re: Parsing JSON columns having dot

Jesperrekuh — Mon, 27 Aug 2018 23:49:03 GMT

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

topic Re: Parsing JSON columns having dot in Talend Studio

Parsing JSON columns having dot

Re: Parsing JSON columns having dot