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...")
 
Line 17: Line 17:
     </CRM_HTA>
     </CRM_HTA>
</DATA>
</DATA>
</source>

Revision as of 20:41, 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>