creatio_query_records
Query Creatio entities via OData with filter, orderby, select, and expand. Read-only GET for safe data retrieval.
Instructions
Query records from a Creatio entity via OData (read-only GET). Use OData syntax for filter/orderby, e.g. filter: "Number eq 'SR00042038'".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Max rows (clamped to 50). | |
| entity | Yes | OData entity set name, e.g. 'Case' or 'Contact'. | |
| expand | No | OData $expand for lookups, e.g. 'Owner'. | |
| filter | No | OData $filter expression. | |
| select | No | Columns to return, e.g. ['Id','Number','Subject']. | |
| orderby | No | OData $orderby, e.g. 'CreatedOn desc'. |