topic Re: Call tRestClient with Post by passing Json body in Talend Studio

Call tRestClient with Post by passing Json body

Anonymous — Sat, 16 Nov 2024 03:22:38 GMT

Hello,

I am actually starting to learn Talend and I have this scenario: I need to call Rest WS, get the results, transform data so that it respect q certqin metadata Schema, then call another Rest Webservice, to post the data. What I used as components are : TRestClient -> tExtractJsonField ->TMap -> tRestWebservice. In the latest WS, I need :

- Send request one by one so should I use flowToIterate

- From the flow coming from the TMap, how can I prepare a Json body to send it in the Post of tRestClient.

I am getting an error / javax.ws.rs.WebApplicationException: HTTP 400 Bad Request

Thanks

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 09:05:50 GMT

Hi
tRestClient requries a document as input request, you need to use a tXMLMap instead of tMap to build the document.

Or you can use tRest to call API and use tWriteJsonField to write a Json string and pass it to tRest.

Regards
Shong

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 10:09:04 GMT

Hello Shong

Thanks for the reply. Ok let's assume that I will use the txmlMap. So the flow will be like this

I am right? Now I still have javax.ws.rs.WebApplicationException: HTTP 400 Bad Request

NB: I am trying to send only one record. here my tXmlMap

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 10:17:33 GMT

Have you tried your API using Postman? Does it works? Can you show an example of Json string that are required as input request?

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 10:46:54 GMT

Yes I have tried with postman. This is the body that I send

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 11:58:14 GMT

The tXMLMap does not produce JSON. You need to send your JSON as a String to the tRestClient's "string" column. You also need to set the tRestClient up to receive JSON.

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 12:20:14 GMT

Hi,

After using the tXMLMap, the output is as below

How can I send it as Json String?

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 14:34:59 GMT

Create JSON and do not use the tXMLMap.

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 15:08:48 GMT

So shall I go for this solution instead of using a txmlMap

Re: Call tRestClient with Post by passing Json body

Anonymous — Tue, 04 Feb 2020 15:10:58 GMT

That would be a better approach if you want to produce JSON

Re: Call tRestClient with Post by passing Json body

Nordom_LH — Thu, 27 Feb 2020 18:27:51 GMT

Did you manage to sort out how to execute the trestclient?

How do you pass all field from input row to a json document inside the body of the trestclient.

Could trestclient body allow to mapped expected field to pass from the current row?

Re: Call tRestClient with Post by passing Json body

Anonymous — Thu, 27 Feb 2020 21:38:35 GMT

This is demonstrated in the solution image. If you read the rest of the post, the information is there.

Re: Call tRestClient with Post by passing Json body

Nordom_LH — Fri, 28 Feb 2020 08:24:18 GMT

Thanks for the hint, I have read the full post including image, I am still lost on what to do inside tmap and jsonwrite

Re: Call tRestClient with Post by passing Json body

Nordom_LH — Fri, 28 Feb 2020 09:20:23 GMT

I have sort it out: just need to put the loop in the first field int twritejsonfield, check the remove root node and ensure trestclient is fully configured in json, I now have to understand why null are transformed in []

Re: Call tRestClient with Post by passing Json body

Anonymous — Fri, 28 Feb 2020 09:24:48 GMT

Great news! I try to give enough information in my posts so that others can figure it out for themselves for similar issues. I find that you learn the product better if you have to struggle a little on your own

Re: Call tRestClient with Post by passing Json body

Nordom_LH — Fri, 28 Feb 2020 09:33:07 GMT

to fixe the null transformed [ ] : in Insert a tJavaRow with the following code right after your tWriteJsonField:

output_row.string = input_row.string.replaceAll(",?\"[a-zA-Z_0-9]*\":\\[\\]", "");

thanks to Jbalberge

initial post https://community.talend.com/t5/Design-and-Development/resolved-Empty-Null-fields-show-up-in-json-output/td-p/92913

Re: Call tRestClient with Post by passing Json body

Anonymous — Wed, 04 Mar 2020 11:22:04 GMT

In order to resolve the issue of Null array generated by the tWriteJsonField, yu need to declare the attribute as object and not String Like below

Re: Call tRestClient with Post by passing Json body

LuciusHunt — Wed, 07 Oct 2020 19:21:15 GMT

For me the following solution works:

tMap -> tWriteJSONField -> tRestClient

Here's the big picture:

Do not propagate schemas or retrieve schemas from a target component.

Especially not from the tRESTClient. This could destroy it's schemas and then you need to put a new one.