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

If we add some xml into a $-variable:

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]

PhixFlow 8.3 Help

xmlToItems

Function: xmlToItems()

Syntax

Examples

See Also