invantive documentation
Invantive Support ForumsLog In / Sign Up

Contracts: Horeko Contracts

read only REST

  • Catalog: Horeko
  • Schema: Contracts
  • Label: Contracts

Returns contracts Returns list of contracts. Available sort options: Id, StartDate, EndDate, ContractHours, WorkingDays. DaysOfWeek enum values: Sunday-0,Monday=1,Tuesday-2,Wednesday-3,Thursday-4,Friday-5,Saturday-6

Can only retrieve data.

API Source

  • Endpoint: /v4/contracts
  • Operation: get /v4/contracts

Parameters

Name Data Type Required Default Documentation
activeDate `` get only contracts that are active for this specific date (format yyyy-mm-dd hh:mm:ss)
sortBy `` comma separated list of available options for sorting
sortDescending `` true = descending | false = asceding. default is false

Table Columns

The columns of the table Contracts 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
AdditionalCostFactor double Additional Cost Factor
ContractHours double Contract Hours
ContractType_Id int32 itgen_horeko_contracttype_id
ContractType_Name varchar2 itgen_horeko_contracttype_name
DaysOfWeek varchar2 Days of Week
Employee_FirstName varchar2 itgen_horeko_employee_firstname
Employee_Id int32 Employee ID
Employee_LastName varchar2 itgen_horeko_employee_lastname
Employee_MiddleName varchar2 itgen_horeko_employee_middlename
EndDate datetime End Date
FunctionDescription varchar2 Function Description
Id int32 ID
StartDate datetime Start Date
WorkingDays int32 Working Days

Release Notes

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