Configuring the input data and the structure mappings - 7.3

ESB REST
Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > ESB components > ESB REST components
Data Quality and Preparation > Third-party systems > ESB components > ESB REST components
Design and Development > Third-party systems > ESB components > ESB REST components
Last publication date
2024-02-21

Procedure

  1. Double-click the tFileInputDelimited component to open its Basic settings view.
  2. Specify the input file in the File name field, fill the Header field with 1 to skip the header row, and keep the rest parameters as they are.
  3. Click the [...] button next to Edit schema to open the Schema dialog box, and edit the input schema as follows:

    • id, type Integer, 2 characters long, set as the key column

    • first_name, type String

    • last_name, type String

  4. Double-click the tXMLMap component to open the Map Editor.
  5. Rename the root node in the output table: right-click the node, select Rename from the contextual menu, and specify a new name in the pop-up dialog box, user in this example.
  6. Select all the three columns in the input table and drop them onto the user node, and select the Create as sub-element of target node option from the pop-up dialog box to set these columns as sub-elements of the user node. When done, click OK to validate the mappings and close the Map Editor.