query_entities
Retrieve Dynamics 365 CRM records by entity set, applying OData filters, field selection, sorting, and pagination to return only the needed data.
Instructions
Query entities from Dynamics 365 with optional filtering, sorting, and pagination
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Maximum number of records to return (default: 10, max: 5000) | |
| filter | No | OData filter expression (e.g., "statecode eq 0 and firstname eq 'John'") | |
| select | No | Comma-separated list of fields to retrieve (e.g., "firstname,lastname,emailaddress1") | |
| orderby | No | Order by clause (e.g., "createdon desc" or "lastname asc,firstname asc") | |
| entitySet | Yes | Entity set name (plural form, e.g., "contacts", "accounts", "opportunities") - NOT the entity logical name |