Sending json data via tRESTClient

RA6 — Sat, 16 Nov 2024 03:37:39 GMT

Hello folks,

I am currently retrieving data from a database, convert it to json and trying to send it through Rest service to a url.

On execution, i am displaying the response using a tlog; the statusCode is "200" but the body and the string is empty:

[statistics] connecting to socket on port 3450
[statistics] connected
2020-01-09 19:46:29|Bgoo64|Bgoo64|Bgoo64|13788|Flux|_cXuq8BgoEeqgX817LbQYlg|0.1|platform||begin||
200||
200||
200||
2020-01-09 19:46:32|Bgoo64|Bgoo64|Bgoo64|13788|Flux|_cXuq8BgoEeqgX817LbQYlg|0.1|platform||end|success|2705
[statistics] disconnected
Job Flux_Recouvrement_2 ended at 19:46 09/01/2020. [exit code=0]

Can you advice please?

Thank you.

Re: Sending json data via tRESTClient

rmartin2 — Thu, 09 Jan 2020 21:02:50 GMT

Hi,

If you're giving a JSON, you need to send it via the "string" column, not the body. A JSON isn't a Document. Only XML can be.

So in input, send an empty Body, and a fields "string" in String, with your JSON inside, and you're good

Sincerely,

topic Sending json data via tRESTClient in Talend Studio

Sending json data via tRESTClient

Re: Sending json data via tRESTClient