HourTimesheetsByDatesAndEmployeeId: Simplicate itgen_spe_hourtimesheetsbydatesandemployeeid_plural
read only REST
- Catalog:
Simplicate - Schema:
Hours - Label: itgen_spe_hourtimesheetsbydatesandemployeeid_plural
Fetches timesheet rows, by date, for an employee
Can only retrieve data.
API Source
- Endpoint:
/hours/timesheetrow - Operation:
get /hours/timesheetrow
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
employee_ |
`` | |||
end_ |
`` | Y-m-d, must be the Sunday after the Monday of the start_date | ||
start_ |
`` | Y-m-d, must be a Monday |
Table Columns
The columns of the table HourTimesheetsByDatesAndEmployeeId 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 |
|---|---|---|---|---|---|
employee_ |
varchar2 |
Employee ID | |||
end_ |
varchar2 |
End Date | |||
id |
varchar2 |
ID | |||
itemtype_ |
char |
itgen_spe_itemtype_has_workflow | |||
itemtype_ |
varchar2 |
itgen_spe_itemtype_id | |||
itemtype_ |
varchar2 |
itgen_spe_itemtype_id_2 | |||
itemtype_ |
char |
itgen_spe_itemtype_is_attachment_allowed | |||
itemtype_ |
char |
itgen_spe_itemtype_is_unit_tariff | |||
itemtype_ |
varchar2 |
itgen_spe_itemtype_name | |||
itemtype_ |
varchar2 |
itgen_spe_itemtype_unit_name | |||
order |
int64 |
Order | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
person_ |
varchar2 |
Person Full Name | |||
person_ |
varchar2 |
Person ID | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
itgen_spe_project_id_2 | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Number | |||
project_ |
varchar2 |
itgen_spe_project_service_id | |||
project_ |
varchar2 |
itgen_spe_project_service_id_2 | |||
project_ |
varchar2 |
itgen_spe_project_service_name | |||
project_ |
varchar2 |
itgen_spe_project_service_purchase_end_date | |||
project_ |
varchar2 |
itgen_spe_project_service_purchase_start_date | |||
project_ |
varchar2 |
itgen_spe_project_service_start_date | |||
project_ |
varchar2 |
itgen_spe_project_service_until_date | |||
start_ |
varchar2 |
Start Date | |||
type |
varchar2 |
Type |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: