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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rk2019
Contributor
Contributor

tExtractJSONFields failing with null

I am processing 1.5 GB json file through a job where I am using tExtractJSONFields to extract 2 columns but getting below error,

 

 

tExtractJSONFields_1 Expected to find an object with property ['ResultDto'] in path $['Results'] but found 'null'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.

 

what could be the problem here? Thanks in Advance.

Labels (4)
2 Replies
vapukov
Master II
Master II

Hi,

 

old, but still good link - https://goessner.net/articles/JsonPath/ 

vapukov
Master II
Master II

Hi,

 

old, but still good link - https://goessner.net/articles/JsonPath/