topic Re: tRESTResponse Sends a JSON string instead of JSON in Talend Studio

tRESTResponse Sends a JSON string instead of JSON

Anonymous — Mon, 29 Jun 2015 14:05:00 GMT

Hi,
I've a job where a web service extract documents from a MongoDB and sends them as one JSON Document,
TMongoInput --> tXMLMap --> tRESTResponse
My problem is that the documents contains an array and tRESTResponse sends it as a JSON string....

Re: tRESTResponse Sends a JSON string instead of JSON

Anonymous — Mon, 29 Jun 2015 14:08:59 GMT

Screenshots

Re: tRESTResponse Sends a JSON string instead of JSON

Anonymous — Mon, 29 Jun 2015 14:44:49 GMT

Talend does not convert JSON into a Document object. Only XML is handled as a Document by Talend. There are JSON Objects available in Java, but for some reason Talend doesn't use these. Possibly due to REST standards? There shouldn't be a problem sending an array in a JSON string format though.

Re: tRESTResponse Sends a JSON string instead of JSON

Anonymous — Mon, 29 Jun 2015 15:11:44 GMT

{msisdn": 320740071,"dep": "","profile_id": "","consumption": ""}I'm getting this result ! Consumption field is an array in the DB and the Web service is returning it like this !

Re: tRESTResponse Sends a JSON string instead of JSON

Anonymous — Mon, 29 Jun 2015 15:47:47 GMT

That is an array in JSON. You need to look here and make use of the " Generate JSON Document" option on the Advanced Settings tab of your output component.

Re: tRESTResponse Sends a JSON string instead of JSON

Anonymous — Tue, 30 Jun 2015 12:02:04 GMT

Thank you for your answer, well i'm trying to read from Db not inserting in it ... the problem is in tRESTResponse component it's not able to send Complex JSON structure (with nested array)... i think it's a bug !

Re: tRESTResponse Sends a JSON string instead of JSON

Anonymous — Tue, 30 Jun 2015 12:14:41 GMT

The tRESTResponse component needs to be configured to return a String and not a Document for JSON.