JDBC Driver for Google Calendar

Build 22.0.8462


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

Table-Specific Information


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


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')


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 a calendar by specifying its Id. For example:

DELETE FROM Calendars WHERE Id='123456789'


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 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462