Calendars

Provides details about calendars associated with users, including names, time zones, and ownership metadata. Maps dynamically to the API fields.

Table Specific Information

Select

You can query Calendars by specifying an Id or selecting all:

SELECT * FROM Calendars WHERE Id = 'your Calendar Id goes here'

Select a certain column from the entity and filter by that column:

SELECT id FROM Calendars WHERE name LIKE 'Calendar%'

Insert

Specify a Name as a minimum in order to create a new Calendar:

INSERT INTO Calendars (Name) VALUES ('John')

Note: In case of client credentials, UserId is required in order to create a new Calendar:

INSERT INTO Calendars (Name, UserId) VALUES ('Test123', '92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe');

Columns


Name	Type	ReadOnly	References	Description
id [KEY]	String	True		Unique identifier for the calendar object within the user's mailbox.
Etag	String	False		Entity tag used for version control of the calendar object.
allowedOnlineMeetingProviders	String	False		List of online meeting providers (with 1 space after each comma) that are allowed for this calendar, such as Teams, Skype, Webex.
canEdit	Bool	False		Indicates whether the user has permission to edit events on this calendar.
canShare	Bool	False		Indicates whether the user has permission to share this calendar with others.
canViewPrivateItems	Bool	False		Indicates whether the user can view events marked as private on this calendar.
changeKey	String	False		Token used to identify the version of the calendar object and detect changes.
color	String	False		Predefined color name assigned to this calendar for visual differentiation.
defaultOnlineMeetingProvider	String	False		Specifies the default provider used when scheduling online meetings from this calendar.
hexColor	String	False		Hexadecimal color code associated with the calendar (for example, #FF5733) for custom coloring.
isDefaultCalendar	Bool	False		Indicates whether this calendar is the user's default calendar.
isRemovable	Bool	False		Indicates whether this calendar can be removed by the user.
isTallyingResponses	Bool	False		Specifies whether responses to event invitations on this calendar are being tracked.
name	String	False		Display name assigned to the calendar, such as 'Work' or 'Personal'.
owner_address	String	False		Email address of the owner of the calendar.
owner_name	String	False		Display name of the calendar owner.
UserId [KEY]	String	False		Identifier of the user associated with the calendar entry.

Power BI Connector for Microsoft Office 365

Calendars

Table Specific Information

Select

Insert

Columns