invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Persone: Persone di Simplicate

insert update delete REST

  • Catalogo: Simplicate
  • Schema: CRM
  • Chiavi primarie: id
  • Etichetta: Persons

Recupera tutte le persone

È possibile recuperare e modificare i dati utilizzando insert, update e delete.

Codice sorgente dell'API

  • Punto finale: /crm/person
  • Operazione: get /crm/person

Colonne della tabella

Di seguito sono riportate le colonne della tabella Persons. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
address_country varchar2 Paese dell'indirizzo
address_country_code varchar2 Codice Paese dell'indirizzo
address_country_id varchar2 Indirizzo, Paese, ID
address_id varchar2 ID dall'indirizzo
address_line_1 varchar2 Indirizzo 1
address_line_2 varchar2 Indirizzo 2
address_locality varchar2 Indirizzo Località
address_postal_code varchar2 Indirizzo Codice postale
address_province varchar2 Indirizzo Provincia
address_type varchar2 Tipo di indirizzo
avatar_color varchar2 Colore dell'avatar
avatar_initials varchar2 Iniziali dell'avatar
avatar_url_large varchar2 Avatar grande (URL)
avatar_url_small varchar2 Avatar piccolo (URL)
bank_account varchar2 Conto bancario
bank_bic varchar2 Banca BIC
created_at varchar2 Creato il
custom_salutation varchar2 itgen_spe_custom_salutation
date_of_birth varchar2 Data di nascita
email varchar2 Email
facebook_url varchar2 Facebook URL
family_name varchar2 Cognome
family_name_prefix varchar2 Prefisso del cognome
first_name varchar2 Nome
full_name varchar2 Nome completo per l'uso nelle liste
gender varchar2 Gender
gender_id varchar2 ID di genere
id varchar2 ID
initials varchar2 Initials
invoice_receiver varchar2 Ricevitore della fattura
is_active char itgen_spe_is_active
is_employee int64 È dipendente
linkedin_url varchar2 URL di LinkedIn
mailing_list_email varchar2 E-mail della mailing list
note varchar2 Note
phone varchar2 Phone
relation_manager_avatar_color varchar2 itgen_spe_relation_manager_avatar_color
relation_manager_avatar_initials varchar2 itgen_spe_relation_manager_avatar_initials
relation_manager_avatar_url_large varchar2 itgen_spe_relation_manager_avatar_url_large
relation_manager_avatar_url_small varchar2 itgen_spe_relation_manager_avatar_url_small
relation_manager_bank_account varchar2 itgen_spe_relation_manager_bank_account
relation_manager_civil_status varchar2 itgen_spe_relation_manager_civil_status
relation_manager_created varchar2 itgen_spe_relation_manager_created
relation_manager_created_at varchar2 itgen_spe_relation_manager_created_at
relation_manager_employment_status varchar2 itgen_spe_relation_manager_employment_status
relation_manager_function varchar2 itgen_spe_relation_manager_function
relation_manager_hourly_cost_tariff double itgen_spe_relation_manager_hourly_cost_tariff
relation_manager_hourly_sales_tariff double itgen_spe_relation_manager_hourly_sales_tariff
relation_manager_id varchar2 ID del responsabile delle relazioni
relation_manager_is_user char itgen_spe_relation_manager_is_user
relation_manager_marital_status varchar2 itgen_spe_relation_manager_marital_status
relation_manager_modified varchar2 itgen_spe_relation_manager_modified
relation_manager_name varchar2 Nome del responsabile delle relazioni
relation_manager_person_address_country varchar2 itgen_spe_relation_manager_person_address_country
relation_manager_person_address_country_code varchar2 itgen_spe_relation_manager_person_address_country_code
relation_manager_person_address_country_id varchar2 itgen_spe_relation_manager_person_address_country_id
relation_manager_person_address_id varchar2 itgen_spe_relation_manager_person_address_id
relation_manager_person_address_line_1 varchar2 itgen_spe_relation_manager_person_address_line_1
relation_manager_person_address_line_2 varchar2 itgen_spe_relation_manager_person_address_line_2
relation_manager_person_address_locality varchar2 itgen_spe_relation_manager_person_address_locality
relation_manager_person_address_postal_code varchar2 itgen_spe_relation_manager_person_address_postal_code
relation_manager_person_address_province varchar2 itgen_spe_relation_manager_person_address_province
relation_manager_person_address_type varchar2 itgen_spe_relation_manager_person_address_type
relation_manager_person_avatar_color varchar2 itgen_spe_relation_manager_person_avatar_color
relation_manager_person_avatar_initials varchar2 itgen_spe_relation_manager_person_avatar_initials
relation_manager_person_avatar_url_large varchar2 itgen_spe_relation_manager_person_avatar_url_large
relation_manager_person_avatar_url_small varchar2 itgen_spe_relation_manager_person_avatar_url_small
relation_manager_person_bank_account varchar2 itgen_spe_relation_manager_person_bank_account
relation_manager_person_bank_bic varchar2 itgen_spe_relation_manager_person_bank_bic
relation_manager_person_created_at varchar2 itgen_spe_relation_manager_person_created_at
relation_manager_person_custom_salutation varchar2 itgen_spe_relation_manager_person_custom_salutation
relation_manager_person_date_of_birth varchar2 itgen_spe_relation_manager_person_date_of_birth
relation_manager_person_email varchar2 E-mail del responsabile delle relazioni
relation_manager_person_facebook_url varchar2 itgen_spe_relation_manager_person_facebook_url
relation_manager_person_family_name varchar2 itgen_spe_relation_manager_person_family_name
relation_manager_person_family_name_prefix varchar2 itgen_spe_relation_manager_person_family_name_prefix
relation_manager_person_first_name varchar2 itgen_spe_relation_manager_person_first_name
relation_manager_person_full_name varchar2 itgen_spe_relation_manager_person_full_name
relation_manager_person_gender varchar2 itgen_spe_relation_manager_person_gender
relation_manager_person_gender_id varchar2 itgen_spe_relation_manager_person_gender_id
relation_manager_person_id varchar2 itgen_spe_relation_manager_person_id
relation_manager_person_id_2 varchar2 itgen_spe_relation_manager_person_id_2
relation_manager_person_initials varchar2 itgen_spe_relation_manager_person_initials
relation_manager_person_invoice_receiver varchar2 itgen_spe_relation_manager_person_invoice_receiver
relation_manager_person_is_active char itgen_spe_relation_manager_person_is_active
relation_manager_person_is_employee int64 itgen_spe_relation_manager_person_is_employee
relation_manager_person_linkedin_url varchar2 itgen_spe_relation_manager_person_linkedin_url
relation_manager_person_mailing_list_email varchar2 itgen_spe_relation_manager_person_mailing_list_email
relation_manager_person_note varchar2 itgen_spe_relation_manager_person_note
relation_manager_person_phone varchar2 itgen_spe_relation_manager_person_phone
relation_manager_person_relation_manager_avatar_color varchar2 itgen_spe_relation_manager_person_relation_manager_avatar_color
relation_manager_person_relation_manager_avatar_initials varchar2 itgen_spe_relation_manager_person_relation_manager_avatar_initials
relation_manager_person_relation_manager_avatar_url_large varchar2 itgen_spe_relation_manager_person_relation_manager_avatar_url_large
relation_manager_person_relation_manager_avatar_url_small varchar2 itgen_spe_relation_manager_person_relation_manager_avatar_url_small
relation_manager_person_relation_manager_bank_account varchar2 itgen_spe_relation_manager_person_relation_manager_bank_account
relation_manager_person_relation_manager_civil_status varchar2 itgen_spe_relation_manager_person_relation_manager_civil_status
relation_manager_person_relation_manager_created varchar2 itgen_spe_relation_manager_person_relation_manager_created
relation_manager_person_relation_manager_created_at varchar2 itgen_spe_relation_manager_person_relation_manager_created_at
relation_manager_person_relation_manager_employment_status varchar2 itgen_spe_relation_manager_person_relation_manager_employment_status
relation_manager_person_relation_manager_function varchar2 itgen_spe_relation_manager_person_relation_manager_function
relation_manager_person_relation_manager_hourly_cost_tariff double itgen_spe_relation_manager_person_relation_manager_hourly_cost_tariff
relation_manager_person_relation_manager_hourly_sales_tariff double itgen_spe_relation_manager_person_relation_manager_hourly_sales_tariff
relation_manager_person_relation_manager_id varchar2 itgen_spe_relation_manager_person_relation_manager_id
relation_manager_person_relation_manager_is_user char itgen_spe_relation_manager_person_relation_manager_is_user
relation_manager_person_relation_manager_marital_status varchar2 itgen_spe_relation_manager_person_relation_manager_marital_status
relation_manager_person_relation_manager_modified varchar2 itgen_spe_relation_manager_person_relation_manager_modified
relation_manager_person_relation_manager_name varchar2 itgen_spe_relation_manager_person_relation_manager_name
relation_manager_person_relation_manager_person_address_country varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_country
relation_manager_person_relation_manager_person_address_country_code varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_country_code
relation_manager_person_relation_manager_person_address_country_id varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_country_id
relation_manager_person_relation_manager_person_address_id varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_id
relation_manager_person_relation_manager_person_address_line_1 varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_line_1
relation_manager_person_relation_manager_person_address_line_2 varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_line_2
relation_manager_person_relation_manager_person_address_locality varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_locality
relation_manager_person_relation_manager_person_address_postal_code varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_postal_code
relation_manager_person_relation_manager_person_address_province varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_province
relation_manager_person_relation_manager_person_address_type varchar2 itgen_spe_relation_manager_person_relation_manager_person_address_type
relation_manager_person_relation_manager_person_avatar_color varchar2 itgen_spe_relation_manager_person_relation_manager_person_avatar_color
relation_manager_person_relation_manager_person_avatar_initials varchar2 itgen_spe_relation_manager_person_relation_manager_person_avatar_initials
relation_manager_person_relation_manager_person_avatar_url_large varchar2 itgen_spe_relation_manager_person_relation_manager_person_avatar_url_large
relation_manager_person_relation_manager_person_avatar_url_small varchar2 itgen_spe_relation_manager_person_relation_manager_person_avatar_url_small
relation_manager_person_relation_manager_person_bank_account varchar2 itgen_spe_relation_manager_person_relation_manager_person_bank_account
relation_manager_person_relation_manager_person_bank_bic varchar2 itgen_spe_relation_manager_person_relation_manager_person_bank_bic
relation_manager_person_relation_manager_person_created_at varchar2 itgen_spe_relation_manager_person_relation_manager_person_created_at
relation_manager_person_relation_manager_person_custom_salutation varchar2 itgen_spe_relation_manager_person_relation_manager_person_custom_salutation
relation_manager_person_relation_manager_person_date_of_birth varchar2 itgen_spe_relation_manager_person_relation_manager_person_date_of_birth
relation_manager_person_relation_manager_person_email varchar2 itgen_spe_relation_manager_person_relation_manager_person_email
relation_manager_person_relation_manager_person_facebook_url varchar2 itgen_spe_relation_manager_person_relation_manager_person_facebook_url
relation_manager_person_relation_manager_person_family_name varchar2 itgen_spe_relation_manager_person_relation_manager_person_family_name
relation_manager_person_relation_manager_person_family_name_prefix varchar2 itgen_spe_relation_manager_person_relation_manager_person_family_name_prefix
relation_manager_person_relation_manager_person_first_name varchar2 itgen_spe_relation_manager_person_relation_manager_person_first_name
relation_manager_person_relation_manager_person_full_name varchar2 itgen_spe_relation_manager_person_relation_manager_person_full_name
relation_manager_person_relation_manager_person_gender varchar2 itgen_spe_relation_manager_person_relation_manager_person_gender
relation_manager_person_relation_manager_person_gender_id varchar2 itgen_spe_relation_manager_person_relation_manager_person_gender_id
relation_manager_person_relation_manager_person_id varchar2 itgen_spe_relation_manager_person_relation_manager_person_id
relation_manager_person_relation_manager_person_id_2 varchar2 itgen_spe_relation_manager_person_relation_manager_person_id_2
relation_manager_person_relation_manager_person_initials varchar2 itgen_spe_relation_manager_person_relation_manager_person_initials
relation_manager_person_relation_manager_person_invoice_receiver varchar2 itgen_spe_relation_manager_person_relation_manager_person_invoice_receiver
relation_manager_person_relation_manager_person_is_active char itgen_spe_relation_manager_person_relation_manager_person_is_active
relation_manager_person_relation_manager_person_is_employee int64 itgen_spe_relation_manager_person_relation_manager_person_is_employee
relation_manager_person_relation_manager_person_linkedin_url varchar2 itgen_spe_relation_manager_person_relation_manager_person_linkedin_url
relation_manager_person_relation_manager_person_mailing_list_email varchar2 itgen_spe_relation_manager_person_relation_manager_person_mailing_list_email
relation_manager_person_relation_manager_person_note varchar2 itgen_spe_relation_manager_person_relation_manager_person_note
relation_manager_person_relation_manager_person_phone varchar2 itgen_spe_relation_manager_person_relation_manager_person_phone
relation_manager_person_relation_manager_person_relation_manager_bank_account varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_bank_account
relation_manager_person_relation_manager_person_relation_manager_civil_status varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_civil_status
relation_manager_person_relation_manager_person_relation_manager_created varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_created
relation_manager_person_relation_manager_person_relation_manager_created_at varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_created_at
relation_manager_person_relation_manager_person_relation_manager_employment_status varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_employment_status
relation_manager_person_relation_manager_person_relation_manager_function varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_function
relation_manager_person_relation_manager_person_relation_manager_hourly_cost_tariff double itgen_spe_relation_manager_person_relation_manager_person_relation_manager_hourly_cost_tariff
relation_manager_person_relation_manager_person_relation_manager_hourly_sales_tariff double itgen_spe_relation_manager_person_relation_manager_person_relation_manager_hourly_sales_tariff
relation_manager_person_relation_manager_person_relation_manager_id varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_id
relation_manager_person_relation_manager_person_relation_manager_is_user char itgen_spe_relation_manager_person_relation_manager_person_relation_manager_is_user
relation_manager_person_relation_manager_person_relation_manager_marital_status varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_marital_status
relation_manager_person_relation_manager_person_relation_manager_modified varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_modified
relation_manager_person_relation_manager_person_relation_manager_name varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_name
relation_manager_person_relation_manager_person_relation_manager_person_id varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_person_id
relation_manager_person_relation_manager_person_relation_manager_simplicate_url varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_simplicate_url
relation_manager_person_relation_manager_person_relation_manager_social_security_number varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_social_security_number
relation_manager_person_relation_manager_person_relation_manager_timeline_email_address varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_timeline_email_address
relation_manager_person_relation_manager_person_relation_manager_updated_at varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_updated_at
relation_manager_person_relation_manager_person_relation_manager_work_email varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_email
relation_manager_person_relation_manager_person_relation_manager_work_mobile varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_mobile
relation_manager_person_relation_manager_person_relation_manager_work_phone varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_phone
relation_manager_person_relation_manager_person_relation_number varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_number
relation_manager_person_relation_manager_person_relation_type_color varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_type_color
relation_manager_person_relation_manager_person_relation_type_id varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_type_id
relation_manager_person_relation_manager_person_relation_type_label varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_type_label
relation_manager_person_relation_manager_person_relation_type_type varchar2 itgen_spe_relation_manager_person_relation_manager_person_relation_type_type
relation_manager_person_relation_manager_person_simplicate_url varchar2 itgen_spe_relation_manager_person_relation_manager_person_simplicate_url
relation_manager_person_relation_manager_person_timeline_email_address varchar2 itgen_spe_relation_manager_person_relation_manager_person_timeline_email_address
relation_manager_person_relation_manager_person_twitter_url varchar2 itgen_spe_relation_manager_person_relation_manager_person_twitter_url
relation_manager_person_relation_manager_person_updated_at varchar2 itgen_spe_relation_manager_person_relation_manager_person_updated_at
relation_manager_person_relation_manager_person_use_custom_salutation char itgen_spe_relation_manager_person_relation_manager_person_use_custom_salutation
relation_manager_person_relation_manager_person_website_url varchar2 itgen_spe_relation_manager_person_relation_manager_person_website_url
relation_manager_person_relation_manager_simplicate_url varchar2 itgen_spe_relation_manager_person_relation_manager_simplicate_url
relation_manager_person_relation_manager_social_security_number varchar2 itgen_spe_relation_manager_person_relation_manager_social_security_number
relation_manager_person_relation_manager_status_id varchar2 itgen_spe_relation_manager_person_relation_manager_status_id
relation_manager_person_relation_manager_status_label varchar2 itgen_spe_relation_manager_person_relation_manager_status_label
relation_manager_person_relation_manager_timeline_email_address varchar2 itgen_spe_relation_manager_person_relation_manager_timeline_email_address
relation_manager_person_relation_manager_type_id varchar2 itgen_spe_relation_manager_person_relation_manager_type_id
relation_manager_person_relation_manager_type_label varchar2 itgen_spe_relation_manager_person_relation_manager_type_label
relation_manager_person_relation_manager_updated_at varchar2 itgen_spe_relation_manager_person_relation_manager_updated_at
relation_manager_person_relation_manager_work_email varchar2 itgen_spe_relation_manager_person_relation_manager_work_email
relation_manager_person_relation_manager_work_mobile varchar2 itgen_spe_relation_manager_person_relation_manager_work_mobile
relation_manager_person_relation_manager_work_phone varchar2 itgen_spe_relation_manager_person_relation_manager_work_phone
relation_manager_person_relation_number varchar2 itgen_spe_relation_manager_person_relation_number
relation_manager_person_relation_type_color varchar2 itgen_spe_relation_manager_person_relation_type_color
relation_manager_person_relation_type_id varchar2 itgen_spe_relation_manager_person_relation_type_id
relation_manager_person_relation_type_label varchar2 itgen_spe_relation_manager_person_relation_type_label
relation_manager_person_relation_type_type varchar2 itgen_spe_relation_manager_person_relation_type_type
relation_manager_person_simplicate_url varchar2 itgen_spe_relation_manager_person_simplicate_url
relation_manager_person_timeline_email_address varchar2 itgen_spe_relation_manager_person_timeline_email_address
relation_manager_person_twitter_url varchar2 itgen_spe_relation_manager_person_twitter_url
relation_manager_person_updated_at varchar2 itgen_spe_relation_manager_person_updated_at
relation_manager_person_use_custom_salutation char itgen_spe_relation_manager_person_use_custom_salutation
relation_manager_person_website_url varchar2 itgen_spe_relation_manager_person_website_url
relation_manager_simplicate_url varchar2 itgen_spe_relation_manager_simplicate_url
relation_manager_social_security_number varchar2 itgen_spe_relation_manager_social_security_number
relation_manager_status_id varchar2 itgen_spe_relation_manager_status_id
relation_manager_status_label varchar2 itgen_spe_relation_manager_status_label
relation_manager_timeline_email_address varchar2 itgen_spe_relation_manager_timeline_email_address
relation_manager_type_id varchar2 itgen_spe_relation_manager_type_id
relation_manager_type_label varchar2 itgen_spe_relation_manager_type_label
relation_manager_updated_at varchar2 itgen_spe_relation_manager_updated_at
relation_manager_work_email varchar2 itgen_spe_relation_manager_work_email
relation_manager_work_mobile varchar2 itgen_spe_relation_manager_work_mobile
relation_manager_work_phone varchar2 itgen_spe_relation_manager_work_phone
relation_number varchar2 Numero di relazione
relation_type_color varchar2 Colore del tipo di relazione
relation_type_id varchar2 ID del tipo di relazione
relation_type_label varchar2 Etichetta del tipo di relazione
relation_type_type varchar2 Tipo di relazione
simplicate_url varchar2 Simplicate URL
timeline_email_address varchar2 Indirizzo e-mail della timeline
twitter_url varchar2 URL di Twitter
updated_at varchar2 Aggiornato il
use_custom_salutation char itgen_spe_use_custom_salutation
website_url varchar2 URL sito Web

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: