Query R365 OData Entity
r365_queryRun read-only OData queries on Restaurant365 entities like transactions, accounts, and locations. Filter, sort, and paginate results to retrieve specific financial or operational data.
Instructions
Run a read-only OData query against any R365 entity.
Args:
entity: OData view name (Location, Transaction, GlAccount, etc.)
filter: OData $filter expression (e.g. "date ge 2026-01-01T00:00:00Z")
select: OData $select comma-separated fields
orderby: OData $orderby expression
top: Max rows (default 100, max 1000)
skip: Offset for pagination
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | ||
| skip | No | ||
| entity | Yes | R365 OData entity/view name. Common: Location, Transaction, GlAccount, Employee, SalesEmployee. | |
| filter | No | ||
| select | No | ||
| orderby | No |