Excel Add-In for Google Calendar

Build 23.0.8839

MyCalendar

Create, update, delete, and query events of the calendar.

テーブル固有の情報

この例では、カレンダーがどのようにテーブルとして表されるかを説明します。

Select

特定のカレンダーのイベントをクエリします。 

SELECT * FROM [MyCalendar]

Insert

カレンダーに新しいイベントを作成します。少なくてもStartDateTime およびEndDateTime が指定されている必要があります。 

INSERT INTO [MyCalendar] (Summary, Description, StartDateTime, EndDateTime) VALUES ('Great Event', 'Description for event', '8/27/2017', '8/28/2017')

You can create an All-Day event by setting the StartDate and EndDate columns to the actual start and end dates of the event. 

INSERT INTO [MyCalendar] (Summary, Description, StartDate, EndDate) VALUES ('Google Cal Test Event 1', 'Example All Day Event', '2017-01-01', '2017-01-09')

You can create a Time Limited event by setting the StartDateTime and EndDateTime columns to the actual start and end dates and times of the event. 

INSERT INTO [MyCalendar] (Summary, Description, StartDateTime, EndDateTime) VALUES ('Google Cal Test Event 2', 'Example Time Limited Event', '2017-09-05T22:13:03', '2017-09-11T13:24:10')

新しいイベントを挿入する際には、AttendeesEmails およびAttendeesDeisplayNames には複数の値を指定することが可能です。 

INSERT INTO [MyCalendar] (StartDateTime, EndDateTime, AttendeesEmails) VALUES ('2017-03-15 15:00', '2017-03-15 20:00', 'test@test.com,test1@test.com')

Update

特定のイベントの詳細を更新します。更新されるイベントのId が指定される必要があります。 

UPDATE [MyCalendar] SET Summary = 'Updated Summary 2' WHERE Id = '8ba774m3anenroqcepfi7ka6ok'

You can update a Time Limited event to an All-Day one by setting the StartDate and EndDate columns to the actual start and end dates of the event, and the StartDateTime and EndDateTime columns to Null-s. 

UPDATE [MyCalendar] SET StartDate = '2017-09-05', EndDate = '2017-09-11', StartDateTime = NULL, EndDateTime = NULL WHERE Id = '8ba774m3anenroqcepfi7ka6ok'

You can update an All-Day event to a Time Limited one by setting the StartDateTime and EndDateTime columns to the actual start and end dates and times of the event, and the StartDate and EndDate columns to Null-s. 

UPDATE [MyCalendar] SET StartDate = NULL, EndDate = NULL, StartDateTime = '2017-09-05T22:13:03', EndDateTime = '2017-09-11T13:24:10' WHERE Id = '8ba774m3anenroqcepfi7ka6ok'

削除

イベントの削除は、Id を指定して行います。 

DELETE FROM [MyCalendar] WHERE Id = '8ba774m3anenroqcepfi7ka6ok'

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the event.

CalendarId String False

Calendar Id. This can be used to override the Calendar Id for which you are querying events.

Summary String False

The title of the event.

Description String False

The description of the event.

Location String False

The geographic location of the event as free-form text.

AllDayEvent Boolean True

This value indicates whether or not the event is an all-day event.

StartDate Date False

The start date if this is an all-day event.

StartDateTime Datetime False

The (inclusive) start time of the event. For a recurring event, this value is the start time of the first instance.

StartDateTimeZone String False

The time zone in which the start date time is specified.

EndDate Date False

The end date if this is an all-day event.

EndDateTime Datetime False

The (exclusive) end time of the event. For a recurring event, this value is the end time of the first instance.

EndDateTimeZone String False

The time zone in which the end date time is specified.

OriginalStartTimeDateTime Datetime False

For an instance of a recurring event, this value is the time when the event would start according to the recurrence data in the recurring event identified by RecurringEventId.

SendNotification Boolean False

This value sets whether to send a notification when performing an insert or update.

Kind String True

The type of the resource, returned in the format calendar#event.

ETag String True

The ETag of the resource.

Status String False

The status of the event.

HTML_Link String True

The absolute link to the event in the Google Calendar Web UI.

Locked Boolean True

Whether this is a locked event copy where no changes can be made to the main event fields

SourceTitle String False

Title of the source; for example a title of a web page or an email subject.

SourceURL String False

URL of the source pointing to a resource. The URL scheme must be HTTP or HTTPS.

HangoutLink String True

An absolute link to the Google+ hangout associated with this event, if there is any.

Created Datetime True

The creation time of the event.

Updated Datetime True

The latest modification time of the event.

ColorId Integer False

The color of the event. This value is an Id referring to an entry in the event section of the colors definitions.

CreatorEmail String True

The creator's email address, if available.

CreatorDisplayName String True

The creator's name, if available.

OrganizerEmail String True

The organizer's email address, if available.

OrganizerDisplayName String True

The organizer's name, if available.

Recurrences String False

A pipe-separated list of RRULE, EXRULE, RDATE, and EXDATE lines for a recurring event. This field is omitted for single events or instances of recurring events. OriginalStartTimeDateTime must be set in order to modify this value.

RecurringEventId String True

For an instance of a recurring event, this value is the event Id of the recurring event itself.

Transparency String False

