WorkOrderTimeEntries: Robaws Work Order Time Entries
read only REST
- Catalog:
Robaws - Schema:
WorkOrderTimeEntries - Label: Work Order Time Entries
Search
Can only retrieve data.
API Source
- Endpoint:
/api/v2/work-order-time-entries - Operation:
get /api/v2/work-order-time-entries
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 91 |
| Full scan rows per minute | 56,419 |
| Point query rows per minute | 1,465 |
| Write rows per minute | 539 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
employee |
`` | |||
from |
`` | |||
search |
`` | |||
sort |
`` | |||
toDate |
`` | |||
updated |
`` | |||
with |
`` | |||
work |
`` |
Table Columns
The columns of the table WorkOrderTimeEntries are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
activity |
varchar2 |
Activity ID | filters on the platform, writable, activity |
||
archived |
datetime |
Archived at | filters on the platform, writable, archived |
||
article |
varchar2 |
Article ID | filters on the platform, writable, article |
||
billable |
decimal |
Billable Hours | filters on the platform, writable, billable |
Hours charged to the customer for this entry. When no billable hours were set, the worked hours are returned. | |
break |
decimal |
Break (minutes) | filters on the platform, writable, break |
||
cost |
decimal |
Cost Price | filters on the platform, writable, cost |
||
created |
datetime |
Created at | filters on the platform, writable, created |
||
deleted |
datetime |
Deleted at | filters on the platform, writable, deleted |
||
employee |
varchar2 |
Employee ID | filters on the platform, writable, employee |
||
end |
int32 |
End Time Hour | filters on the platform, writable, end |
||
end |
int32 |
End Time Minute | filters on the platform, writable, end |
||
extra |
varchar2 |
Extra Fields | writable | The JSON text of the nested object. | |
hour |
varchar2 |
Hour Type ID | filters on the platform, writable, hour |
||
hours |
decimal |
Hours | filters on the platform, writable, hours |
Hours worked on this entry. Aggregate hours here, on the entry, never on the work order: a work order filtered on one employee still carries the hours of every employee on it. | |
id |
varchar2 |
ID | filters on the platform, writable, id |
||
locked |
datetime |
Locked at | filters on the platform, writable, locked |
||
remark |
varchar2 |
Remark | filters on the platform, writable, remark |
||
sale |
decimal |
Sales Price | filters on the platform, writable, sale |
||
start |
int32 |
Start Time Hour | filters on the platform, writable, start |
||
start |
int32 |
Start Time Minute | filters on the platform, writable, start |
||
updated |
datetime |
Updated at | filters on the platform, writable, updated |
||
work |
datetime |
Work Order Date | filters on the platform, writable, work |
The work order's date. Read-only: an entry has no date of its own The date of the work order the entry belongs to (an entry has no date of its own). Entries recorded in the legacy time registration before version 2 are not part of this resource. | |
work |
varchar2 |
Work Order ID | filters on the platform, writable, work |
The work order the entry belongs to. Read-only: an entry moves with its work order |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Work |
employee |
Employees.id |
Textual | The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it. |
Work |
hour |
HourTypes.id |
Key | |
Work |
work |
WorkOrders.id |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: