# XPathList

{% hint style="info" %}
The **`XPathList()`** function executes the given XPath query on XML text and returns the result as a text array.

Follow [this link](https://en.wikipedia.org/wiki/XPath) to learn more about XPath.

This function is NOT SQL compatible. For more information about SQL compatibility, see our [documentation](https://docs.wem.io/platform/~/changes/y5gAfiyi2fILzrLzUUHj/wemreference/sql-compatibility).
{% endhint %}

{% hint style="success" %}
Returns an <mark style="color:green;">text array</mark> that is the result of an xpath query.\
Returns <mark style="color:red;">`Invalid expression`</mark> if the parameters are not valid according to type.
{% endhint %}

### Syntax

<details>

<summary><code>XPathList(</code><mark style="color:blue;"><code>xml</code></mark><code>,</code><mark style="color:blue;"><code>xpath</code></mark><code>)</code></summary>

`XPathList([Settings.BookStoreXml], "//book/price[text()]")`\
\=> *30.00, 29.99, 49.99, 39.95*

</details>

### Parameters

<table><thead><tr><th width="150">Name</th><th width="150">Type</th><th width="150" align="center">Required</th><th width="248.15953250810662">Description</th><th data-hidden>Required?</th></tr></thead><tbody><tr><td><mark style="color:blue;"><code>xml</code></mark></td><td>text</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>Text that contains XML</td><td>yes</td></tr><tr><td><mark style="color:blue;"><code>xpath</code></mark></td><td>text</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>Text that contains an XPath query</td><td>yes</td></tr></tbody></table>