invantive documentation
Forum di supporto InvantiveAccedi / Registrati

checkin_appointments: AFAS Profit itgen_aoe_checkin_appointments

read only REST

  • Catalogo: AfasOnline
  • Schema: GetConnector
  • Etichetta: itgen_aoe_checkin_appointments

È possibile solo recuperare i dati.

CheckIn_Appointments

Codice sorgente dell'API

  • Punto finale: /connectors/CheckIn_Appointments
  • Metadati: metainfo/get/CheckIn_Appointments

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 353
Righe di scansione completa al minuto 65,100
Numero di righe di Query al minuto 169

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella checkin_appointments. 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
appointment_end_time varchar2(5) appointment_end_time fetched only when named, appointment_end_time
appointment_id int32 appointment_id fetched only when named, appointment_id
appointment_location_id varchar2(25) appointment_location_id fetched only when named, appointment_location_id
appointment_location_name varchar2(100) appointment_location_name fetched only when named, appointment_location_name
appointment_name varchar2(100) appointment_name fetched only when named, appointment_name
appointment_start_time varchar2(5) appointment_start_time fetched only when named, appointment_start_time
contact_barcode varchar2(30) contact_barcode fetched only when named, contact_barcode
contact_code varchar2(15) contact_code fetched only when named, contact_code
contact_company varchar2(255) contact_company fetched only when named, contact_company
contact_first_name varchar2(50) contact_first_name fetched only when named, contact_first_name
contact_full_name varchar2(255) contact_full_name fetched only when named, contact_full_name
contact_full_name_roep varchar2(255) contact_full_name_roep fetched only when named, contact_full_name_roep
contact_id int32 contact_id fetched only when named, contact_id
contact_image_full_id varchar2(32) contact_image_full_id fetched only when named, contact_image_full_id
contact_image_full_name varchar2(255) contact_image_full_name fetched only when named, contact_image_full_name
contact_image_thumb_id varchar2(32) contact_image_thumb_id fetched only when named, contact_image_thumb_id
contact_image_thumb_name varchar2(255) contact_image_thumb_name fetched only when named, contact_image_thumb_name
contact_initials varchar2(15) contact_initials fetched only when named, contact_initials
contact_org_id varchar2(15) contact_org_id fetched only when named, contact_org_id
contact_roep_name varchar2(80) contact_roep_name fetched only when named, contact_roep_name
contact_surname varchar2(255) contact_surname fetched only when named, contact_surname
event_end_time datetime event_end_time fetched only when named, event_end_time
event_id int32 event_id fetched only when named, event_id
event_location_id varchar2(25) event_location_id fetched only when named, event_location_id
event_location_name varchar2(100) event_location_name fetched only when named, event_location_name
event_name varchar2(100) event_name fetched only when named, event_name
event_print_badge char event_print_badge fetched only when named, event_print_badge
event_session_id int32 event_session_id fetched only when named, event_session_id
event_start_time datetime event_start_time fetched only when named, event_start_time
event_take_photo char event_take_photo fetched only when named, event_take_photo