fetch_query
Run read-only FetchXML queries against an allowlisted environment and retrieve result rows as dictionaries. Enforces a row cap and sorts client-side.
Instructions
Run a read-only FetchXML query against an allowlisted environment (pac env fetch) and return rows as dicts. FetchXML cannot modify data. Rows are capped at max_rows (default from config, ceiling 5000): pac itself ignores top/count/page and would page through every record, so the server stops reading at the cap. pac also ignores ; the server sorts client-side when the result is complete. Values are pac's formatted strings. Prefer filters and explicit lists; the primary key column is always appended.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fetchxml | Yes | ||
| max_rows | No | ||
| environment | No |