Last updated 2 years ago
Was this helpful?
The XPathList() function executes the given XPath query on XML text and returns the result as a text array.
XPathList()
Follow to learn more about XPath.
This function is NOT SQL compatible. For more information about SQL compatibility, see our .
Returns an text array that is the result of an xpath query. Returns Invalid expression if the parameters are not valid according to type.
Invalid expression
XPathList(
xml
,
xpath
)
XPathList([Settings.BookStoreXml], "//book/price[text()]") => 30.00, 29.99, 49.99, 39.95
XPathList([Settings.BookStoreXml], "//book/price[text()]")
text
Text that contains XML
Text that contains an XPath query