topic Re: how to parse json data from html data in Talend Studio

how to parse json data from html data

charan3 — Sat, 16 Nov 2024 00:09:30 GMT

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'.

Re: how to parse json data from html data

Anonymous — Sun, 16 May 2021 22:40:34 GMT

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

Re: how to parse json data from html data

charan3 — Thu, 20 May 2021 05:56:55 GMT

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

Re: how to parse json data from html data

gjeremy1617088143 — Thu, 20 May 2021 06:47:22 GMT

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