| Get XPath Result | |
|---|---|
| Name | GetXPathResult |
| Purpose | Evaluate an XPath expression |
| Category | Data Exchange |
| Returns | True if successful |
| Version | 2.1.15+ |
The GetXPathResult Activity evaluates an XPath expression in XML data. This data is typically provided by the ReadXPathDocument activity or a predecessing GetXPathResult activity.
Arguments
| Argument | Type | Direction | Purpose |
|---|---|---|---|
| XPathDocument | String | In | The XML data to evaluate the expression on |
| XPathExpression | String | In | The XPath expression |
| XPathNavigator | XPathNavigator | In | The XPathNavigator object to evaluate the expression on; overrules XPathDocument if set |
| XPathResult | List<XPathNavigator> | Out | All XML data as XPathNavigator objects where expression evaluated true |
| Result | Boolean | Out | Returns True on success, false on error |
Usage
This activity is typically used to find specific data within XML data, that was either provided by a ReadXPathDocument activity or by a previous GetXPathResult activity. Given the powerful capabilities of XPath, this activity can be used to extract literally any data from any XML structure.
Testing expressions
To simplify the creation of a valid XPath expressions, this activity features an expandable designer that allows the testing of expressions against loadable XML files. Expand the activity in the designer canvas and click the button ... to bring up a file open dialog, select a valid file and confirm with OK. If the file was successfully loaded it will be displayed as a tree structure directly in the designer. You can now start typing XPath expressions in the Expression box, they will be evaluated immediately as you type and return the filtered result in the tree view.
Example
Evaluate the following XML file against all elements that are named SAPObject, independently of the hierarchy level they appear:
<sapid>1234</sapid>
</SAPObject>
<SAPObject>
<guid>68cfff15-e253-4bc5-9290-d7c0babbe093</guid>
<descr>SAP 2 best description ever</descr>
<name>SAP_2_UPDATED</name>
</SAPObject>
<CADObject>
<cadid1>1234</cadid1>
<cadid2>5678</cadid2>
</CADObject>
<Company>
<name>kno</name>
<ComosObject>
<uid>A2NKM67ENE</uid>
<name>FVB901.199</name>
<description0>2-Wege-Regelventil132</description0>
<description1>2-Way-Valve</description1>
<ref_sap><sapid>1234</sapid></ref_sap>
<ref_cad>
<cadid1>1234</cadid1>
<cadid2>5678</cadid2>
</ref_cad>
<ref_cad_guid>adcd84d3-02c8-4cd2-9a00-8a6183b3ac5e</ref_cad_guid>
<rel_sap prop1="aaa" prop2="bbb">
<sapid>1234</sapid>
</rel_sap>
<rel_cad prop1="ccc">
<cadid1>1234</cadid1>
<cadid2>5678</cadid2>
</rel_cad>
<rel_sap_guid>68cfff15-e253-4bc5-9290-d7c0babbe093</rel_sap_guid>
</ComosObject>
</Company>
| Argument | Value |
|---|---|
| XPathDocument | Connect this argument with a variable |
| XPathExpression | "//SAPObject" |