Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: CRM > Tables

Organizations: Simplicate Organizations

Contents Previous Home Next More

Fetches all organizations

Catalog: Simplicate

Schema: CRM

Label: Organizations

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

Select Simplicate API URL: /crm/organization

Insert Simplicate API URL: /crm/organization

Update Simplicate API URL: /crm/organization

Delete Simplicate API URL: /crm/organization

Field Selection Method: NotRequired

Base Path: data[*]

Select Simplicate API Operation: get /crm/organization

Insert Simplicate API Operation: post /crm/organization

Update Simplicate API Operation: put /crm/organization/{id}

Delete Simplicate API Operation: delete /crm/organization/{id}

Table Function Columns

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

accountancy_is_tax_unit_vat

boolean

 

 

accountancy_is_tax_unit_vpb

boolean

 

 

accountancy_tax_unit_vat_role

string

 

 

accountancy_tax_unit_vpb_role

string

 

 

accountancy_vat_number_fe

string

 

 

allow_autocollect

boolean

 

 

bank_account

string

Bank Account

 

bank_bic

string

 

 

coc_code

string

 

 

created_at

string

Created at

 

created

string

Created

 

debtor_attention_to_fixed

string

 

 

debtor_attention_to_person_id

string

 

See /crm/person

debtor_attention_to

string

 

 

debtor_autocollect

boolean

 

 

debtor_autosend_subscription_invoice

boolean

 

 

debtor_invoicetemplate_id

string

 

 

debtor_payment_term_days

int64

 

 

debtor_payment_term_id

string

 

 

debtor_payment_term_method

string

 

 

debtor_payment_term_name

string

 

 

debtor_provision_contactperson_id

string

 

See /crm/person

debtor_provision_method

string

 

 

debtor_reminders

boolean

 

 

debtor_send_email_email

string

 

 

debtor_send_email_type

string

 

 

email

string

 

 

has_different_postal_address

boolean

 

 

id

string

ID

 

industry_id

string

 

 

industry_name

string

 

 

invoice_receiver

string

 

 

linkedin_url

string

 

 

modified

string

Modified

 

name

string

Name

 

note

string

Note

 

organizationsize_id

string

 

 

organizationsize_name

string

 

 

phone

string

 

 

postal_address_country_code

string

 

 

postal_address_country_id

string

 

 

postal_address_country

string

 

 

postal_address_id

string

 

 

postal_address_line_1

string

 

 

postal_address_line_2

string

 

 

postal_address_locality

string

 

 

postal_address_postal_code

string

 

 

postal_address_province

string

 

 

postal_address_type

string

 

 

relation_manager_avatar_color

string

 

 

relation_manager_avatar_initials

string

 

 

relation_manager_avatar_url_large

string

 

 

relation_manager_avatar_url_small

string

 

 

relation_manager_bank_account

string

 

 

relation_manager_created_at

string

 

 

relation_manager_created

string

 

 

relation_manager_employment_status

string

 

 

relation_manager_function

string

 

 

relation_manager_hourly_cost_tariff

float

 

 

relation_manager_hourly_sales_tariff

float

 

 

relation_manager_id

string

 

 

relation_manager_is_user

boolean

 

 

relation_manager_marital_status

string

 

 

relation_manager_modified

string

 

 

relation_manager_name

string

 

 

relation_manager_person_address_country_code

string

 

 

relation_manager_person_address_country_id

string

 

 

relation_manager_person_address_country

string

 

 

relation_manager_person_address_id

string

 

 

relation_manager_person_address_line_1

string

 

 

relation_manager_person_address_line_2

string

 

 

relation_manager_person_address_locality

string

 

 

relation_manager_person_address_postal_code

string

 

 

relation_manager_person_address_province

string

 

 

relation_manager_person_address_type

string

 

 

relation_manager_person_avatar_color

string

 

 

relation_manager_person_avatar_initials

string

 

 

relation_manager_person_avatar_url_large

string

 

 

relation_manager_person_avatar_url_small

string

 

 

relation_manager_person_bank_account

string

 

 

relation_manager_person_bank_bic

string

 

 

relation_manager_person_created_at

string

 

 

relation_manager_person_date_of_birth

string

 

 

relation_manager_person_email

string

 

 

relation_manager_person_facebook_url

string

 

 

relation_manager_person_family_name_prefix

string

 

 

relation_manager_person_family_name

