XML (Xpath)

From Starfish ETL
Jump to navigation Jump to search

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