Last updated 10 days 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 this link to learn more about XPath.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
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