string

 

 

relation_manager_person_first_name

string

 

 

relation_manager_person_full_name

string

 

 

relation_manager_person_gender_id

string

 

 

relation_manager_person_gender

string

 

 

relation_manager_person_id_1

string

 

 

relation_manager_person_id

string

 

 

relation_manager_person_initials

string

 

 

relation_manager_person_invoice_receiver

string

 

 

relation_manager_person_linkedin_url

string

 

 

relation_manager_person_mailing_list_email

string

 

 

relation_manager_person_note

string

 

 

relation_manager_person_phone

string

 

 

relation_manager_person_relation_manager_avatar_color

string

 

 

relation_manager_person_relation_manager_avatar_initials

string

 

 

relation_manager_person_relation_manager_avatar_url_large

string

 

 

relation_manager_person_relation_manager_avatar_url_small

string

 

 

relation_manager_person_relation_manager_bank_account

string

 

 

relation_manager_person_relation_manager_created_at

string

 

 

relation_manager_person_relation_manager_created

string

 

 

relation_manager_person_relation_manager_employment_status

string

 

 

relation_manager_person_relation_manager_function

string

 

 

relation_manager_person_relation_manager_hourly_cost_tariff

float

 

 

relation_manager_person_relation_manager_hourly_sales_tariff

float

 

 

relation_manager_person_relation_manager_id

string

 

 

relation_manager_person_relation_manager_is_user

boolean

 

 

relation_manager_person_relation_manager_marital_status

string

 

 

relation_manager_person_relation_manager_modified

string

 

 

relation_manager_person_relation_manager_name

string

 

 

relation_manager_person_relation_manager_person_address_country_code

string

 

 

relation_manager_person_relation_manager_person_address_country_id

string

 

 

relation_manager_person_relation_manager_person_address_country

string

 

 

relation_manager_person_relation_manager_person_address_id

string

 

 

relation_manager_person_relation_manager_person_address_line_1

string

 

 

relation_manager_person_relation_manager_person_address_line_2

string

 

 

relation_manager_person_relation_manager_person_address_locality

string

 

 

relation_manager_person_relation_manager_person_address_postal_code

string

 

 

relation_manager_person_relation_manager_person_address_province

string

 

 

relation_manager_person_relation_manager_person_address_type

string

 

 

relation_manager_person_relation_manager_person_avatar_color

string

 

 

relation_manager_person_relation_manager_person_avatar_initials

string

 

 

relation_manager_person_relation_manager_person_avatar_url_large

string

 

 

relation_manager_person_relation_manager_person_avatar_url_small

string

 

 

relation_manager_person_relation_manager_person_bank_account

string

 

 

relation_manager_person_relation_manager_person_bank_bic

string

 

 

relation_manager_person_relation_manager_person_created_at

string

 

 

relation_manager_person_relation_manager_person_date_of_birth

string

 

 

relation_manager_person_relation_manager_person_email

string

 

 

relation_manager_person_relation_manager_person_facebook_url

string

 

 

relation_manager_person_relation_manager_person_family_name_prefix

string

 

 

relation_manager_person_relation_manager_person_family_name

string

 

 

relation_manager_person_relation_manager_person_first_name

string

 

 

relation_manager_person_relation_manager_person_full_name

string

 

 

relation_manager_person_relation_manager_person_gender_id

string

 

 

relation_manager_person_relation_manager_person_gender

string

 

 

relation_manager_person_relation_manager_person_id_1

string

 

 

relation_manager_person_relation_manager_person_id

string

 

 

relation_manager_person_relation_manager_person_initials

string

 

 

relation_manager_person_relation_manager_person_invoice_receiver

string

 

 

relation_manager_person_relation_manager_person_linkedin_url

string

 

 

relation_manager_person_relation_manager_person_mailing_list_email

string

 

 

relation_manager_person_relation_manager_person_note

string

 

 

relation_manager_person_relation_manager_person_phone

string

 

 

relation_manager_person_relation_manager_person_relation_manager_bank_account

string

 

 

relation_manager_person_relation_manager_person_relation_manager_created_at

string

 

 

relation_manager_person_relation_manager_person_relation_manager_created

string

 

 

relation_manager_person_relation_manager_person_relation_manager_employment_status

string

 

 

relation_manager_person_relation_manager_person_relation_manager_function

string

 

 

