XML (Xpath): Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "=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 Refre...")
 
 
(One intermediate revision by the same user not shown)
Line 17: Line 17:
     </CRM_HTA>
     </CRM_HTA>
</DATA>
</DATA>
</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