query_odata
Query Acumatica Generic Inquiries via OData, supporting $filter, $select, $orderby, $top, and $skip for targeted data retrieval.
Instructions
Query any Acumatica Generic Inquiry via OData. Use list_odata_entities first to find valid entity names. Supports OData $filter, $select, $orderby, $top, and $skip.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Max records to return (default 50, max 500) | |
| skip | No | Records to skip for pagination | |
| filter | No | OData $filter expression, e.g. "Status eq 'Open'" or "OrderDate gt '2025-01-01'" | |
| select | No | Comma-separated field names to return, e.g. "OrderNbr,CustomerID,OrderDate" | |
| orderby | No | OData $orderby expression, e.g. "OrderDate desc" | |
| entityName | Yes | Exact entity name from list_odata_entities, e.g. "SO-SalesOrder" or "AR-Customers" |