xMsg javascript has not been loaded.
Fetches all persons
Catalog: Simplicate
Schema: CRM
This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.
Select Simplicate API URL: /crm/person
Insert Simplicate API URL: /crm/person
Update Simplicate API URL: /crm/person
Delete Simplicate API URL: /crm/person
Field Selection Method: NotRequired
Base Path: data[*].interests[*]
Select Simplicate API Operation: get /crm/person
The columns of the table function InterestPersons are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
address_country_code |
string |
|
☐ |
|
address_country_id |
string |
|
☐ |
|
address_country |
string |
|
☐ |
|
address_id |
string |
|
☐ |
|
address_line_1 |
string |
|
☐ |
|
address_line_2 |
string |
|
☐ |
|
address_locality |
string |
|
☐ |
|
address_postal_code |
string |
|
☐ |
|
address_province |
string |
|
☐ |
|
address_type |
string |
|
☐ |
|
api_name |
string |
|
☐ |
|
avatar_color |
string |
|
☐ |
|
avatar_initials |
string |
|
☐ |
|
avatar_url_large |
string |
|
☐ |
|
avatar_url_small |
string |
|
☐ |
|
bank_account |
string |
Bank Account |
☐ |
|
bank_bic |
string |
|
☐ |
|
contact |
boolean |
|
☐ |
|
created_at |
string |
Created at |
☐ |
|
date_of_birth |
string |
|
☐ |
|
string |
|
☐ |
|
|
facebook_url |
string |
|
☐ |
|
family_name_prefix |
string |
|
☐ |
|
family_name |
string |
|
☐ |
|
first_name |
string |
|
☐ |
|
full_name |
string |
|
☐ |
|
gender_id |
string |
|
☐ |
|
gender |
string |
|
☐ |
|
id_1 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
initials |
string |
|
☐ |
|
invoice_receiver |
string |
|
☐ |
|
linkedin_url |
string |
|
☐ |
|
mailing_list_email |
string |
|
☐ |
|
name |
string |
Name |
☐ |
|
note |
string |
Note |
☐ |
|
organization |
boolean |
|
☐ |
|
person |
boolean |
|
☐ |
|
phone |
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 |
|
☐ |
|
twitter_url |
string |
|
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
value |
string |
Value |
☐ |
|
website_url |
string |
|
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152