query-records
Retrieve and filter PowerPlatform/Dataverse records using OData expressions. Specify the entity name, filter criteria, and max records to extract targeted data efficiently.
Instructions
Query records using an OData filter expression
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entityNamePlural | Yes | The plural name of the entity (e.g., 'accounts', 'contacts') | |
| filter | Yes | OData filter expression (e.g., "name eq 'test'" or "createdon gt 2023-01-01") | |
| maxRecords | No | Maximum number of records to retrieve (default: 50) |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"entityNamePlural": {
"description": "The plural name of the entity (e.g., 'accounts', 'contacts')",
"type": "string"
},
"filter": {
"description": "OData filter expression (e.g., \"name eq 'test'\" or \"createdon gt 2023-01-01\")",
"type": "string"
},
"maxRecords": {
"description": "Maximum number of records to retrieve (default: 50)",
"type": "number"
}
},
"required": [
"entityNamePlural",
"filter"
],
"type": "object"
}