xMsg javascript has not been loaded.
Fetches all leave for employees
Catalog: Simplicate
Schema: HRM
Retrieve: true
Insert: true
Update: true
Delete: false
Select Simplicate API URL: /hrm/leave
Insert Simplicate API URL: /hrm/leave
Update Simplicate API URL: /hrm/leave
Delete Simplicate API URL: /hrm/leave
Field Selection Method: NotRequired
Base Path: data[*]
Select Simplicate API Operation: get /hrm/leave
Insert Simplicate API Operation: post /hrm/leave
Update Simplicate API Operation: put /hrm/leave/{id}
The columns of the table function 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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
created_at |
string |
Created at |
☐ |
|
created |
string |
Created |
☐ |
|
description |
string |
Description |
☐ |
|
employee_amount |
float |
|
☐ |
|
employee_declarable |
string |
|
☐ |
|
employee_employee_id |
string |
|
☐ |
|
employee_id |
string |
Employee ID |
☐ |
|
employee_name |
string |
|
☐ |
|
employee_person_id |
string |
|
☐ |
|
employee_tariff |
float |
|
☐ |
|
end_date |
string |
End Date |
☐ |
|
hours |
float |
|
☐ |
|
id |
string |
ID |
☐ |
|
leavetype_affects_balance |
boolean |
|
☐ |
|
leavetype_blocked |
boolean |
|
☐ |
|
leavetype_color |
string |
|
☐ |
|
leavetype_id |
string |
|
☐ |
|
leavetype_label |
string |
|
☐ |
|
modified |
string |
Modified |
☐ |
|
start_date |
string |
Start Date |
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
year |
int64 |
|
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152