relation_manager_person_relation_manager_person_relation_manager_hourly_cost_tariff

float

 

 

relation_manager_person_relation_manager_person_relation_manager_hourly_sales_tariff

float

 

 

relation_manager_person_relation_manager_person_relation_manager_id

string

 

 

relation_manager_person_relation_manager_person_relation_manager_is_user

boolean

 

 

relation_manager_person_relation_manager_person_relation_manager_marital_status

string

 

 

relation_manager_person_relation_manager_person_relation_manager_modified

string

 

 

relation_manager_person_relation_manager_person_relation_manager_name

string

 

 

relation_manager_person_relation_manager_person_relation_manager_person_id

string

 

 

relation_manager_person_relation_manager_person_relation_manager_simplicate_url

string

 

 

relation_manager_person_relation_manager_person_relation_manager_social_security_number

string

 

 

relation_manager_person_relation_manager_person_relation_manager_timeline_email_address

string

 

 

relation_manager_person_relation_manager_person_relation_manager_updated_at

string

 

 

relation_manager_person_relation_manager_person_relation_manager_work_email

string

 

 

relation_manager_person_relation_manager_person_relation_manager_work_mobile

string

 

 

relation_manager_person_relation_manager_person_relation_manager_work_phone

string

 

 

relation_manager_person_relation_manager_person_relation_number

string

 

 

relation_manager_person_relation_manager_person_relation_type_color

string

 

 

relation_manager_person_relation_manager_person_relation_type_id

string

 

 

relation_manager_person_relation_manager_person_relation_type_label

string

 

 

relation_manager_person_relation_manager_person_relation_type_type

string

 

 

relation_manager_person_relation_manager_person_simplicate_url

string

 

 

relation_manager_person_relation_manager_person_timeline_email_address

string

 

 

relation_manager_person_relation_manager_person_twitter_url

string

 

 

relation_manager_person_relation_manager_person_updated_at

string

 

 

relation_manager_person_relation_manager_person_website_url

string

 

 

relation_manager_person_relation_manager_simplicate_url

string

 

 

relation_manager_person_relation_manager_social_security_number

string

 

 

relation_manager_person_relation_manager_status_id

string

 

 

relation_manager_person_relation_manager_status_label

string

 

 

relation_manager_person_relation_manager_timeline_email_address

string

 

 

relation_manager_person_relation_manager_type_id

string

 

 

relation_manager_person_relation_manager_type_label

string

 

 

relation_manager_person_relation_manager_updated_at

string

 

 

relation_manager_person_relation_manager_work_email

string

 

 

relation_manager_person_relation_manager_work_mobile

string

 

 

relation_manager_person_relation_manager_work_phone

string

 

 

relation_manager_person_relation_number

string

 

 

relation_manager_person_relation_type_color

string

 

 

relation_manager_person_relation_type_id

string

 

 

relation_manager_person_relation_type_label

string

 

 

relation_manager_person_relation_type_type

string

 

 

relation_manager_person_simplicate_url

string

 

 

relation_manager_person_timeline_email_address

string

 

 

relation_manager_person_twitter_url

string

 

 

relation_manager_person_updated_at

string

 

 

relation_manager_person_website_url

string

 

 

relation_manager_simplicate_url

string

 

 

relation_manager_social_security_number

string

 

 

relation_manager_status_id

string

 

 

relation_manager_status_label

string

 

 

relation_manager_timeline_email_address

string

 

 

relation_manager_type_id

string

 

 

relation_manager_type_label

string

 

 

relation_manager_updated_at

string

 

 

relation_manager_work_email

string

 

 

relation_manager_work_mobile

string

 

 

relation_manager_work_phone

string

 

 

relation_number

string

 

 

relation_type_color

string

 

 

relation_type_id

string

 

 

relation_type_label

string

 

 

relation_type_type

string

 

 

simplicate_url

string

Simplicate URL

 

timeline_email_address

string

 

 

updated_at

string

Updated at

 

url

string

 

 

vat_number

string

 

 

visiting_address_country_code

string

 

 

visiting_address_country_id

string

 

 

visiting_address_country

string

 

 

visiting_address_id

string

 

 

visiting_address_line_1

string

 

 

visiting_address_line_2

string

 

 

visiting_address_locality

string

 

 

visiting_address_postal_code

string

 

 

visiting_address_province

string

 

 

visiting_address_type

string

 

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152