CenterView Help

xmlToItems

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 CenterView.

Returns null when the extract fails.

Syntax

xmlToItems(XML, XPath)

ArgumentTypeDescription
XMLStringThe full XML data, stored in a string variable.
XPathStringXPath 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

See Also

Please let us know if we could improve this page feedback@phixflow.com