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: 
Anonymous
Not applicable

Convert String to Json

Hello,

 

I have JSON String coming input via DB/Hive query, and not as JSON File. and Looking to convert that into JSON so I can read each of element. any suggestion? I tried to map to tExtractJSONFields  but it need JSON object will ends error 

Exception in thread "main" java.lang.NoSuchFieldError: defaultReader
at com.jayway.jsonpath.spi.json.JsonSmartJsonProvider.<init>(JsonSmartJsonProvider.java:39)
at com.jayway.jsonpath.internal.DefaultsImpl.jsonProvider(DefaultsImpl.java:21)
at com.jayway.jsonpath.Configuration.defaultConfiguration(Configuration.java:174)
at com.jayway.jsonpath.internal.JsonContext.<init>(JsonContext.java:52)
at com.jayway.jsonpath.JsonPath.parse(JsonPath.java:596)
at dtj.btj.samplebatch.tHiveInput_1Process(samplebatch.java:1695)

 

Labels (4)
1 Reply
manodwhb
Champion II
Champion II

@CodeDcode ,if i understand correctly, you need to convert a json whay right from input string then you need to use tWriteJson component.