invantive documentation
Invantive Support ForumsLog In / Sign Up

Leaves: Simplicate Leaves

insert update REST

  • Catalog: Simplicate
  • Schema: HRM
  • Primary Keys: id
  • Label: Leaves

Fetches all leave for employees

Can retrieve data and change data using insert and update.

API Source

  • Endpoint: /hrm/leave
  • Operation: get /hrm/leave

Table Columns

The columns of the table Leaves 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
created varchar2 Created
created_at varchar2 Created at
description varchar2 Description
employee_amount double Employee Amount
employee_declarable varchar2 Employee Declarable
employee_employee_id varchar2 Employee ID
employee_id varchar2 Employee ID
employee_name varchar2 Employee Name
employee_person_id varchar2 Employee Person ID Added in order to comply with the original sales/sales responsible_employee response
employee_tariff double Employee Tariff
end_date varchar2 End Date
hours double Hours
id varchar2 ID
leavetype_affects_balance char itgen_spe_leavetype_affects_balance
leavetype_blocked char itgen_spe_leavetype_blocked
leavetype_color varchar2 itgen_spe_leavetype_color
leavetype_id varchar2 itgen_spe_leavetype_id
leavetype_label varchar2 itgen_spe_leavetype_label
modified varchar2 Modified
start_date varchar2 Start Date
updated_at varchar2 Updated at
year int64 Year

Release Notes

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