Function: xmlToItems()
Extracts nodes from a chunk of XML (a string) and creates a list of items - which can be processed just as any list of values in PhixFlow.
Returns null when the extract fails.
Syntax
xmlToItems(XML, XPath)
| Argument | Type | Description |
|---|---|---|
| XML | String | The full XML data, stored in a string variable. |
| XPath | String | XPath expression to extract data from the XML. Note : XPath is a w3 standard language for addressing parts of an XML document. For more details see www.w3.org/TR/xpath |
Examples
Where $xml is :
<?xml version="1.0" encoding="ISO-8859-1"?> <store> <thing category="X1"> <name>Item1</name> <price>15.00</price> </thing> <thing category="X2"> <name>Item2</name> <price>17.99</price> </thing> </store>
xmlToItems($xml, "/store/thing/price")
Returns the values :
15.00
17.99