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

テーブル固有の情報

Select

カレンダーのSelect にはフィールド指定は不要です。追加で、Id を指定して結果をフィルタリングできます。次に例を示します。

SELECT Id, Summary, Description FROM Calendars

Insert

新しいカレンダーを挿入するには、INSERT ステートメントを発行して少なくともSummary カラムの値を指定します。次に例を示します。

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 ('[email protected]')

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

INSERT INTO Calendars (id, SummaryOverride) VALUES ('en.usa#[email protected]', 'Official Holidays in the US')

Update

カレンダーを更新するには、Id カラムを指定する必要があります。Description、Location、Summary、およびTimezone カラムは更新できません。次に例を示します。

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

Delete

カレンダーの削除にはId を指定して行います。

DELETE FROM Calendars WHERE Id = '123456789'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	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.
DataOwner	String	True	The email address of the single data owner of this 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。

Name	Type	Description
showHidden	String	This value sets whether to show hidden calendars. デフォルト値はFalseです。