topic tXMLMap to string output in Talend Studio

tXMLMap to string output

ppkabore — Sat, 16 Nov 2024 02:55:41 GMT

Hi,

I started my first Talend project and have implemented few jobs with ease. Now I want to send REST Post request using json as the request body. So I used these components: tDBInput -> tXMLMap -> tRestClient. In tXMLMap the output schema has 2 columns: body of type Document and string of type string. It worked once and then stop working. I replaced the tRestClient with tLogRow and see that the string column in the output is null, however the document column is correct. How to get tXMLMap to populate the string output column.I used TOS ESB 7.2.1 and TOS ESB 7.3.1 with same result. I know I can use other components but like to know what I'm missing here.

Thanks in advance.

Re: tXMLMap to string output

manodwhb — Sun, 22 Mar 2020 07:30:14 GMT

Body column you need to convert document to string then use tjavarow component and use the function String.value of (row1.body).

Re: tXMLMap to string output

ppkabore — Thu, 26 Mar 2020 12:11:39 GMT

I got it ok by removing the string column in the tRestClient input schema. That forced Talend to pass the body column to tXMLMap, instead of the string column.

Thanks.