invantive documentation
Invantive Support ForumsLog In / Sign Up

checkin_appointments: AFAS Profit itgen_aoe_checkin_appointments

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_checkin_appointments

Can only retrieve data.

Summary

CheckIn_Appointments

API Source

  • Endpoint: /connectors/CheckIn_Appointments
  • Metadata: metainfo/get/CheckIn_Appointments

Performance Characteristics

Characteristic Value
Average access latency (ms) 353
Full scan rows per minute 65,100
Point query rows per minute 169

The result can be cached on the client.

Table Columns

The columns of the table checkin_appointments are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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