CalendarView
Returns a filtered list of calendar events such as occurrences, exceptions, and single instances, within a specified time range from a user's calendar.
Table Specific Information
Select
Get the occurrences, exceptions, and single instances of events in a calendar view defined by a time range, from the user's default calendar, or from some other calendar of the user's. By default only the event occurrences from the user's default calendar in the range of the last 30 days will be returned. You can filter results by CalendarId, UserId, Start_DateTime, End_DateTime.
For example the following queries will be processed server side:
SELECT * FROM CalendarView WHERE Start_DateTime >= '2019-12-10 15:00' AND End_DateTime <= '2020-01-10 14:30'
SELECT * FROM CalendarView WHERE CalendarId = 'AQMkAGRlMWQ5MDg0LWI5ZTQtNDk2Yi1hOTQ1LTU4YzFmMzEwZjlhMgBGAAAD-FjxR3cIwE6TEGSCVtIHcwcAQyR2Iw3coEOaUD1BLt0tnAAAAwcAAABDJHYjDdygQ5pQPUEu3S2cAAACC_IAAAA='
SELECT * FROM CalendarView WHERE CalendarId = 'AQMkAGRlMWQ5MDg0LWI5ZTQtNDk2Yi1hOTQ1LTU4YzFmMzEwZjlhMgBGAAAD-FjxR3cIwE6TEGSCVtIHcwcAQyR2Iw3coEOaUD1BLt0tnAAAAwcAAABDJHYjDdygQ5pQPUEu3S2cAAACC_IAAAA=' AND UserId = 'a98f25b5-5da1-4937-8729-c0d03026caa0' AND Start_DateTime >= '2019-12-15 08:00' AND End_DateTime <= '2020-01-14 08:00'
Columns
| Name | Type | References | Description |
| id [KEY] | String | Unique identifier for the calendar event. | |
| Etag | String | Entity tag used to identify changes to the event object. | |
| categories | String | List of user-defined categories associated with the event. | |
| changeKey | String | Version key for the event, used to track updates. | |
| createdDateTime | Datetime | Timestamp indicating when the event was created. | |
| lastModifiedDateTime | Datetime | Timestamp indicating the last time the event was updated. | |
| allowNewTimeProposals | Bool | Indicates whether attendees can suggest new meeting times. | |
| attendees | String | List of people invited to the event, including required and optional attendees. | |
| body_content | String | Main content of the event body. | |
| body_contentType | String | Type of the content in the event body, such as HTML or plain text. | |
| bodyPreview | String | Short preview of the event body content. | |
| end_dateTime | Datetime | Date and time when the event ends. | |
| end_timeZone | String | Time zone of the event end time. | |
| hasAttachments | Bool | Indicates whether the event includes file attachments. | |
| hideAttendees | Bool | Indicates whether attendee details are hidden from others. | |
| iCalUId | String | Unique iCalendar identifier used across systems. | |
| importance | String | Importance level of the event such as low, normal, or high. | |
| isAllDay | Bool | Specifies whether the event is an all-day event. | |
| isCancelled | Bool | Indicates whether the event has been canceled. | |
| isDraft | Bool | Indicates whether the event is in draft status. | |
| isOnlineMeeting | Bool | Specifies whether the event is an online meeting. | |
| isOrganizer | Bool | Indicates whether the current user is the organizer of the event. | |
| isReminderOn | Bool | Indicates whether a reminder is set for the event. | |
| location_address_city | String | City where the event location is situated. | |
| 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 coordinates in meters. | |
| location_coordinates_altitude | Double | Altitude of the event location in meters. | |
| location_coordinates_altitudeAccuracy | Double | Accuracy of the altitude value 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 location of the event. | |
| location_locationEmailAddress | String | Email address associated with the location, if available. | |
| location_locationType | String | Type of location, such as default, conference room, or custom. | |
| location_locationUri | String | URI that uniquely identifies the location resource. | |
| location_uniqueId | String | Unique identifier for the location object. | |
| location_uniqueIdType | String | Specifies the format of the unique location ID. | |
| locations | String | List of all locations associated with the event. | |
| onlineMeeting_conferenceId | String | Conference ID provided by the online meeting provider. | |
| onlineMeeting_joinUrl | String | URL used by attendees to join the online meeting. | |
| onlineMeeting_phones | String | List of phone numbers that can be used to dial into the meeting. | |
| onlineMeeting_quickDial | String | Preformatted string for one-tap mobile dialing into the meeting. | |
| onlineMeeting_tollFreeNumbers | String | Toll-free numbers attendees can use to join. Values are comma-separated with 1 space after each comma. | |
| onlineMeeting_tollNumber | String | Primary toll number attendees can use to join the meeting. | |
| onlineMeetingProvider | String | Name of the service provider hosting the online meeting, such as Skype. | |
| onlineMeetingUrl | String | URL that opens the full online meeting experience in a browser. | |
| organizer_emailAddress_address | String | Email address of the meeting organizer. | |
| organizer_emailAddress_name | String | Display name of the person organizing the meeting. | |
| originalEndTimeZone | String | Time zone in which the event was originally set to end. | |
| originalStart | Datetime | Original start date and time of the event before any updates. | |
| originalStartTimeZone | String | Time zone in which the event was originally scheduled to start. | |
| recurrence_pattern_dayOfMonth | Int | Day of the month when the recurring event occurs. | |
| recurrence_pattern_daysOfWeek | String | Days of the week when the event recurs. Values are comma-separated with 1 space after each comma. | |
| recurrence_pattern_firstDayOfWeek | String | The first day of the week used in the recurrence pattern. | |
| recurrence_pattern_index | String | Specifies which instance in the recurrence, such as first, second, or last. | |
| recurrence_pattern_interval | Int | Interval between recurrences, based on the pattern type. | |
| recurrence_pattern_month | Int | Month of the year when the event recurs, used for yearly patterns. | |
| recurrence_pattern_type | String | Type of recurrence pattern, such as daily, weekly, monthly, or yearly. | |
| recurrence_range_endDate | Datetime | Date when the recurrence pattern ends. | |
| recurrence_range_numberOfOccurrences | Int | Number of times the recurring event should occur. | |
| recurrence_range_recurrenceTimeZone | String | Time zone used for the recurrence schedule. | |
| recurrence_range_startDate | Datetime | Start date of the recurrence range. | |
| recurrence_range_type | String | Defines the way recurrence ends, such as after a number of occurrences or on a specific end date. | |
| reminderMinutesBeforeStart | Int | Number of minutes before the event start at which the reminder triggers. | |
| responseRequested | Bool | Indicates whether the organizer is requesting responses from attendees. | |
| responseStatus_response | String | The attendee's response status, such as accepted, declined, or tentative. | |
| responseStatus_time | Datetime | Date and time when the attendee submitted their response. | |
| sensitivity | String | Sensitivity setting for the event, such as normal, personal, private, or confidential. | |
| seriesMasterId | String | Identifier of the master event in a recurring series. | |
| showAs | String | How the event appears on the calendar, such as free, busy, or tentative. | |
| start_dateTime | Datetime | Date and time when the event starts. | |
| start_timeZone | String | Time zone associated with the event's start time. | |
| subject | String | Title or subject line of the calendar event. | |
| transactionId | String | Client-supplied ID used to ensure idempotency of create requests. | |
| type | String | Type of event, such as singleInstance, occurrence, or exception. | |
| webLink | String | URL to view the event in a web browser. | |
| UserId | String | Identifier of the user associated with the calendar event. | |
| CalendarId | String | Identifier of the calendar that contains the event. |