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

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

how to parse json data from html data

I passed a rest api in the tRestClient and the api includes normal data and json data.when i am trying to print the data into the cosole using tlogrow the end result appeard as html data but i want to fetch json data too.in the TRestClient, the accepted type dropdown i selected "JSON". in the tExtractJson i selected JSON field as "string" and readby as "jsonpath" . how can i achieve this?

 

ERROR: Expected to find an object with property ['employees'] in path $ but found 'java.lang.String'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.

Labels (1)
  • Other

3 Replies
Anonymous
Not applicable

Hi

Can you try to use tRest component, this component returns a string body, print the string on the console using tLogRow to see what data it returns.

 

Regards

Shong

charan3
Contributor
Contributor
Author

I tried with tRest component too..still i'm not able to fetch json data.

gjeremy1617088143

Hi, have you tried to call the api with a tool like postman, just to see wich message the api return ? It can help for a better comprehension of the process.

Send me Love and Kudos