Calendar_OptionalAttendees

Captures information about optional attendees for scheduled calendar events. It requires an associated item Id to retrieve attendees linked to a specific meeting or appointment.

Table Specific Information

Select

The connector uses the EWS API to process WHERE clause conditions for this table.

ItemId supports the '=' operator.

Note: ItemId must be included in the WHERE clause to retrieve any data from the Calendar_OptionalAttendees table. This filter is required by the API and is evaluated server-side.

The following is an example query:

SELECT * FROM Calendar_OptionalAttendees WHERE ItemId = 'item-id'

Insert

To add an optional attendee to a calendar event, provide values for the required fields:

EmailAddress
ItemId

The following is an example INSERT statement:

INSERT INTO Calendar_OptionalAttendees (EmailAddress, ItemId, SendMeetingInvitations) VALUES ('[email protected]', 'itemid', 'SendOnlyToChanged')

Columns


Name	Type	ReadOnly	Description
EmailAddress [KEY]	String	False	The email address of the optional attendee being added to the calendar event. This must be a valid SMTP address recognized by the Exchange system.
ItemId [KEY]	String	False	A unique identifier referencing the calendar item to which the optional attendee is being added. This ID ensures the attendee is linked to the correct event.
Name	String	False	The display name of the optional attendee. This name is typically shown in the attendee list for the event.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.