Power BI Connector for Microsoft Office 365

Build 23.0.8839

CalendarView

Retrieve the ccurrences, 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.

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
Etag String
categories String
changeKey String
createdDateTime Datetime
lastModifiedDateTime Datetime
allowNewTimeProposals Bool
attendees String
body_content String
body_contentType String
bodyPreview String
end_dateTime Datetime
end_timeZone String
hasAttachments Bool
hideAttendees Bool
iCalUId String
importance String
isAllDay Bool
isCancelled Bool
isDraft Bool
isOnlineMeeting Bool
isOrganizer Bool
isReminderOn Bool
location_address_city String
location_address_countryOrRegion String
location_address_postalCode String
location_address_state String
location_address_street String
location_coordinates_accuracy Double
location_coordinates_altitude Double
location_coordinates_altitudeAccuracy Double
location_coordinates_latitude Double
location_coordinates_longitude Double
location_displayName String
location_locationEmailAddress String
location_locationType String
location_locationUri String
location_uniqueId String
location_uniqueIdType String
locations String
onlineMeeting_conferenceId String
onlineMeeting_joinUrl String
onlineMeeting_phones String
onlineMeeting_quickDial String
onlineMeeting_tollFreeNumbers String
onlineMeeting_tollNumber String
onlineMeetingProvider String
onlineMeetingUrl String
organizer_emailAddress_address String
organizer_emailAddress_name String
originalEndTimeZone String
originalStart Datetime
originalStartTimeZone String
recurrence_pattern_dayOfMonth Int
recurrence_pattern_daysOfWeek String
recurrence_pattern_firstDayOfWeek String
recurrence_pattern_index String
recurrence_pattern_interval Int
recurrence_pattern_month Int
recurrence_pattern_type String
recurrence_range_endDate Datetime
recurrence_range_numberOfOccurrences Int
recurrence_range_recurrenceTimeZone String
recurrence_range_startDate Datetime
recurrence_range_type String
reminderMinutesBeforeStart Int
responseRequested Bool
responseStatus_response String
responseStatus_time Datetime
sensitivity String
seriesMasterId String
showAs String
start_dateTime Datetime
start_timeZone String
subject String
transactionId String
type String
webLink String
UserId String
CalendarId String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839