EventOccurrences
Provides a flattened view of recurring event instances, enabling analysis of each occurrence individually.
Table Specific Information
Select
You can query EventOccurrences by specifying the Event Id, StartDatetime and EndDateTime. EventId is a required field, instead StartDatetime and EndDateTime have a default range of the last 30 days. If you query filtering only by EventId and the specific event does not exist within this time range, you will get empty results.
SELECT * FROM [EventOccurrences] WHERE id = 'event id' AND StartDateTime = '2018/01/01' AND EndDateTime = '2018/12/31'
By default, if StartDateTime and EndDateTime filters are not specified, only the event occurrences from the user's default calendar in the range of the last 30 days will be returned. Otherwise, the query will get the Occurrences of the Event during the period specified by StartDateTime and EndDateTime.
Columns
| Name | Type | References | Description |
| GroupId | String | Identifier of the Microsoft 365 group that owns the event. | |
| UserId | String | Identifier of the user who is associated with the event. | |
| Events_id [KEY] | String |
Events.id | Identifier of the parent event series from which this occurrence is derived. |
| id [KEY] | String | Unique identifier for this specific event occurrence. | |
| categories | String | List of categories assigned to the event for classification or filtering. | |
| changeKey | String | Version key that updates each time the event occurrence is modified. | |
| createdDateTime | Datetime | Timestamp indicating when the event occurrence was created. | |
| lastModifiedDateTime | Datetime | Timestamp indicating the last time the event occurrence was modified. | |
| allowNewTimeProposals | Bool | Indicates whether attendees can suggest a new time for the event. | |
| attendees | String | List of attendees invited to the event. For example: [email protected], [email protected]. | |
| body_content | String | Main message body or description of the event. | |
| body_contentType | String | Format of the message body, such as text or HTML. | |
| bodyPreview | String | Short preview of the event message body. | |
| end_dateTime | Datetime | Scheduled end time of the event. | |
| end_timeZone | String | Time zone used for the event's end time. | |
| hasAttachments | Bool | Indicates whether the event occurrence includes file attachments. | |
| hideAttendees | Bool | Indicates whether attendee information is hidden from others. | |
| iCalUId | String | Unique identifier used for cross-system calendar interoperability. | |
| importance | String | Level of importance assigned to the event, such as low, normal, or high. | |
| isAllDay | Bool | Indicates whether the event is an all-day event with no specific start or end time. | |
| isCancelled | Bool | Indicates whether the event occurrence has been canceled. | |
| isDraft | Bool | Indicates whether the event is still a draft and not finalized. | |
| isOnlineMeeting | Bool | Indicates whether the event includes an online meeting link. | |
| isOrganizer | Bool | Indicates whether the current user is the organizer of the event. | |
| isReminderOn | Bool | Indicates whether a reminder is set for this event occurrence. | |
| location_address_city | String | City of the event location. | |
| location_address_countryOrRegion | String | Country or region of the event location. | |
| location_address_postalCode | String | Postal code of the event location. | |
| location_address_state | String | State or province of the event location. | |
| location_address_street | String | Street address of the event location. | |
| location_coordinates_accuracy | Double | Accuracy of the provided location coordinates in meters. | |
| location_coordinates_altitude | Double | Altitude of the location in meters above sea level. | |
| location_coordinates_altitudeAccuracy | Double | Accuracy of the altitude measurement in meters. | |
| location_coordinates_latitude | Double | Latitude of the event location. | |
| location_coordinates_longitude | Double | Longitude of the event location. | |
| location_displayName | String | Display name for the event location. | |
| location_locationEmailAddress | String | Email address of the location resource, if applicable. | |
| location_locationType | String | Type of location, such as default, conference room, or home address. | |
| location_locationUri | String | Uniform Resource Identifier (URI) for the location, if available. | |
| location_uniqueId | String | Unique identifier for the physical or virtual location. | |
| location_uniqueIdType | String | Type of identifier used for the location, such as locationStore or directory. | |
| locations | String | List of additional locations for the event. For example: Main Hall, Room 204. | |
| onlineMeeting_conferenceId | String | Unique conference ID for the online meeting provider. | |
| onlineMeeting_joinUrl | String | Join URL that participants can use to enter the online meeting. | |
| onlineMeeting_phones | String | List of dial-in phone numbers for the online meeting. | |
| onlineMeeting_quickDial | String | Quick dial string for joining the online meeting directly. | |
| onlineMeeting_tollFreeNumbers | String | List of toll-free phone numbers for the online meeting. For example: 8001234567, 8887654321. | |
| onlineMeeting_tollNumber | String | Toll number provided for participants to join by phone. | |
| onlineMeetingProvider | String | Online meeting provider, such as Teams or Skype for Business. | |
| onlineMeetingUrl | String | URL used to launch or view the online meeting. | |
| organizer_emailAddress_address | String | Email address of the event organizer. | |
| organizer_emailAddress_name | String | Display name of the event organizer. | |
| originalEndTimeZone | String | Time zone used for the original end time before any changes. | |
| originalStart | Datetime | Original start time of the event before any rescheduling. | |
| originalStartTimeZone | String | Time zone used for the original start time. | |
| recurrence_pattern_dayOfMonth | Int | Day of the month on which the event repeats, if applicable. | |
| recurrence_pattern_daysOfWeek | String | Days of the week on which the event repeats. For example: Monday, Wednesday, Friday. | |
| recurrence_pattern_firstDayOfWeek | String | First day of the week for the recurrence pattern. | |
| recurrence_pattern_index | String | Position in the month the event recurs, such as first, second, or last. | |
| recurrence_pattern_interval | Int | Interval at which the event repeats, such as every 2 days or every 3 weeks. | |
| recurrence_pattern_month | Int | Month of the year when the event recurs, used for yearly patterns. | |
| recurrence_pattern_type | String | Pattern type used for recurrence, such as daily, weekly, monthly, or yearly. | |
| recurrence_range_endDate | Datetime | Date on which the recurrence pattern ends. | |
| recurrence_range_numberOfOccurrences | Int | Total number of times the event should occur. | |
| recurrence_range_recurrenceTimeZone | String | Time zone used for the recurrence pattern. | |
| recurrence_range_startDate | Datetime | Start date of the recurrence range. | |
| recurrence_range_type | String | Specifies whether the recurrence ends by end date, number of occurrences, or has no end. | |
| reminderMinutesBeforeStart | Int | Number of minutes before the event when a reminder should be triggered. | |
| responseRequested | Bool | Indicates whether the organizer requests attendee responses. | |
| responseStatus_response | String | Current response status from the attendee, such as accepted or declined. | |
| responseStatus_time | Datetime | Timestamp of the most recent response from the attendee. | |
| sensitivity | String | Sensitivity label for the event, such as normal, personal, private, or confidential. | |
| seriesMasterId | String | Identifier of the master series event, used to link recurring occurrences. | |
| showAs | String | Calendar availability status during the event, such as free, tentative, busy, or out of office. | |
| start_dateTime | Datetime | Scheduled start time of the event. | |
| start_timeZone | String | Time zone used for the event's start time. | |
| subject | String | Subject or title of the event. | |
| transactionId | String | Client-supplied identifier used to detect duplicate event creations. | |
| type | String | Type of event occurrence, such as singleInstance, occurrence, exception, or seriesMaster. | |
| webLink | String | URL to open the event occurrence in a web browser. |