Calendar_RequiredAttendees
Stores data on required attendees for calendar events. The queries must specify an item Id to identify the associated meeting and its required participants.
Table Specific Information
Select
The provider 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_RequiredAttendees table. This filter is required by the API and is evaluated server-side.
The following is an example query:
SELECT * FROM Calendar_RequiredAttendees WHERE ItemId = 'item-id'
Insert
To add a required attendee to a calendar event, provide values for the required fields:
- EmailAddress
- ItemId
The following is an example INSERT statement:
INSERT INTO Calendar_RequiredAttendees (EmailAddress, ItemId, SendMeetingInvitations) VALUES ('[email protected]', 'itemid', 'SendOnlyToChanged')
Columns
| Name | Type | ReadOnly | Description |
| EmailAddress [KEY] | String | False |
Specifies the email address of a required attendee for the calendar event. This address is used to send meeting invitations and track responses. |
| ItemId | String | False |
Represents the unique identifier of the calendar item (such as a meeting or appointment) to which the required attendee is being added. |
| Name | String | False |
Displays the display name of the required attendee as it appears in the calendar item or contact list. |
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.
| Name | Type | Description |
| ImpersonationUser | String |
Specifies the identifier of the user account to impersonate during the request. This allows actions to be performed on behalf of another user. |
| ImpersonationType | String |
Indicates the type of identifier used for impersonation. Accepted values include PrincipalName, SID, PrimarySmtpAddress, and SmtpAddress. |
| SendMeetingInvitations | String |
Determines how meeting invitations are handled after the calendar event is created or modified. Possible values include SendToNone, SendOnlyToAll, SendOnlyToChanged, and SendToAllAndSaveCopy. The default behavior is SendToNone. |