Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt
hiddentrue

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)

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 :

&lt<?xml version="1.0" encoding="ISO-8859-1"?&gt &ltstore&gt &ltthing > <store> <thing category="X1"&gt &ltname&gtItem1&lt/name&gt &ltprice&gt15.00&lt/price&gt &lt/thing&gt &ltthing > <name>Item1</name> <price>15.00</price> </thing> <thing category="X2"&gt &ltname&gtItem2&lt/name&gt &ltprice&gt17.99&lt/price&gt &lt/thing&gt &lt/store&gt> <name>Item2</name> <price>17.99</price> </thing> </store>

xmlToItems($xml, "/store/thing/price")

Returns the values :

15.00

17.99

See Also