Timers: Simplicate Timers
insert update delete REST
- Catalog:
Simplicate - Schema:
Hours - Primary Keys:
id - Label: Timers
Fetches all timers
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/timers/timer - Operation:
get /timers/timer
Table Columns
The columns of the table Timers 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 at | |||
description |
varchar2 |
Description | |||
employee_ |
double |
Employee Amount | |||
employee_ |
varchar2 |
Employee Declarable | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee ID | |||
employee_ |
varchar2 |
Employee Name | |||
employee_ |
varchar2 |
Employee Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
employee_ |
double |
Employee Tariff | |||
hourstype_ |
double |
itgen_spe_hourstype_billable | |||
hourstype_ |
char |
itgen_spe_hourstype_blocked | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_color | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_id | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_label | |||
hourstype_ |
double |
itgen_spe_hourstype_tariff | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_type | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_code | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_id | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_label | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_name | |||
hourstype_ |
double |
itgen_spe_hourstype_vatclass_percentage | |||
id |
varchar2 |
ID | |||
metadata |
varchar2 |
Metadata | JSON | ||
min_ |
double |
itgen_spe_min_seconds_step | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Organisation ID | |||
project_ |
varchar2 |
Project Organisation Name | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Person Full Name | |||
project_ |
varchar2 |
Project Person ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Project Manager Amount | |||
project_ |
varchar2 |
Project Manager Declarable | |||
project_ |
varchar2 |
Project Manager Employee ID | |||
project_ |
varchar2 |
Project Manager ID | |||
project_ |
varchar2 |
Project Manager Name | |||
project_ |
varchar2 |
Project Manager Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
Project Manager Tariff | |||
project_ |
varchar2 |
Project Number | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_default_service_id | |||
projectservice_ |
varchar2 |
Project Service ID | |||
projectservice_ |
varchar2 |
Project Service Name | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_revenue_group_id | |||
projectservice_ |
char |
itgen_spe_projectservice_use_in_resource_planner | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_country_code | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_country_id | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_line_1 | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_line_2 | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_locality | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_postal_code | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_province | |||
related_ |
varchar2 |
itgen_spe_related_hours_address_type | |||
related_ |
varchar2 |
itgen_spe_related_hours_assignment_id | |||
related_ |
char |
itgen_spe_related_hours_billable | |||
related_ |
int64 |
itgen_spe_related_hours_duration_in_minutes | |||
related_ |
varchar2 |
itgen_spe_related_hours_end_date | |||
related_ |
double |
itgen_spe_related_hours_hours | |||
related_ |
varchar2 |
itgen_spe_related_hours_id | |||
related_ |
char |
itgen_spe_related_hours_is_external | |||
related_ |
char |
itgen_spe_related_hours_is_recurring | |||
related_ |
char |
itgen_spe_related_hours_is_time_defined | |||
related_ |
varchar2 |
itgen_spe_related_hours_note | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_id | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_byday | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_bysetpos | |||
related_ |
int64 |
itgen_spe_related_hours_recurrence_rrule_count | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_dtstart | |||
related_ |
int64 |
itgen_spe_related_hours_recurrence_rrule_freq | |||
related_ |
int64 |
itgen_spe_related_hours_recurrence_rrule_interval | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_until | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_rrule_wkst | |||
related_ |
varchar2 |
itgen_spe_related_hours_recurrence_update | |||
related_ |
char |
itgen_spe_related_hours_should_sync_to_cronofy | |||
related_ |
varchar2 |
itgen_spe_related_hours_source | |||
related_ |
varchar2 |
itgen_spe_related_hours_start_date | |||
seconds_ |
int64 |
itgen_spe_seconds_spent | |||
state |
varchar2 |
State | |||
updated_ |
varchar2 |
Updated at |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: