topic Re: POST request with JSON data to tRESTClient component in Talend Studio

POST request with JSON data to tRESTClient component

Anonymous — Sat, 16 Nov 2024 10:36:21 GMT

How can I create POST request with JSON data using tRESTClient component? I can only successfully send XML Document. Should I put JSON data inside XML element? It seems that is the only way to send JSON data. I am using talend 5.5.1.

Re: POST request with JSON data to tRESTClient component

Anonymous — Thu, 02 Jun 2016 22:32:01 GMT

You need to set the request header Content-Type to application/json. And no do not mix XML with JSON, this is a terrible idea!

Re: POST request with JSON data to tRESTClient component

Anonymous — Fri, 03 Jun 2016 06:30:38 GMT

Which component should I use ? tRESTClient or tREST ? I would like to use tRESTClient but it only inputs "Document" type of data and JSON data are String type.

Re: POST request with JSON data to tRESTClient component

Anonymous — Fri, 03 Jun 2016 08:52:53 GMT

The Document type is quite ok. This is the result of the tXMLMap or another document related components in Talend.
For an REST request you need an document.

Re: POST request with JSON data to tRESTClient component

Anonymous — Fri, 03 Jun 2016 09:14:07 GMT

So how can I use tRESTClient ? Right now the problem is that JSON data is in String and tRESTClient needs a Document data.

Re: POST request with JSON data to tRESTClient component

Anonymous — Fri, 03 Jun 2016 13:27:51 GMT

Hello,
In the component tRESTClient, there are two fields : 'body' and 'string'. You need to juste put your string json in the field 'string' of the tRESTClient.
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: POST request with JSON data to tRESTClient component

Anonymous — Sat, 04 Jun 2016 21:58:48 GMT

when I put string into a tRestclient's string filed I always get null on the other side inside a service. But the body gets through. What am I doing wrong?

Re: POST request with JSON data to tRESTClient component

Anonymous — Mon, 06 Jun 2016 13:06:55 GMT

The other side you mean the output? In the output, there are also body and string. But it's not body and string of the input. If you choose the option 'Convert Response To DOM Document', the result of the ouput will be put in the body. If not, the result will be put in the string.
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: POST request with JSON data to tRESTClient component

Anonymous — Mon, 06 Jun 2016 14:20:33 GMT

On the other side I mean on the service side.
I have 2 jobs, one is consumer that has tRestClient component. The tRestClient component has 2 inputs body and string. I am inputing both body and string.
The second jobs is a service. In this job tRestResponse component outputs the string and body that was inputed in previosuly mentioned tRestClient component.
My problem is that from tRestResponse component i get out body but not string. String is always null no metter the input.
What should I do so the string won't be null? Right now from tRestResponse component I would also like to recive a string not just body.

Re: POST request with JSON data to tRESTClient component

Anonymous — Mon, 06 Jun 2016 17:23:23 GMT

I am using talend 5.5.1 and there is no 'Convert Response To DOM Document' option?
Is there something I can do in 5.5.1 version to transfer JSON data to the service and not inside XML?

Re: POST request with JSON data to tRESTClient component

Anonymous — Tue, 07 Jun 2016 16:22:27 GMT

For the component tRestClient, you don't need to put both body and string in the same time. If you want to put a xml, you use body, if not, you put just in string. There is not the option 'Convert Response To DOM Document' in the version 5.5.1? I use the version 6. Could you put a screenshot of 'Advanced settings' for your component tRestClient?
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: POST request with JSON data to tRESTClient component

Anonymous — Tue, 07 Jun 2016 17:28:45 GMT

For the component tRestClient, you don't need to put both body and string in the same time.

You need to, otherwise it won't compile.
You can see that there is now 'Convert Response To DOM Document' option.

Re: POST request with JSON data to tRESTClient component

Anonymous — Tue, 07 Jun 2016 17:32:11 GMT

You can see that there is now 'Convert Response To DOM Document' option.

Re: POST request with JSON data to tRESTClient component

Anonymous — Tue, 07 Jun 2016 17:35:18 GMT

Re: POST request with JSON data to tRESTClient component

Anonymous — Wed, 08 Jun 2016 13:08:04 GMT

Can you update your talend to 5.5.2? There is this option from the version 5.5.2.
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: POST request with JSON data to tRESTClient component

Anonymous — Wed, 08 Jun 2016 15:48:35 GMT

no I cannot upgrade.

Re: POST request with JSON data to tRESTClient component

Anonymous — Thu, 09 Jun 2016 14:51:41 GMT

For the component tRestClient, you don't need to put both body and string in the same time.

You need to, otherwise it won't compile.
You can see that there is now 'Convert Response To DOM Document' option.
http://imgur.com/f7DfHAx

This is not strictly true. While you need to connect from one component to the tRestClient supplying a "string" and "body" column, they do not both need to actually be populated with anything.
If you simply supply a correct formatted JSON String to the "string" column and leave the "body" column empty, the service you are calling will receive the JSON. It will be converted to XML and will be received via the body Document column (you will need to create this), but it will be received.

Re: POST request with JSON data to tRESTClient component

Anonymous — Sun, 12 Jun 2016 09:17:43 GMT

If you simply supply a correct formatted JSON String to the "string" column and leave the "body" column empty, the service you are calling will receive the JSON.

I cannot crete this kind of job.
Can you tell me how to set components to achieve this?
Right now I have consumer job with:
tfixedflow--tXMLmap--tRESTClient
And service with
tRESTRequest--tXMLmap--RESTResponse
If I do like you said I get null inside 'string'.

Re: POST request with JSON data to tRESTClient component

Anonymous — Sun, 12 Jun 2016 17:11:59 GMT

I assume you mean that you receive null inside "string" in the service. The service will not receive a "string" value, it will receive a "body" document. The JSON will be translated to a XML document.

Re: POST request with JSON data to tRESTClient component

Anonymous — Mon, 13 Jun 2016 13:12:19 GMT

It doesnt work.
If on the client side I leave body empty and put JSON inside string and
on the service side if I try to get JSON from the body I get an runtime error.
But this works:
If I put JSON inside XML and inside body and If I set tRESTClient that accepts JSON, I get JSON on the service side from body.