invantive documentation
Invantive Support ForumsLog In / Sign Up

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_id ``
end_date `` Y-m-d, must be the Sunday after the Monday of the start_date
start_date `` 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_id varchar2 Employee ID
end_date varchar2 End Date
id varchar2 ID
itemtype_has_workflow char itgen_spe_itemtype_has_workflow
itemtype_id varchar2 itgen_spe_itemtype_id
itemtype_id_2 varchar2 itgen_spe_itemtype_id_2
itemtype_is_attachment_allowed char itgen_spe_itemtype_is_attachment_allowed
itemtype_is_unit_tariff char itgen_spe_itemtype_is_unit_tariff
itemtype_name varchar2 itgen_spe_itemtype_name
itemtype_unit_name varchar2 itgen_spe_itemtype_unit_name
order int64 Order
organization_id varchar2 Organisation ID
organization_name varchar2 Organisation Name
organization_relation_number varchar2 itgen_spe_organization_relation_number
person_full_name varchar2 Person Full Name
person_id varchar2 Person ID
person_relation_number varchar2 itgen_spe_person_relation_number
project_id varchar2 Project ID
project_id_2 varchar2 itgen_spe_project_id_2
project_name varchar2 Project Name
project_project_number varchar2 Project Number
project_service_id varchar2 itgen_spe_project_service_id
project_service_id_2 varchar2 itgen_spe_project_service_id_2
project_service_name varchar2 itgen_spe_project_service_name
project_service_purchase_end_date varchar2 itgen_spe_project_service_purchase_end_date
project_service_purchase_start_date varchar2 itgen_spe_project_service_purchase_start_date
project_service_start_date varchar2 itgen_spe_project_service_start_date
project_service_until_date varchar2 itgen_spe_project_service_until_date
start_date varchar2 Start Date
type varchar2 Type

Release Notes

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