XML (Xpath): Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
 
Line 18: Line 18:
</DATA>
</DATA>
</source>
</source>
your XPathQuery would look like this: DATA/CRM_ATH

Latest revision as of 20:42, 25 July 2019

Origin

As of Starfish v5.3, for the Origin, use the Select File link to select your file. You must then MANUALLY type the XPath Query into the XPath Query field. The Refresh link and Dropdown DO NOT WORK.

Example

If your XML file looks like this:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<DATA>
    <CRM_ATH>
        <ISSUE_NO>RMA-1</ISSUE_NO>
        <RMA_NO>RMA-1</RMA_NO>
        <CRMA_NO>RMA-1</CRMA_NO>
    </CRM_HTA>
    <CRM_ATH>
        <ISSUE_NO>RMA-2</ISSUE_NO>
        <RMA_NO>RMA-2</RMA_NO>
        <CRMA_NO>RMA-2</CRMA_NO>
    </CRM_HTA>
</DATA>

your XPathQuery would look like this: DATA/CRM_ATH