| Excerpt | ||
|---|---|---|
| ||
xmlToItems(XML, XPath) Extracts nodes from a chunk of XML (a string) and creates a list of items |
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 :
If we add some xml into a $-variable:
| Code Block |
|---|
do( $xml = "<?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 (in a list):
[15.00, 17.99]