Create, update, delete, and query calendars in Google.

Table-Specific Information

Select

When selecting calendars no fields are required. In addition an Id can be specified for filtering the result. For example:

SELECT Id, Summary, Description FROM Calendars

Insert

To insert a new calendar, issue an INSERT statement and specify a value for at least the Summary column. For example:

INSERT INTO Calendars (Summary) VALUES ('My Custom Calendar')

To insert an existing calendar, a shared one or a global/domain public one, into the user's calendars list, you will need to execute an INSERT statement by specifying at least the existing CalendarId in the statement.

For example, to add a shared calendar from a specific user, you can execute a query as below.

INSERT INTO Calendars (Id) VALUES('user1@cdatatest.page')

For example, to add a public calendar, you can execute a query as below.

INSERT INTO Calendars (id, SummaryOverride) VALUES('en.usa#holiday@group.v.calendar.google.com', 'Official Holidays in the US')

Update

To update a calendar, the Id column must be specified. Only the Description, Location, Summary, and Timezone columns are updateable. For example:

UPDATE Calendars SET Description='Updated Description' WHERE Id='8ba774m3anenroqcepfi7ka6ok'

Delete

Delete a calendar by specifying its Id. For example:

DELETE FROM Calendars WHERE Id='123456789'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	The calendar identifier.
Summary	String	False	The title of the calendar.
Description	String	False	The description of the calendar.
Kind	String	True	The type of the resource.
ETag	String	True	The ETag of the resource.
Location	String	False	The geographic location of the calendar as free-form text.
Timezone	String	False	The time zone of the calendar.
SummaryOverride	String	False	The summary that the authenticated user has set for the calendar.
ColorId	Integer	False	The color of the calendar. This is an Id referring to an entry in the 'calendar' section of the colors definition.
Hidden	Boolean	False	This field sets whether the calendar has been hidden from the list.
Selected	Boolean	False	This field sets whether the calendar content shows up in the calendar UI.
AccessRole	String	True	The effective access role that the authenticated user has on the calendar.
ReminderMethods	String	False	A semicolon-separated list of the methods used by the reminder. Possible values are: EMAIL, SMS, and POPUP.
ReminderMinutes	String	False	A semicolon-separated list of minutes before the start of the event when the corresponding ReminderOverrideMethod should trigger.

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.

Name	Type	Description
ShowHidden	Boolean	This value sets whether to show hidden calendars. The default value is False.