Configuring the input data and the structure mappings

ESB REST

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend ESB
Talend Big Data Platform
Talend MDM Platform
Talend Data Services Platform
Talend Real-Time Big Data Platform
Talend Data Management Platform
Talend Data Integration
Talend Open Studio for Data Integration
Talend Data Fabric
Talend Open Studio for MDM
Talend Open Studio for ESB
Talend Big Data
Talend Open Studio for Big Data
task
Data Quality and Preparation > Third-party systems > ESB components > ESB REST components
Data Governance > Third-party systems > ESB components > ESB REST components
Design and Development > Third-party systems > ESB components > ESB REST components
EnrichPlatform
Talend Studio

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.