query_odata_v4
Query Acumatica ERP data through OData v4 by selecting DAC entities, applying filters, and limiting returned fields for analytics.
Instructions
Query any Acumatica DAC table directly via OData v4. Exposes raw DAC entities (e.g. SOOrder, BAccount, InventoryItem, GLTran, APTran, INTran). Use list_odata_v4_entities to discover valid entity names. Supports OData $filter, $select, $orderby, $top, and $skip. IMPORTANT: Large tables (e.g. GLTran) will timeout without a filter — always apply a date range or other filter. Always use $select to limit returned fields.
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. Date fields require datetimeoffset format: "TranDate gt 2026-01-01T00:00:00Z". String fields use single quotes: "Status eq 'N'" | |
| select | No | Comma-separated DAC field names to return, e.g. "OrderType,OrderNbr,CustomerID,Status" | |
| orderby | No | OData $orderby expression, e.g. "OrderDate desc" | |
| entityName | Yes | DAC entity name, e.g. "SOOrder", "BAccount", "InventoryItem", "GLTran" |