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

Announcements
Join us in Bucharest on Sept 18th 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.