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 add-in 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 add-in 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. |