invantive documentation
Forum di supporto InvantiveAccedi / Registrati

EmployeeById: Dipendente Simplicate per ID

read only REST

  • Catalogo: Simplicate
  • Schema: HRM
  • Etichetta: Dipendente per ID

Recupera un singolo dipendente tramite id

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Punto finale: /hrm/employee/{id}
  • Operazione: get /hrm/employee/{id}

Parametri

Name Tipo di dati Required Default Documentation
id `` L'ID del modello

Colonne della tabella

Di seguito sono riportate le colonne della tabella EmployeeById. 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
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
civil_status varchar2 Stato civile
created varchar2 Created
created_at varchar2 Creato il
employment_status varchar2 Situazione occupazionale
function varchar2 Function
hourly_cost_tariff double Tariffa oraria
hourly_sales_tariff double Tariffa oraria di vendita
id varchar2 ID
is_user char È utente
marital_status varchar2 Stato civile
modified varchar2 Modified
name varchar2 Name
person_address_country varchar2 Paese dell'indirizzo della persona
person_address_country_code varchar2 itgen_spe_person_address_country_code
person_address_country_id varchar2 itgen_spe_person_address_country_id
person_address_id varchar2 ID indirizzo persona
person_address_line_1 varchar2 itgen_spe_person_address_line_1
person_address_line_2 varchar2 itgen_spe_person_address_line_2
person_address_locality varchar2 Indirizzo della persona Località
person_address_postal_code varchar2 Indirizzo della persona Codice postale
person_address_province varchar2 Indirizzo persona Provincia
person_address_type varchar2 Tipo di indirizzo della persona
person_avatar_color varchar2 Colore dell'avatar della persona
person_avatar_initials varchar2 Iniziali dell'avatar della persona
person_avatar_url_large varchar2 URL dell'avatar della persona grande
person_avatar_url_small varchar2 URL dell'avatar della persona: piccolo
person_bank_account varchar2 itgen_spe_person_bank_account
person_bank_bic varchar2 itgen_spe_person_bank_bic
person_created_at varchar2 itgen_spe_person_created_at
person_custom_salutation varchar2 itgen_spe_person_custom_salutation
person_date_of_birth varchar2 itgen_spe_person_date_of_birth
person_email varchar2 itgen_spe_person_email
person_facebook_url varchar2 itgen_spe_person_facebook_url
person_family_name varchar2 itgen_spe_person_family_name
person_family_name_prefix varchar2 itgen_spe_person_family_name_prefix
person_first_name varchar2 itgen_spe_person_first_name
person_full_name varchar2 Nome completo della persona
person_gender varchar2 itgen_spe_person_gender
person_gender_id varchar2 itgen_spe_person_gender_id
person_id varchar2 ID persona
person_id_2 varchar2 itgen_spe_person_id_2
person_initials varchar2 itgen_spe_person_initials
person_invoice_receiver varchar2 itgen_spe_person_invoice_receiver
person_is_active char itgen_spe_person_is_active
person_is_employee int64 itgen_spe_person_is_employee
person_linkedin_url varchar2 itgen_spe_person_linkedin_url
person_mailing_list_email varchar2 itgen_spe_person_mailing_list_email
person_note varchar2 itgen_spe_person_note
person_phone varchar2 itgen_spe_person_phone
person_relation_manager_avatar_color varchar2 itgen_spe_person_relation_manager_avatar_color
person_relation_manager_avatar_initials varchar2 itgen_spe_person_relation_manager_avatar_initials
person_relation_manager_avatar_url_large varchar2 itgen_spe_person_relation_manager_avatar_url_large
person_relation_manager_avatar_url_small varchar2 itgen_spe_person_relation_manager_avatar_url_small
person_relation_manager_bank_account varchar2 itgen_spe_person_relation_manager_bank_account
person_relation_manager_civil_status varchar2 itgen_spe_person_relation_manager_civil_status
person_relation_manager_created varchar2 itgen_spe_person_relation_manager_created
person_relation_manager_created_at varchar2 itgen_spe_person_relation_manager_created_at
person_relation_manager_employment_status varchar2 itgen_spe_person_relation_manager_employment_status
person_relation_manager_function varchar2 itgen_spe_person_relation_manager_function
person_relation_manager_hourly_cost_tariff double itgen_spe_person_relation_manager_hourly_cost_tariff
person_relation_manager_hourly_sales_tariff double itgen_spe_person_relation_manager_hourly_sales_tariff
person_relation_manager_id varchar2 itgen_spe_person_relation_manager_id
person_relation_manager_is_user char itgen_spe_person_relation_manager_is_user
person_relation_manager_marital_status varchar2 itgen_spe_person_relation_manager_marital_status
person_relation_manager_modified varchar2 itgen_spe_person_relation_manager_modified
person_relation_manager_name varchar2 itgen_spe_person_relation_manager_name
person_relation_manager_person_address_country varchar2 itgen_spe_person_relation_manager_person_address_country
person_relation_manager_person_address_country_code varchar2 itgen_spe_person_relation_manager_person_address_country_code
person_relation_manager_person_address_country_id varchar2 itgen_spe_person_relation_manager_person_address_country_id
person_relation_manager_person_address_id varchar2 itgen_spe_person_relation_manager_person_address_id
person_relation_manager_person_address_line_1 varchar2 itgen_spe_person_relation_manager_person_address_line_1
person_relation_manager_person_address_line_2 varchar2 itgen_spe_person_relation_manager_person_address_line_2
person_relation_manager_person_address_locality varchar2 itgen_spe_person_relation_manager_person_address_locality
person_relation_manager_person_address_postal_code varchar2 itgen_spe_person_relation_manager_person_address_postal_code
person_relation_manager_person_address_province varchar2 itgen_spe_person_relation_manager_person_address_province
person_relation_manager_person_address_type varchar2 itgen_spe_person_relation_manager_person_address_type
person_relation_manager_person_avatar_color varchar2 itgen_spe_person_relation_manager_person_avatar_color
person_relation_manager_person_avatar_initials varchar2 itgen_spe_person_relation_manager_person_avatar_initials
person_relation_manager_person_avatar_url_large varchar2 itgen_spe_person_relation_manager_person_avatar_url_large
person_relation_manager_person_avatar_url_small varchar2 itgen_spe_person_relation_manager_person_avatar_url_small
person_relation_manager_person_bank_account varchar2 itgen_spe_person_relation_manager_person_bank_account
person_relation_manager_person_bank_bic varchar2 itgen_spe_person_relation_manager_person_bank_bic
person_relation_manager_person_created_at varchar2 itgen_spe_person_relation_manager_person_created_at
person_relation_manager_person_custom_salutation varchar2 itgen_spe_person_relation_manager_person_custom_salutation
person_relation_manager_person_date_of_birth varchar2 itgen_spe_person_relation_manager_person_date_of_birth
person_relation_manager_person_email varchar2 itgen_spe_person_relation_manager_person_email
person_relation_manager_person_facebook_url varchar2 itgen_spe_person_relation_manager_person_facebook_url
person_relation_manager_person_family_name varchar2 itgen_spe_person_relation_manager_person_family_name
person_relation_manager_person_family_name_prefix varchar2 itgen_spe_person_relation_manager_person_family_name_prefix
person_relation_manager_person_first_name varchar2 itgen_spe_person_relation_manager_person_first_name
person_relation_manager_person_full_name varchar2 itgen_spe_person_relation_manager_person_full_name
person_relation_manager_person_gender varchar2 itgen_spe_person_relation_manager_person_gender
person_relation_manager_person_gender_id varchar2 itgen_spe_person_relation_manager_person_gender_id
person_relation_manager_person_id varchar2 itgen_spe_person_relation_manager_person_id
person_relation_manager_person_id_2 varchar2 itgen_spe_person_relation_manager_person_id_2
person_relation_manager_person_initials varchar2 itgen_spe_person_relation_manager_person_initials
person_relation_manager_person_invoice_receiver varchar2 itgen_spe_person_relation_manager_person_invoice_receiver
person_relation_manager_person_is_active char itgen_spe_person_relation_manager_person_is_active
person_relation_manager_person_is_employee int64 itgen_spe_person_relation_manager_person_is_employee
person_relation_manager_person_linkedin_url varchar2 itgen_spe_person_relation_manager_person_linkedin_url
person_relation_manager_person_mailing_list_email varchar2 itgen_spe_person_relation_manager_person_mailing_list_email
person_relation_manager_person_note varchar2 itgen_spe_person_relation_manager_person_note
person_relation_manager_person_phone varchar2 itgen_spe_person_relation_manager_person_phone
person_relation_manager_person_relation_manager_avatar_color varchar2 itgen_spe_person_relation_manager_person_relation_manager_avatar_color
person_relation_manager_person_relation_manager_avatar_initials varchar2 itgen_spe_person_relation_manager_person_relation_manager_avatar_initials
person_relation_manager_person_relation_manager_avatar_url_large varchar2 itgen_spe_person_relation_manager_person_relation_manager_avatar_url_large
person_relation_manager_person_relation_manager_avatar_url_small varchar2 itgen_spe_person_relation_manager_person_relation_manager_avatar_url_small
person_relation_manager_person_relation_manager_bank_account varchar2 itgen_spe_person_relation_manager_person_relation_manager_bank_account
person_relation_manager_person_relation_manager_civil_status varchar2 itgen_spe_person_relation_manager_person_relation_manager_civil_status
person_relation_manager_person_relation_manager_created varchar2 itgen_spe_person_relation_manager_person_relation_manager_created
person_relation_manager_person_relation_manager_created_at varchar2 itgen_spe_person_relation_manager_person_relation_manager_created_at
person_relation_manager_person_relation_manager_employment_status varchar2 itgen_spe_person_relation_manager_person_relation_manager_employment_status
person_relation_manager_person_relation_manager_function varchar2 itgen_spe_person_relation_manager_person_relation_manager_function
person_relation_manager_person_relation_manager_hourly_cost_tariff double itgen_spe_person_relation_manager_person_relation_manager_hourly_cost_tariff
person_relation_manager_person_relation_manager_hourly_sales_tariff double itgen_spe_person_relation_manager_person_relation_manager_hourly_sales_tariff
person_relation_manager_person_relation_manager_id varchar2 itgen_spe_person_relation_manager_person_relation_manager_id
person_relation_manager_person_relation_manager_is_user char itgen_spe_person_relation_manager_person_relation_manager_is_user
person_relation_manager_person_relation_manager_marital_status varchar2 itgen_spe_person_relation_manager_person_relation_manager_marital_status
person_relation_manager_person_relation_manager_modified varchar2 itgen_spe_person_relation_manager_person_relation_manager_modified
person_relation_manager_person_relation_manager_name varchar2 itgen_spe_person_relation_manager_person_relation_manager_name
person_relation_manager_person_relation_manager_person_bank_account varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_bank_account
person_relation_manager_person_relation_manager_person_bank_bic varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_bank_bic
person_relation_manager_person_relation_manager_person_created_at varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_created_at
person_relation_manager_person_relation_manager_person_custom_salutation varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_custom_salutation
person_relation_manager_person_relation_manager_person_date_of_birth varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_date_of_birth
person_relation_manager_person_relation_manager_person_email varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_email
person_relation_manager_person_relation_manager_person_facebook_url varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_facebook_url
person_relation_manager_person_relation_manager_person_family_name varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_family_name
person_relation_manager_person_relation_manager_person_family_name_prefix varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_family_name_prefix
person_relation_manager_person_relation_manager_person_first_name varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_first_name
person_relation_manager_person_relation_manager_person_full_name varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_full_name
person_relation_manager_person_relation_manager_person_gender varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_gender
person_relation_manager_person_relation_manager_person_gender_id varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_gender_id
person_relation_manager_person_relation_manager_person_id varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_id
person_relation_manager_person_relation_manager_person_id_2 varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_id_2
person_relation_manager_person_relation_manager_person_initials varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_initials
person_relation_manager_person_relation_manager_person_invoice_receiver varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_invoice_receiver
person_relation_manager_person_relation_manager_person_is_active char itgen_spe_person_relation_manager_person_relation_manager_person_is_active
person_relation_manager_person_relation_manager_person_is_employee int64 itgen_spe_person_relation_manager_person_relation_manager_person_is_employee
person_relation_manager_person_relation_manager_person_linkedin_url varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_linkedin_url
person_relation_manager_person_relation_manager_person_mailing_list_email varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_mailing_list_email
person_relation_manager_person_relation_manager_person_note varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_note
person_relation_manager_person_relation_manager_person_phone varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_phone
person_relation_manager_person_relation_manager_person_relation_number varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_relation_number
person_relation_manager_person_relation_manager_person_simplicate_url varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_simplicate_url
person_relation_manager_person_relation_manager_person_timeline_email_address varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_timeline_email_address
person_relation_manager_person_relation_manager_person_twitter_url varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_twitter_url
person_relation_manager_person_relation_manager_person_updated_at varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_updated_at
person_relation_manager_person_relation_manager_person_use_custom_salutation char itgen_spe_person_relation_manager_person_relation_manager_person_use_custom_salutation
person_relation_manager_person_relation_manager_person_website_url varchar2 itgen_spe_person_relation_manager_person_relation_manager_person_website_url
person_relation_manager_person_relation_manager_simplicate_url varchar2 itgen_spe_person_relation_manager_person_relation_manager_simplicate_url
person_relation_manager_person_relation_manager_social_security_number varchar2 itgen_spe_person_relation_manager_person_relation_manager_social_security_number
person_relation_manager_person_relation_manager_status_id varchar2 itgen_spe_person_relation_manager_person_relation_manager_status_id
person_relation_manager_person_relation_manager_status_label varchar2 itgen_spe_person_relation_manager_person_relation_manager_status_label
person_relation_manager_person_relation_manager_timeline_email_address varchar2 itgen_spe_person_relation_manager_person_relation_manager_timeline_email_address
person_relation_manager_person_relation_manager_type_id varchar2 itgen_spe_person_relation_manager_person_relation_manager_type_id
person_relation_manager_person_relation_manager_type_label varchar2 itgen_spe_person_relation_manager_person_relation_manager_type_label
person_relation_manager_person_relation_manager_updated_at varchar2 itgen_spe_person_relation_manager_person_relation_manager_updated_at
person_relation_manager_person_relation_manager_work_email varchar2 itgen_spe_person_relation_manager_person_relation_manager_work_email
person_relation_manager_person_relation_manager_work_mobile varchar2 itgen_spe_person_relation_manager_person_relation_manager_work_mobile
person_relation_manager_person_relation_manager_work_phone varchar2 itgen_spe_person_relation_manager_person_relation_manager_work_phone
person_relation_manager_person_relation_number varchar2 itgen_spe_person_relation_manager_person_relation_number
person_relation_manager_person_relation_type_color varchar2 itgen_spe_person_relation_manager_person_relation_type_color
person_relation_manager_person_relation_type_id varchar2 itgen_spe_person_relation_manager_person_relation_type_id
person_relation_manager_person_relation_type_label varchar2 itgen_spe_person_relation_manager_person_relation_type_label
person_relation_manager_person_relation_type_type varchar2 itgen_spe_person_relation_manager_person_relation_type_type
person_relation_manager_person_simplicate_url varchar2 itgen_spe_person_relation_manager_person_simplicate_url
person_relation_manager_person_timeline_email_address varchar2 itgen_spe_person_relation_manager_person_timeline_email_address
person_relation_manager_person_twitter_url varchar2 itgen_spe_person_relation_manager_person_twitter_url
person_relation_manager_person_updated_at varchar2 itgen_spe_person_relation_manager_person_updated_at
person_relation_manager_person_use_custom_salutation char itgen_spe_person_relation_manager_person_use_custom_salutation
person_relation_manager_person_website_url varchar2 itgen_spe_person_relation_manager_person_website_url
person_relation_manager_simplicate_url varchar2 itgen_spe_person_relation_manager_simplicate_url
person_relation_manager_social_security_number varchar2 itgen_spe_person_relation_manager_social_security_number
person_relation_manager_status_id varchar2 itgen_spe_person_relation_manager_status_id
person_relation_manager_status_label varchar2 itgen_spe_person_relation_manager_status_label
person_relation_manager_timeline_email_address varchar2 itgen_spe_person_relation_manager_timeline_email_address
person_relation_manager_type_id varchar2 itgen_spe_person_relation_manager_type_id
person_relation_manager_type_label varchar2 itgen_spe_person_relation_manager_type_label
person_relation_manager_updated_at varchar2 itgen_spe_person_relation_manager_updated_at
person_relation_manager_work_email varchar2 itgen_spe_person_relation_manager_work_email
person_relation_manager_work_mobile varchar2 itgen_spe_person_relation_manager_work_mobile
person_relation_manager_work_phone varchar2 itgen_spe_person_relation_manager_work_phone
person_relation_number varchar2 itgen_spe_person_relation_number
person_relation_type_color varchar2 itgen_spe_person_relation_type_color
person_relation_type_id varchar2 itgen_spe_person_relation_type_id
person_relation_type_label varchar2 itgen_spe_person_relation_type_label
person_relation_type_type varchar2 itgen_spe_person_relation_type_type
person_simplicate_url varchar2 itgen_spe_person_simplicate_url
person_timeline_email_address varchar2 itgen_spe_person_timeline_email_address
person_twitter_url varchar2 itgen_spe_person_twitter_url
person_updated_at varchar2 itgen_spe_person_updated_at
person_use_custom_salutation char itgen_spe_person_use_custom_salutation
person_website_url varchar2 itgen_spe_person_website_url
simplicate_url varchar2 Simplicate URL
social_security_number varchar2 Numero della sicurezza sociale
status_id varchar2 ID dello stato
status_label varchar2 Etichetta dello stato
timeline_email_address varchar2 Indirizzo e-mail della timeline
type_id varchar2 Tipo di ID
type_label varchar2 Tipo di etichetta
updated_at varchar2 Aggiornato il
work_email varchar2 Email di lavoro
work_mobile varchar2 Cellulare lavoro
work_phone varchar2 Telefono di lavoro

Note di rilascio

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