Hours: Horeko Hours
read only REST
- Catalog:
Horeko - Schema:
Hours - Label: Hours
Returns list of clocked hours Returns list of clocked hours in specified date range. Max batch size is 100 records.
Can only retrieve data.
API Source
- Endpoint:
/v4/hours - Operation:
get /v4/hours
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
from |
`` | 01/01/2020 00:00:00 | Range start | |
last |
`` | returns clocked hours updated after this value | ||
status |
`` | clocked hours status: 0-Undecided | 1-Approved | 2-Disapproved (Values: 0, 1, 2) | ||
to |
`` | 12/31/2999 00:00:00 | Range end |
Table Columns
The columns of the table Hours 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 |
|---|---|---|---|---|---|
Break |
int32 |
Break Length | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_employeenumber | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_firstname | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_fullname | |||
Clocked |
int32 |
itgen_horeko_clockedinby_id | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_imagepath | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_lastname | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_middlename | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_employeenumber | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_firstname | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_fullname | |||
Clocked |
int32 |
itgen_horeko_clockedoutby_id | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_imagepath | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_lastname | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_middlename | |||
Clock |
int32 |
Clock-in Method | 0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app | ||
Clock |
int32 |
Clock-out Method | 0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app | ||
Comment |
varchar2 |
Comment | |||
Department |
varchar2 |
Department Name | |||
Employee_ |
varchar2 |
itgen_horeko_employee_employeenumber | |||
Employee_ |
varchar2 |
itgen_horeko_employee_firstname | |||
Employee_ |
varchar2 |
itgen_horeko_employee_fullname | |||
Employee_ |
int32 |
Employee ID | |||
Employee_ |
varchar2 |
itgen_horeko_employee_imagepath | |||
Employee_ |
varchar2 |
itgen_horeko_employee_lastname | |||
Employee_ |
varchar2 |
itgen_horeko_employee_middlename | |||
End |
datetime |
End | |||
Id |
int32 |
ID | |||
Manager |
varchar2 |
Manager Comment | |||
Rounded |
datetime |
Rounded End | |||
Rounded |
datetime |
Rounded Start | |||
Shift_ |
int32 |
itgen_horeko_shift_break | |||
Shift_ |
datetime |
itgen_horeko_shift_end | |||
Shift_ |
int32 |
Shift ID | |||
Shift_ |
varchar2 |
itgen_horeko_shift_name | |||
Shift_ |
datetime |
itgen_horeko_shift_start | |||
Start |
datetime |
Start | |||
Status |
int32 |
Status | 0 = Undecided | 1 = Approved | 2 = Disapproved | ||
Status |
varchar2 |
itgen_horeko_statuschangedby_employeenumber | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_firstname | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_fullname | |||
Status |
int32 |
itgen_horeko_statuschangedby_id | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_imagepath | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_lastname | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_middlename | |||
Status |
datetime |
Status Changed Date Time | |||
Team |
varchar2 |
Team Name | |||
Undefined |
char |
Undefined Clocked-in Location | |||
Undefined |
char |
Undefined Clocked-out Location | |||
Worked |
double |
Worked Time Excluding Breaks | |||
Worked |
double |
Worked Time including Breaks |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: