Configuring the body of the response

Procedure

Connect tRESTRequest to tXMLMap using the Row > UserInfo connection.
Double-click tXMLMap in the design workspace to open the Map Editor.
Right-click on the root node of the input table and select Create Sub-Element. Name the sub-element as person in the popup dialog box.
Right-click on the person node created in the previous step and select As loop element.
Create two sub-elements to the person node by selecting Create Sub-Element in the contextual menu, id and name in this use case.
Click the [+] button on the top right to add an output and name it as Response.
Click the [+] button on the bottom right to add a column body of Document type for the output.
Right-click the node root in the output table and select Create Sub-Element. Name the sub-element as person in the popup dialog box.
Right-click the person node created in the previous step and select As loop element.
Create three sub-elements to the person node by selecting Create Sub-Element in the contextual menu, id, name and company in this use case.
Select the id column from the input table and drop it onto the Expression field of the id node of the output table.
Select the name column from the input table and drop it onto the Expression field of the name node in the output table.
Click the Expression field of the name node in the output table, and click [...] in this field to show the Expression Builder wizard.

In the Expression area, enter StringHandling.UPCASE([UserInfo.body:/root/person/name]) to convert the name of the user to upper case. Click OK to close the wizard.

For further information about using the Expression Builder, see Writing code using the Expression Builder.
In the Expression field of the company node, enter "Talend".
Click OK to save the settings.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here