query_records
Retrieve records from any Dataverse table with OData filters, field selection, sorting, and pagination. Pass a nextLink to fetch subsequent pages.
Instructions
Query records from a Dataverse table using OData. Supports $filter, $select, $orderby, $top, $expand, and pagination. When the result has hasNextPage=true, pass the returned nextLink to fetch subsequent pages.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Max records to return (1–5000). | |
| expand | No | OData $expand, e.g. "primarycontactid($select=fullname,emailaddress1)" | |
| filter | No | OData $filter, e.g. "statecode eq 0 and name eq 'Contoso'" | |
| select | No | Fields to return. Omit for all fields. | |
| orderBy | No | OData $orderby, e.g. "createdon desc" | |
| nextLink | No | Pagination cursor from a previous query_records call. | |
| tableName | Yes | Logical (schema) name of the Dataverse table, e.g. 'account' or 'crb69_myentity' |