Please enable JavaScript to view this site.

Navigation: Schema: Projects > Tables

Projects: Simplicate Projects

Fetches all projects

Catalog: Simplicate

Schema: Projects

Label: Projects

Can retrieve data and change data using insert, update and delete.

Select Simplicate API URL: /projects/project

Insert Simplicate API URL: /projects/project

Update Simplicate API URL: /projects/project

Delete Simplicate API URL: /projects/project

Field Selection Method: NotRequired

Base Path: data[*]

Select Simplicate API Operation: get /projects/project

Insert Simplicate API Operation: post /projects/project

Update Simplicate API Operation: put /projects/project/{id}

Delete Simplicate API Operation: delete /projects/project/{id}

Table Function Columns

The columns of the table function Projects 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

abnormal_address

boolean

Abnormal Address

 

abnormal_contact_id

string

Abnormal Contact ID

 

abnormal_organization_id

string

Abnormal Organization ID

 

abnormal_person_id

string

Abnormal Person ID

 

billable

boolean

Billable

 

budget_costs_value_budget

float

 

 

budget_costs_value_spent

float

 

 

budget_hours_amount_budget

float

 

 

budget_hours_amount_spent

float

 

 

budget_hours_value_budget

float

 

 

budget_hours_value_spent

float

 

 

budget_total_value_budget

float

 

 

budget_total_value_invoiced

float

 

 

budget_total_value_spent

float

 

 

can_register_mileage

boolean

Can Register Mileage

 

contact_id_1

string

 

 

contact_id

string

Contact ID

 

contact_organization_id

string

Contact Organization ID

 

contact_organization_name

string

Contact Organization Name

 

contact_person_full_name

string

Contact Person Full Name

 

contact_person_id

string

Contact Person ID

 

created_at

string

Created at

 

created

string

Created

 

divergent_payment_term_days

int64

Divergent Payment Term (days)

 

divergent_payment_term_id

string

Divergent Payment Term ID

 

divergent_payment_term_method

string

Divergent Payment Term Method

 

divergent_payment_term_name

string

Divergent Payment Term Name

 

end_date

string

End Date

 

hours_rate_type

string

Hours Rate Type

 

id

string

ID

 

invoice_reference

string

Invoice Reference

 

is_invoice_approval

boolean

Is Invoice Approval

 

is_reverse_billing

boolean

Is Reverse Billing

 

modified

string

Modified

 

my_organization_profile_id_1

string

 

 

my_organization_profile_id

string

My Organization Profile ID

 

my_organization_profile_organization_id

string

 

 

my_organization_profile_organization_name

string

 

 

name

string

Name

 

note

string

Note

 

organization_id_1

string

 

 

organization_id

string

Organization ID

 

organization_name

string

Organization Name

 

person_full_name

string

Person Full Name

 

person_id_1

string

 

 

person_id

string

Person ID

 

project_manager_amount

float

 

 

project_manager_declarable

string

 

 

project_manager_employee_id

string

 

 

project_manager_id

string

 

 

project_manager_name

string

 

 

project_manager_person_id

string

 

 

project_manager_tariff

float

 

 

project_number

string

Project Number

 

project_status_color

string

Project Status Color

 

project_status_id

string

Project Status ID

 

project_status_label

string

Project Status Label

 

separate_invoice_recipient_contact_id

string

 

 

separate_invoice_recipient_contact_organization_id

string

 

 

separate_invoice_recipient_contact_organization_name

string

 

 

separate_invoice_recipient_contact_person_full_name

string

 

 

separate_invoice_recipient_contact_person_id

string

 

 

separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

 

separate_invoice_recipient_organization_id

string

 

 

separate_invoice_recipient_organization_name

string

 

 

separate_invoice_recipient_person_full_name

string

 

 

separate_invoice_recipient_person_id

string

 

 

simplicate_url

string

Simplicate URL

 

start_date

string

Start Date

 

timeline_email_address

string

Timeline Email Address

 

updated_at

string

Updated at

 

 

15-06-2022 20:27 Version 22.0.232-PROD+3445