tExtractJSONFields - dot in the column names

[COW_WW]

Hello,

I'm using the tExtractJSONFields to extract fields from the API result.

Some of the API columns have dot in the column name. I'm getting NULLs for all the fields with dot in the name.

Is there any way to resolve it?

[SCTalend1656344690 · Accepted solution]

In the Json query, this syntax should work:

"$[\'A.DEPTID\']"

[COW_WW]

It worked! Thank you