query_by_fetchxml
Executes FetchXML queries against Dataverse with explicit state policy and bounded paging, returning one page by default plus completeness and a continuation cursor.
Instructions
Execute FetchXML with explicit state policy and bounded native cookie/simple paging. Defaults to one page. Returns value, effective query, completeness and continuation; use fetch_all for multiple pages.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fetch_all | No | Follow server paging up to max_records/max_pages. Default false returns one page. | |
| fetch_xml | No | The FetchXML string to execute | |
| max_pages | No | Maximum server pages read per call, default 10, when fetch_all=true. | |
| page_size | No | Requested server page size, default 500. Cannot be combined with top. FetchXML count is preserved unless the same value is supplied. | |
| state_mode | No | legacy preserves valid implicit statecode=0 filtering; all adds no state filter; values uses state_values validated against this table. | |
| max_records | No | Maximum records returned in this call, default 5000. Remaining records can be resumed with continuation. | |
| continuation | No | Opaque cursor from a previous result; valid for five minutes in this server connection. Resumes saved query and buffered records. | |
| state_values | No | Explicit numeric state values; requires state_mode=values. | |
| formatted_values | No | Include formatted labels and display values returned by CRM. |