Query any OData entity set
exaktime_query_odataRead-only OData query over any Arcoro data warehouse entity set, for questions the other tools do not cover (equipment, expenses, users, time records by hour group, learning, performance, recruiting, benefits...). Entity sets start with Dw, e.g. DwUsers, DwEquipments, DwExpenses, DwCostCodes, DwLocations, DwTimeRecordByHourGroups, DwEmploymentStatusHistories. Full list: https://my.arcoro.com/api/odata ; schema: https://api.arcoro.com/odata/$metadata. $filter uses OData v4 syntax, e.g. startswith(LastName,'Sm') and IsActive eq true. Source: the read-only OData data warehouse, refreshed nightly, so today's entries may not show until tomorrow. Page with skip/next_skip. GET /odata/{EntitySet}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Rows to return, 1-1000 (default 100). | |
| skip | No | Rows to skip (default 0). Pass the previous reply's next_skip. | |
| filter | No | OData $filter expression. | |
| select | No | Comma-separated property names ($select). | |
| orderby | No | OData $orderby, e.g. LastName,FirstName desc. | |
| entity_set | Yes | Entity set name, e.g. DwUsers. |