Excel Add-In for Google Calendar

Build 21.0.7930

Calendars

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 String

This value sets whether to show hidden calendars.

The allowed values are TRUE, FALSE.

The default value is False.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930