invantive documentation
Invantive Support ForumsLog In / Sign Up

BreakHours: Horeko Breakhours

read only REST

  • Catalog: Horeko
  • Schema: Hours
  • Label: Breakhours

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
lastUpdatedOn `` 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 BreakHours 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
BreakLength int32 Break Length
ClockedInBy_EmployeeNumber varchar2 itgen_horeko_clockedinby_employeenumber
ClockedInBy_FirstName varchar2 itgen_horeko_clockedinby_firstname
ClockedInBy_FullName varchar2 itgen_horeko_clockedinby_fullname
ClockedInBy_Id int32 itgen_horeko_clockedinby_id
ClockedInBy_ImagePath varchar2 itgen_horeko_clockedinby_imagepath
ClockedInBy_LastName varchar2 itgen_horeko_clockedinby_lastname
ClockedInBy_MiddleName varchar2 itgen_horeko_clockedinby_middlename
ClockedOutBy_EmployeeNumber varchar2 itgen_horeko_clockedoutby_employeenumber
ClockedOutBy_FirstName varchar2 itgen_horeko_clockedoutby_firstname
ClockedOutBy_FullName varchar2 itgen_horeko_clockedoutby_fullname
ClockedOutBy_Id int32 itgen_horeko_clockedoutby_id
ClockedOutBy_ImagePath varchar2 itgen_horeko_clockedoutby_imagepath
ClockedOutBy_LastName varchar2 itgen_horeko_clockedoutby_lastname
ClockedOutBy_MiddleName varchar2 itgen_horeko_clockedoutby_middlename
ClockInMethod int32 Clock-in Method 0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app
ClockOutMethod int32 Clock-out Method 0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app
Comment varchar2 Comment
Comment_2 varchar2 itgen_horeko_comment_2
DepartmentName varchar2 Department Name
Employee_EmployeeNumber varchar2 itgen_horeko_employee_employeenumber
Employee_FirstName varchar2 itgen_horeko_employee_firstname
Employee_FullName varchar2 itgen_horeko_employee_fullname
Employee_Id int32 Employee ID
Employee_ImagePath varchar2 itgen_horeko_employee_imagepath
Employee_LastName varchar2 itgen_horeko_employee_lastname
Employee_MiddleName varchar2 itgen_horeko_employee_middlename
End datetime End
End_2 datetime itgen_horeko_end_2
Id int32 ID
Id_2 int32 itgen_horeko_id_2
ManagerComment varchar2 Manager Comment
Meal_Id int32 Meal ID
Meal_MealName varchar2 itgen_horeko_meal_mealname
Meal_MealPrice double itgen_horeko_meal_mealprice
RoundedEnd datetime Rounded End
RoundedStart datetime Rounded Start
Shift_Break int32 itgen_horeko_shift_break
Shift_End datetime itgen_horeko_shift_end
Shift_Id int32 Shift ID
Shift_Name varchar2 itgen_horeko_shift_name
Shift_Start datetime itgen_horeko_shift_start
Start datetime Start
Start_2 datetime itgen_horeko_start_2
Status int32 Status 0 = Undecided | 1 = Approved | 2 = Disapproved
StatusChangedBy_EmployeeNumber varchar2 itgen_horeko_statuschangedby_employeenumber
StatusChangedBy_FirstName varchar2 itgen_horeko_statuschangedby_firstname
StatusChangedBy_FullName varchar2 itgen_horeko_statuschangedby_fullname
StatusChangedBy_Id int32 itgen_horeko_statuschangedby_id
StatusChangedBy_ImagePath varchar2 itgen_horeko_statuschangedby_imagepath
StatusChangedBy_LastName varchar2 itgen_horeko_statuschangedby_lastname
StatusChangedBy_MiddleName varchar2 itgen_horeko_statuschangedby_middlename
StatusChangedDateTime datetime Status Changed Date Time
TeamName varchar2 Team Name
Type int32 Type 0 = Lunch | 1 = Smoke
UndefinedClockedInLocation char Undefined Clocked-in Location
UndefinedClockedOutLocation char Undefined Clocked-out Location
WorkedTimeExcludingBreaks double Worked Time Excluding Breaks
WorkedTimeIncludingBreaks double Worked Time including Breaks

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: