Error itgendoc001X
xMsg javascript has not been loaded.
Simplicate API Data ModelFetches the approval status of each day for each employee
Catalog: Simplicate
Schema: Hours
Can retrieve data and change data using insert, update and delete.
Select Simplicate API URL: /hours/approval
Insert Simplicate API URL: /hours/approval
Update Simplicate API URL: /hours/approval
Delete Simplicate API URL: /hours/approval
Field Selection Method: NotRequired
Base Path: data[*]
Select Simplicate API Operation: get /hours/approval
Insert Simplicate API Operation: post /hours/approval
Update Simplicate API Operation: put /hours/approval/{id}
Delete Simplicate API Operation: delete /hours/approval/{id}
Table Function Columns
The columns of the table function HourApprovals 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 |
|---|---|---|---|---|
approvalstatus_description |
string |
|
☐ |
|
approvalstatus_id |
string |
|
☐ |
|
approvalstatus_label |
string |
|
☐ |
|
date |
string |
|
☐ |
|
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 |
|
☐ |
|
id |
string |
ID |
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152
