/
xmlToItems

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

Related content

xmlToItems
xmlToItems
More like this
xmlToItems
xmlToItems
More like this
xmlToItems
xmlToItems
More like this
xmlToItems
xmlToItems
More like this
jsonToXML
jsonToXML
More like this
jsonToXML
jsonToXML
More like this