EventInstances
Lists each individual occurrence of recurring or single-instance calendar events. It enables tracking of actual event instances, including exceptions or modified occurrences.
Table Specific Information
Select
The driver uses the Microsoft Graph API to process WHERE clause conditions built with the following column and operator:
- EventId supports the '=' operator.
Note: EventId must be included in the WHERE clause to retrieve any data from the EventInstances view. This filter is required by the API and is evaluated server-side.
StartDateTime and EndDateTime are optional filters used to define the date range for the instances returned. If these filters are not provided, the driver defaults to the last 30 days. If the specified EventId does not have any instances within the applicable time range, the query returns no results.
The following are example queries:
SELECT * FROM EventInstances WHERE EventId = 'event-id' AND StartDateTime = '2024/01/01' AND EndDateTime = '2024/12/31'
SELECT * FROM EventInstances WHERE EventId = 'event-id'
Columns
| Name | Type | Description |
| eventId | String | Unique identifier of the event series to which this specific instance belongs. Useful for grouping recurring events. |
| id [KEY] | String | Globally unique identifier for the specific event instance. Used to retrieve or update this instance. |
| categories | String | Comma-separated list of user-defined categories assigned to the event instance. Each category helps with filtering and organizing calendar items. |
| changeKey | String | Version key that changes whenever the event is updated. Helps maintain synchronization between client and server. |
| createdDateTime | Datetime | Timestamp indicating when the event instance was originally created in the system. |
| lastModifiedDateTime | Datetime | Timestamp showing the last time this event instance was modified, whether by the organizer or an attendee. |
| attendees | String | Comma-separated list of attendees for this event instance. Includes required, optional, and resource attendees. |
| body_contentType | String | Specifies the format of the event body content, such as 'text' or 'html'. Determines how the content is rendered. |
| body_content | String | Full textual content of the event description. Can include meeting agenda, call-in details, or additional context. |
| bodyPreview | String | Short preview of the event content, typically the first 255 characters. Useful for displaying a summary in UI elements. |
| end_dateTime | String | Date and time when the event instance ends. The value is in ISO 8601 format. |
| end_timeZone | String | Time zone in which the event end time is expressed, such as 'Pacific Standard Time' or 'UTC'. |
| hasAttachments | Bool | Boolean indicating whether the event includes file attachments such as documents or images. |
| iCalUId | String | Unique identifier from the iCalendar standard. Used to correlate instances across different calendar systems. |
| importance | String | Indicates the importance level of the event instance. Possible values include 'low', 'normal', and 'high'. |
| isAllDay | Bool | Boolean flag indicating whether the event instance spans the entire day without a specific start or end time. |
| isCancelled | Bool | Boolean flag indicating whether the event instance has been canceled by the organizer. |
| isOrganizer | Bool | Boolean flag indicating whether the signed-in user is the organizer of this event instance. |
| isReminderOn | Bool | Boolean flag indicating whether a reminder is set for this event instance. |
| location_displayName | String | The human-readable name of the location where the event is scheduled to take place, such as a conference room name or building title. |
| location_locationEmailAddress | String | The email address associated with the physical location, commonly used for booking or calendar integration. |
| location_address_street | String | The street address component of the event's location, providing the detailed street name and number. |
| location_address_city | String | The city in which the event location resides, helping to geographically pinpoint the venue. |
| location_address_state | String | The state, province, or regional administrative division of the event's location. |
| location_address_countryOrRegion | String | The country or region in which the event location exists, used for international differentiation. |
| location_address_postalCode | String | The postal or ZIP code assigned to the event's location, supporting regional identification and mailing purposes. |
| location_coordinates_altitude | Double | The altitude of the event location in meters above sea level, based on geographic coordinate data. |
| location_coordinates_latitude | Double | The latitude component of the event location's geographic coordinates, measured in decimal degrees. |
| location_coordinates_longitude | Double | The longitude component of the event location's geographic coordinates, measured in decimal degrees. |
| location_coordinates_accuracy | Double | The level of accuracy in meters for the location's latitude and longitude coordinates. |
| location_coordinates_altitudeAccuracy | Double | The estimated accuracy, in meters, of the altitude value associated with the event location. |
| location_locationUri | String | A URI (Uniform Resource Identifier) that uniquely identifies the event location within the system or network. |
| location_locationType | String | The type classification of the location, such as 'default', 'conferenceRoom', or 'homeAddress'. |
| location_uniqueId | String | A unique identifier assigned to the location, which helps in distinguishing it from other locations. |
| location_uniqueIdType | String | Specifies the type of the unique identifier used, such as 'private' or 'public', indicating the scope of uniqueness. |
| locations | String | A comma-separated list of locations associated with the event. Each location can include display name, email address, coordinates, and address components. |
| onlineMeetingUrl | String | The full URL link to the online meeting associated with the event, such as a Microsoft Teams or Skype link for virtual attendance. |
| organizer_emailAddress_name | String | The display name of the individual or entity who organized the event. This typically appears in calendar invitations and event details. |
| organizer_emailAddress_address | String | The email address of the event organizer, used to send invitations and receive responses from attendees. |
| originalEndTimeZone | String | The time zone in which the event was originally scheduled to end, before any changes were made. Useful for understanding legacy scheduling context. |
| originalStart | Datetime | The original start date and time of the event instance, prior to any updates or rescheduling actions. |
| originalStartTimeZone | String | The time zone in which the event was originally scheduled to start. Helps in reconstructing the event's original timing across regions. |
| recurrence_pattern_type | String | Defines the recurrence pattern type for the event, such as daily, weekly, absoluteMonthly, relativeMonthly, absoluteYearly, or relativeYearly. |
| recurrence_pattern_interval | Int | Specifies the interval between occurrences based on the recurrence pattern type. For example, a value of 2 with a weekly type means the event repeats every 2 weeks. |
| recurrence_pattern_month | Int | Indicates the month in which the recurring event takes place, applicable for yearly recurrence patterns. |
| recurrence_pattern_dayOfMonth | Int | Specifies the day of the month on which the event recurs. Relevant for monthly and yearly recurrence rules. |
| recurrence_pattern_daysOfWeek | String | Lists the days of the week on which the event occurs, such as Monday, Wednesday, or Friday. Multiple values are comma-separated. |
| recurrence_pattern_firstDayOfWeek | String | Defines the first day of the week used in the recurrence pattern, such as Sunday or Monday. Affects how weekly intervals are calculated. |
| recurrence_pattern_index | String | Specifies the instance of the day in the month for recurring events, such as first, second, third, fourth, or last. Used in relative monthly or yearly patterns. |
| recurrence_range_type | String | Defines how long the recurrence range lasts. Possible values include endDate, noEnd, and numbered, determining if the recurrence ends on a date, never ends, or occurs a set number of times. |
| recurrence_range_startDate | Date | The date on which the recurrence pattern begins. All repeating instances of the event are calculated from this starting point. |
| recurrence_range_endDate | Date | The end date of the recurrence pattern for the event series, indicating when the recurring events should stop repeating. |
| recurrence_range_recurrenceTimeZone | String | The time zone used for interpreting the recurrence pattern of the event. This ensures recurring events occur at consistent local times. |
| recurrence_range_numberOfOccurrences | Int | The total number of times the recurring event is scheduled to occur. Used when the recurrence pattern is based on a fixed count rather than an end date. |
| reminderMinutesBeforeStart | Int | The number of minutes before the event start time when a reminder is set to trigger for participants. |
| responseRequested | Bool | Indicates whether a response is requested from the attendees of the event. A value of true prompts invitees to send a response. |
| responseStatus_response | String | The current response status of the attendee, such as 'accepted', 'declined', 'tentativelyAccepted', or 'none'. |
| responseStatus_time | Datetime | The timestamp indicating when the attendee last updated their response status. |
| sensitivity | String | Specifies the sensitivity level of the event. Common values include 'normal', 'personal', 'private', and 'confidential'. This affects how the event is shared with others. |
| seriesMasterId | String | The identifier of the series master event that this instance belongs to. Used to associate individual occurrences with the recurring event series. |
| showAs | String | Describes how the attendee's availability is displayed during the event, such as 'free', 'tentative', 'busy', or 'out of office'. |
| start_dateTime | String | The start date and time of the event instance, represented in ISO 8601 format. |
| start_timeZone | String | The time zone in which the event start time is expressed, allowing for accurate scheduling across regions. |
| subject | String | The subject or title of the event, typically a brief summary visible on the calendar. |
| type | String | Indicates the type of event instance, such as 'singleInstance', 'occurrence', 'exception', or 'seriesMaster'. |
| webLink | String | A URL that opens the event in a web-based calendar application. Useful for direct access to the event details in a browser. |