ProjectById: Simplicate Project by ID
read only REST
- Catalog:
Simplicate - Schema:
Projects - Label: Project by ID
Fetches a single project by id
Can only retrieve data.
API Source
- Endpoint:
/projects/project/{id} - Operation:
get /projects/project/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | The template's id |
Table Columns
The columns of the table ProjectById 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 |
|---|---|---|---|---|---|
abnormal_ |
char |
Abnormal Address | |||
abnormal_ |
varchar2 |
Abnormal Contact ID | |||
abnormal_ |
varchar2 |
Abnormal Organisation ID | |||
abnormal_ |
varchar2 |
Abnormal Person ID | |||
billable |
char |
Billable | |||
budget_ |
double |
itgen_spe_budget_costs_value_budget | |||
budget_ |
double |
itgen_spe_budget_costs_value_spent | |||
budget_ |
double |
itgen_spe_budget_hours_amount_budget | |||
budget_ |
double |
itgen_spe_budget_hours_amount_spent | |||
budget_ |
double |
itgen_spe_budget_hours_value_budget | |||
budget_ |
double |
itgen_spe_budget_hours_value_spent | |||
budget_ |
double |
itgen_spe_budget_total_value_budget | |||
budget_ |
double |
itgen_spe_budget_total_value_invoiced | |||
budget_ |
double |
itgen_spe_budget_total_value_spent | |||
can_ |
char |
Can Register Mileage | |||
contact_ |
varchar2 |
Contact ID | |||
contact_ |
varchar2 |
itgen_spe_contact_id_2 | |||
contact_ |
varchar2 |
Contact Organisation ID | |||
contact_ |
varchar2 |
Contact Organisation Name | |||
contact_ |
varchar2 |
itgen_spe_contact_organization_relation_number | |||
contact_ |
varchar2 |
Contact Person Full Name | |||
contact_ |
varchar2 |
Contact Person ID | |||
contact_ |
varchar2 |
itgen_spe_contact_person_relation_number | |||
copied_ |
char |
itgen_spe_copied_from_project_has_register_mileage_enabled | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_organization_relation_number | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_full_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_person_relation_number | |||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_amount | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_declarable | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_employee_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_id | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_name | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
copied_ |
double |
itgen_spe_copied_from_project_project_manager_tariff | |||
copied_ |
varchar2 |
itgen_spe_copied_from_project_project_number | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Created at | |||
divergent_ |
int64 |
Divergent Payment Term (days) | |||
divergent_ |
varchar2 |
Divergent Payment Term ID | |||
divergent_ |
varchar2 |
Divergent Payment Term Method | |||
divergent_ |
varchar2 |
Divergent Payment Term Name | |||
end_ |
varchar2 |
End Date | |||
hours_ |
varchar2 |
Hours Rate Type | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice Reference | |||
is_ |
char |
Is Invoice Approval | |||
is_ |
char |
Is Reverse Billing | |||
modified |
varchar2 |
Modified | |||
my_ |
varchar2 |
My Organisation Profile ID | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_id_2 | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_id | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_name | |||
my_ |
varchar2 |
itgen_spe_my_organization_profile_organization_relation_number | |||
name |
varchar2 |
Name | |||
note |
varchar2 |
Note | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
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_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
project_ |
double |
itgen_spe_project_manager_amount | |||
project_ |
varchar2 |
itgen_spe_project_manager_declarable | |||
project_ |
varchar2 |
itgen_spe_project_manager_employee_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_name | |||
project_ |
varchar2 |
itgen_spe_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
itgen_spe_project_manager_tariff | |||
project_ |
varchar2 |
Project Number | |||
project_ |
varchar2 |
Project Status Colour | |||
project_ |
varchar2 |
Project Status ID | |||
project_ |
varchar2 |
Project Status Label | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_contact_person_relation_number | |||
separate_ |
char |
itgen_spe_separate_invoice_recipient_is_separate_invoice_recipient | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_organization_relation_number | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_full_name | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_id | |||
separate_ |
varchar2 |
itgen_spe_separate_invoice_recipient_person_relation_number | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
start_ |
varchar2 |
Start Date | |||
timeline_ |
varchar2 |
Timeline Email Address | |||
updated_ |
varchar2 |
Updated at |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: