Configuring tExtractXMLField to extract data from the returned execution result of the stored procedure - 7.3

MDM data processing

author
Talend Documentation Team
EnrichVersion
Cloud
7.3
EnrichProdName
Talend Data Fabric
Talend MDM Platform
task
Data Governance > Third-party systems > MDM components > MDM data processing components
Data Quality and Preparation > Third-party systems > MDM components > MDM data processing components
Design and Development > Third-party systems > MDM components > MDM data processing components
EnrichPlatform
Talend MDM Server
Talend MDM Web UI
Talend Studio

Procedure

  1. Double-click tExtractXMLField to open its Basic settings view.
  2. Click the [...] button next to Edit schema to open the schema editor.
  3. Add two columns to define the structure of the output data: name and price.
  4. Click OK to close the schema editor, and then click Yes in the Propagate dialog box.
  5. In the Loop XPath query field, enter result between quotes on which the loop is based.
    Each result of the stored procedure has the following syntax: <result><col0>val1</col1>...<colN>valn</colN></result> (where colN is the nth column in the SELECT clause).
    Warning:

    If a null value exists in a data record to be returned by the execution result of the stored procedure, some inconsistencies will occur between the column number and the value for this column in the returned data record.

  6. In XPath query column of the Mapping table, enter the exact node name on which the loop is applied: col0 and col1, respectively, between quotes.