Excel Add-In for Google Calendar

Build 21.0.7930

AccessControlRules

Create, update, delete, and query access control rules to calendars' resources.

Table-Specific Information

Select

To query access control rules of all calendars you can execute a query as below.

Select * FROM [AccessControlRules]

The CalendarId, and Id and CalendarId (both specified at the same time) columns support server side filtering only for the = operator.

To query the access control rules of a certain calendar you will need to specify the CalendarId as a WHERE clause criterion.

SELECT * FROM [AccessControlRules] WHERE CalendarId='admin@cdatatest.page'

To query a specific access control rule of a certain calendar you will need to specify the CalendarId and Id as WHERE clause criteria.

SELECT * FROM [AccessControlRules] WHERE CalendarId='admin@cdatatest.page' AND Id ='domain:cdatatest.page'

Insert

To add a new access control rule to a specific calendar, for example to share the calendar with a user, group or domain, or to make the calendar publicly available (ScopeType='default'), you will need to at least specify the CalendarId, Role, ScopeType and optionally the ScopeValue (required if you haven't specified the default ScopeType).

For example, to share a calendar with a specific user you can execute a query as below.

INSERT INTO [AccessControlRules] (CalendarId, Role, ScopeType, ScopeValue) VALUES('c_2p6odtktblah1o7i18orhqg4n4@group.calendar.google.com', 'writer', 'user', 'user2@cdatatest.page')

For example, to share a calendar with a specific domain you can execute a query as below.

INSERT INTO [AccessControlRules] (calendarId, Role, ScopeType, ScopeValue, SendNotification) VALUES('c_t5ple0d6g15739elcd7vg3ddto@group.calendar.google.com', 'writer', 'domain', 'cdatatest.page', 'true')

Note: Sharing a calendar with a user no longer automatically inserts the calendar into their CalendarList. If the user should be able to perform CRUD operations on the shared calendar, they will need to execute an INSERT statement by specifying at least the existing CalendarId in the statement. For more information, refer to the Calendars table section.

Update

To update an access control rule of a specific calendar, you will need to specify the CalendarId along with the Id in the WHERE clause criteria.

UPDATE [AccessControlRules] SET Role='writer', ScopeType='user' WHERE Id='user:user1@cdatatest.page' AND CalendarId='admin@cdatatest.page'

Delete

To delete an access control rule from a specific calendar, you will need to specify the CalendarId along with the Id in the where clause criteria.

Delete FROM [AccessControlRules] WHERE Id='user:user1@cdatatest.page' AND CalendarId='admin@cdatatest.page'

Columns

Name Type ReadOnly Description
CalendarId [KEY] String False

The calendar identifier.

Id [KEY] String True

The identifier of the ACL rule.

Etag String True

The ETag of the resource.

Kind String True

The type of the resource.

Role String False

The role assigned to the scope. Possible values are: none, freeBusyReader, reader, writer and owner.

ScopeType String False

The type of the scope. Possible values are: default, user, group and domain.

ScopeValue String False

The email address of a user or group, or the name of a domain, depending on the scope type. Not applicable for type 'default'.

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
SendNotification String

This value sets whether or not to send notifications about the calendar sharing change.

The default value is True.

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