invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

checkin_appointments: AFAS Profit itgen_aoe_checkin_appointments

read only REST

  • Catalogus: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_checkin_appointments

Kan alleen gegevens ophalen.

Samenvatting

CheckIn_Appointments

API-bron

  • Eindpunt: /connectors/CheckIn_Appointments
  • Metagegevens: metainfo/get/CheckIn_Appointments

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 353
Aantal rijen per minuut bij volledige scan 65,100
Aantal rijen per minuut in een Query 169

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel checkin_appointments worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype 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