This value sets whether the event blocks time on the calendar. If set to transparent, the event does not block time on the calendar. If set to opaque, the event blocks time; this is the default value.

Visibility String False

The visibility of the event.

ICalUid String True

The event Id in the iCalendar format.

Sequence String False

The sequence number as per iCalendar.

AttendeesEmails String False

A comma-separated list of attendee's email addresses, if available.

AttendeesDisplayNames String False

A comma-separated list of attendee's names, if available.

AttendeesResponseStatus String False

A comma-separated list of attendee's response status, if available.

AttendeesOmitted Boolean True

This field sets whether attendees have been omitted from the event's representation. When updating an event, this field can be used to update only the participant's response. When retrieving an event, the attendees that are returned are restricted to only the participant by the MaxAttendees query parameter.

ExtendedPropertiesPrivateKey String False

This field contains properties that are private to the copy of the event that appears on the calendar.

ExtendedPropertiesPrivateValue String False

This field contains properties that are private to the copy of the event that appears on the calendar.

ExtendedPropertiesSharedKey String False

This field contains properties that are shared between copies of the event on other attendees' calendars.

ExtendedPropertiesSharedValue String False

This field contains properties that are shared between copies of the event on other attendees' calendars.

AnyoneCanAddSelf Boolean True

This value sets whether anyone can invite themselves to the event.

GuestsCanInviteOthers Boolean False

This value sets whether attendees other than the organizer can invite others to the event.

GuestsCanSeeOtherGuests Boolean False

This value sets whether attendees other than the organizer can see who the event's attendees are.

GuestsCanModify Boolean False

Whether attendees other than the organizer can modify the event.

PrivateCopy Boolean True

This value sets whether this is a private event copy where changes are not shared with other copies on other calendars.

RemindersUseDefault Boolean False

This value sets whether the default reminders of the calendar apply to the event.

ReminderOverrideMethods String False

A comma-separated list of the methods used by the reminder. The possible values are EMAIL, SMS, and POPUP.

ReminderOverrideMinutes String False

A comma-separated list of the minutes before the start of the event when the corresponding ReminderOverrideMethod should trigger.

ConferenceId String False

The ID of the conference. Can be used by developers to keep track of conferences, should not be displayed to users.

ConferenceNotes String False

Additional notes (such as instructions from the domain administrator, legal notices) to display to the user. Can contain HTML. The maximum length is 2048 characters.

ConferenceSignature String False

The signature of the conference data. Generated on server side. Must be preserved while copying the conference data between events, otherwise the conference data will not be copied.

ConferenceSolutionName String False

The user-visible name of this solution. Not localized.

ConferenceSolutionKeyType String False

The conference solution type. If a client encounters an unfamiliar or empty type, it should still be able to display the entry points. However, it should disallow modifications. Valid values are: (1) 'eventHangout' for Hangouts for consumers (http://hangouts.google.com) -- (2) 'eventNamedHangout' for classic Hangouts for G Suite users (http://hangouts.google.com) -- (3) 'hangoutsMeet' for Hangouts Meet (http://meet.google.com) -- (4) 'addOn' for 3P conference providers.

使用できる値は次のとおりです。eventHangout, eventNamedHangout, hangoutsMeet, addOn

ConferenceSolutionIconUri String False

The user-visible icon for this solution.

ConferenceRequestId String False

The client-generated unique ID for this request. Clients should regenerate this ID for every new request. If an ID provided is the same as for the previous request, the request is ignored.

ConferenceRequestKey String False

The conference solution, such as Hangouts or Hangouts Meet.

ConferenceRequestKeyType String False

The conference solution type. If a client encounters an unfamiliar or empty type, it should still be able to display the entry points. However, it should disallow modifications. Valid values are: (1) 'eventHangout' for Hangouts for consumers (http://hangouts.google.com) -- (2) 'eventNamedHangout' for classic Hangouts for G Suite users (http://hangouts.google.com) -- (3) 'hangoutsMeet' for Hangouts Meet (http://meet.google.com) -- (4) 'addOn' for 3P conference providers.

ConferenceRequestStatus String False

The status of the conference create request.

ConferenceRequestStatusCode String True

The current status of the conference create request. The possible values are: (1)

ConferenceEntryPointsAggregate String False

Information about individual conference entry points, such as URLs or phone numbers. All of them must belong to the same conference.

GadgetTitle String False

The gadget's title.

GadgetType String False

The type of the gadget that extends this event.

GadgetDisplay String False

The gadget's display mode. Optional. Possible values are: 'icon' - The gadget displays next to the event's title in the calendar view. 'chip' - The gadget displays when the event is clicked.

GadgetHeight Int False

The gadget's height in pixels. The height must be an integer greater than 0.

GadgetWidth Int False

The gadget's width in pixels. The width must be an integer greater than 0.

GadgetIconLink String False

The gadget's icon URL. The URL scheme must be HTTPS.

GadgetLink String False

The gadget's URL.

EventType String False

Specific type of the event. Read-only. Possible values are: 'default' - A regular event or not further specified. 'outOfOffice' - An out-of-office event. 'focusTime' - A focus-time event.

Pseudo-Columns

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

Name Type Description
SearchTerms String

Free text search terms to find events that match these terms in any field, except for extended properties.

ShowDeleted String

Whether to list cancelled events.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839