DriveWorks Pro 23

XPathXMLGet

XPathXMLGet

Finds the value at a given path in an XML string.

Syntax

XPathXMLGet([Input Data],[Path])

Where:

Input Data is the input data on which to search.

Path is the path to find in the given data object.

Examples

Example XML Data being returned to the constant DWConstantXML

            <?xml version="1.0" encoding="UTF-8"?>
            <bookstore>
                 <book>
                    <title lang="en">Harry Potter</title>
                   <price>29.99</price>
                </book>
                <book>
                    <title lang="xml">Learning XML</title>
                    <price>39.95</price>
                    <difficulty>Easy</difficulty>
                   <category>Programming</category>
                </book>
            </bookstore>

<book>
    <title lang="en">Harry Potter</title>
    <price>29.99</price>
</book>
<book>
    <title lang="xml">Learning XML</title>
    <price>39.95</price>
    <difficulty>Easy</difficulty>
    <category>Programming</category>
</book>
                    

<book>
    <title lang="en">Harry Potter</title>
    <price>29.99</price>
</book>
                    

Example Using Text()

Embedding the Text() function withing the path string will return just the values of the element:

See also

This function relates to the Send HTTP Request task.

XPathGet

XPathJsonGet