topic Re: Extracting Json Fields always fails in Talend Studio

Extracting Json Fields always fails

Basit — Sat, 16 Nov 2024 05:39:29 GMT

Hi,

I am trying to extract some JSON fields after a REST request but somehow I am not able to get the correct values. This is the job:

The value for version in tLogRow_3 is always empty

The JSON looks like this:

{
    "results": [
        {
            "attributes": {
                "name": "myName",
                "description": 0.0,
                "version": 1.0
            }
        }
    ]
}

With tLogRow Talend prints the following:

<?xml version="1.0" encoding="UTF-8"?>
<root><results><attributes><name>myName</name><description>0.0</description><version>1.0</version></attributes></results></root>

Now I want to extract the value for version by using tExtractJSONFields

I also get the following error message:

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

Talend can't print the value and I don't know what I am doing wrong. Would appreciate any help.

Regards,

Basit

Re: Extracting Json Fields always fails

Anonymous — Wed, 05 Jun 2019 15:25:03 GMT

Your response is coming as xml, but you're trying to parse it as json. Use the http header

Accept: application/json

to get a response in JSON format

Re: Extracting Json Fields always fails

Basit — Wed, 05 Jun 2019 16:21:05 GMT

Hi @evansdar,

I am already using this header. Somehow tLogRow prints it that way. Don't know why...

I think the issue is something else.

Re: Extracting Json Fields always fails

Anonymous — Wed, 05 Jun 2019 16:47:25 GMT

Your problem is with the tRestClient. You need to go to the Advanced Settings and untick "Convert Response To DOM Document". This is used to convert JSON to an XML document. You will also need to switch the column that your tExtractJSONFields component reads to the "string" column. JSON is returned as a String and XML as a Document (body).

Re: Extracting Json Fields always fails

Basit — Thu, 06 Jun 2019 10:10:42 GMT

Hi @rhall,

you are right! Totally forget about configuring that. I was just focused on the tExtractJSONFields component. Thank you

Re: Extracting Json Fields always fails

Anonymous — Thu, 06 Jun 2019 12:15:52 GMT

No problem. It is easily overlooked 🙂