d365fo_query_entities
Query Dynamics 365 Finance & Operations data entities using simplified OData filtering with wildcard support, field selection, and pagination controls.
Instructions
Query D365FO data entities with simplified filtering capabilities.
Args: entity_name: The entity's public collection name or entity set name (e.g., "CustomersV3", "SalesOrders", "DataManagementEntities") select: List of field names to include in response filter: Simplified filter expression using only "eq" operation with wildcard support: - Basic equality: "FieldName eq 'value'" - Starts with: "FieldName eq 'value*'" - Ends with: "FieldName eq '*value'" - Contains: "FieldName eq 'value'" - Enum values: "StatusField eq Microsoft.Dynamics.DataEntities.EnumType'EnumValue'" Example: "SalesOrderStatus eq Microsoft.Dynamics.DataEntities.SalesStatus'OpenOrder'" order_by: List of field names to sort by (e.g., ["CreatedDateTime desc", "SalesId"]) top: Maximum number of records to return (default: 100) skip: Number of records to skip for pagination count: Whether to include total count in response expand: List of navigation properties to expand profile: Profile name for connection configuration
Returns: Dictionary with query results including data array, count, and pagination info
Note: This tool uses simplified OData filtering that only supports "eq" operations with wildcard patterns. For complex queries, retrieve data first and filter programmatically.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entity_name | Yes | ||
| select | No | ||
| filter | No | ||
| order_by | No | ||
| top | No | ||
| skip | No | ||
| count | No | ||
| expand | No | ||
| profile | No | default |