Hours: Horeko Hours
read only REST
- Catalogus:
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.
Kan alleen gegevens ophalen.
API-bron
- Eindpunt:
/v4/hours - Operatie:
get /v4/hours
Parameters
| Name | Datatype | 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 |
Tabelkolommen
De kolommen van de tabel Hours worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation | |||||
|---|---|---|---|---|---|---|---|---|---|---|
Break |
int32 |
Pauzeduur | ||||||||
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 |
Inklokmethode | 0 = Fingerprint \ | 1 = Android app \ | 2 = iOS app \ | 3 = PIN \ | 4 = Manager \ | 5 = Web app | ||
Clock |
int32 |
Uitklokmethode | 0 = Fingerprint \ | 1 = Android app \ | 2 = iOS app \ | 3 = PIN \ | 4 = Manager \ | 5 = Web app | ||
Comment |
varchar2 |
Comment | ||||||||
Department |
varchar2 |
Afdelingsnaam | ||||||||
Employee_ |
varchar2 |
itgen_horeko_employee_employeenumber | ||||||||
Employee_ |
varchar2 |
itgen_horeko_employee_firstname | ||||||||
Employee_ |
varchar2 |
itgen_horeko_employee_fullname | ||||||||
Employee_ |
int32 |
Werknemer 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 Commentaar | ||||||||
Rounded |
datetime |
Afgerond Uiteinde | ||||||||
Rounded |
datetime |
Afgerond Begin | ||||||||
Shift_ |
int32 |
itgen_horeko_shift_break | ||||||||
Shift_ |
datetime |
itgen_horeko_shift_end | ||||||||
Shift_ |
int32 |
Dienst-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 Gewijzigd Datum/tijd | ||||||||
Team |
varchar2 |
Teamnaam | ||||||||
Undefined |
char |
Ongedefinieerde Ingeklokte Locatie | ||||||||
Undefined |
char |
Ongedefinieerde Uitgeklokte Locatie | ||||||||
Worked |
double |
Werktijd exclusief Pauzes | ||||||||
Worked |
double |
Gewerkte Tijd inclusief Pauzes |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: