Calendars

Contains individual calendar entries associated with users. Each record represents a calendar that can be used for scheduling events, setting reminders, and tracking availability.

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 Name FROM Calendars WHERE Name LIKE 'John Calendar%'

Note: Unless specifying the AlwaysRequstTableDependencies connection property, or selecting/filtering by the reference CalendarGroupId, the value for CalendarGroupId will remain null.

Insert

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

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

Columns


Name	Type	ReadOnly	Description
calendarGroupId	String	False	Unique identifier of the calendar group to which this calendar belongs. This helps organize multiple calendars under a single group for easier management.
canEdit	Bool	False	Indicates whether the current user has permissions to modify the contents of this calendar, such as adding or updating events.
canShare	Bool	False	Specifies whether the calendar can be shared with other users, allowing collaboration or visibility into scheduling.
id [KEY]	String	False	Unique identifier of the calendar. This value is used to reference the calendar in API calls and database queries.
canViewPrivateItems	Bool	False	Indicates whether the user has access to view private events or entries within the calendar, which are normally hidden.
changeKey	String	False	Version identifier for the calendar object. It changes every time the calendar is updated, ensuring synchronization and conflict resolution.
color	String	False	Represents the display color assigned to the calendar, typically used in calendar views to distinguish it visually from others.
name	String	False	The display name of the calendar. This name is shown in user interfaces and helps users recognize the calendar's purpose.
owner_name	String	False	The full name of the person or entity that owns the calendar. This is typically used for display purposes in shared calendar contexts.
owner_address	String	False	The email address of the calendar owner. This helps identify the calendar source and enables calendar sharing or integration.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.