invantive documentation
Invantive Support ForumsLog In / Sign Up

APPOINTMENTS: Outlook Appointments

insert update delete

  • Catalog: Outlook
  • Schema: Calendars
  • Primary Keys: EntryID
  • Label: Appointments

Can retrieve data and change data using insert, update and delete.

Summary

Outlook appointments.

Parameters

Name Data Type Required Default Documentation
folderEntryId `` Unique ID of the folder as a reference to the table 'FOLDERS'.
storeEntryId `` Unique ID of a store as a reference to the table 'FOLDERS' when queried with include external stores.

Table Columns

The columns of the table 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
AllDayEvent boolean
BillingInformation varchar2
Body varchar2
BusyStatus numeric
Categories varchar2 Categories
ConversationIndex varchar2
ConversationTopic varchar2
CreationTime datetime
Duration numeric
End datetime
EntryID varchar2(1024)
FolderID varchar2(1024)
Importance numeric
IsOnlineMeeting boolean
IsRecurring boolean
LastModificationTime datetime
Location varchar2
MeetingStatus numeric
MeetingWorkspaceURL varchar2
Mileage varchar2
NetMeetingAutoStart boolean
NetMeetingDocPathName varchar2
NetMeetingOrganizerAlias varchar2
NetMeetingServer varchar2
NetMeetingType numeric
NetShowURL varchar2
NoAging boolean
OptionalAttendees varchar2
Organizer varchar2
ReminderMinutesBeforeStart numeric
ReminderOverrideDefault boolean
ReminderPlaySound boolean
ReminderSet boolean
ReminderSoundFile varchar2
ReplyTime datetime
RequiredAttendees varchar2
Resources varchar2
ResponseRequested boolean
ResponseStatus numeric
Sensitivity numeric
Size numeric
Start datetime
StoreID varchar2(1024)
Subject varchar2
UnRead boolean

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: