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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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