Skip to main content

calendars

Creates, updates, deletes, gets or lists a calendars resource.

Overview

Namecalendars
TypeResource
Idgoogleadmin.directory.calendars

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
buildingIdstringUnique ID for the building a resource is located in.
capacityinteger (int32)Capacity of a resource, number of seats in a room.
etagsstringETag of the resource.
featureInstancesanyInstances of features for the calendar resource.
floorNamestringName of the floor a resource is located on.
floorSectionstringName of the section within a floor a resource is located in.
generatedResourceNamestringThe read-only auto-generated name of the calendar resource which includes metadata about the resource such as building name, floor, capacity, etc. For example, "NYC-2-Training Room 1A (16)".
kindstringThe type of the resource. For calendar resources, the value is admin#directory#resources#calendars#CalendarResource. (default: admin#directory#resources#calendars#CalendarResource)
resourceCategorystringThe category of the calendar resource. Either CONFERENCE_ROOM or OTHER. Legacy data is set to CATEGORY_UNKNOWN.
resourceDescriptionstringDescription of the resource, visible only to admins.
resourceEmailstringThe read-only email for the calendar resource. Generated as part of creating a new calendar resource.
resourceIdstringThe unique ID for the calendar resource.
resourceNamestringThe name of the calendar resource. For example, "Training Room 1A".
resourceTypestringThe type of the calendar resource, intended for non-room resources.
userVisibleDescriptionstringDescription of the resource, visible to users and admins.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectcustomer, calendarResourceIdRetrieves a calendar resource.
listselectcustomermaxResults, orderBy, pageToken, queryRetrieves a list of calendar resources for an account.
insertinsertcustomerInserts a calendar resource.
patchupdatecustomer, calendarResourceIdPatches a calendar resource.
updatereplacecustomer, calendarResourceIdUpdates a calendar resource. This method supports patch semantics, meaning you only need to include the fields you wish to update. Fields that are not present in the request will be preserved.
deletedeletecustomer, calendarResourceIdDeletes a calendar resource.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
calendarResourceIdstring
customerstring
maxResultsinteger (int32)
orderBystring
pageTokenstring
querystring

SELECT examples

Retrieves a calendar resource.

SELECT
buildingId,
capacity,
etags,
featureInstances,
floorName,
floorSection,
generatedResourceName,
kind,
resourceCategory,
resourceDescription,
resourceEmail,
resourceId,
resourceName,
resourceType,
userVisibleDescription
FROM googleadmin.directory.calendars
WHERE customer = '{{ customer }}' -- required
AND calendarResourceId = '{{ calendarResourceId }}' -- required;

INSERT examples

Inserts a calendar resource.

INSERT INTO googleadmin.directory.calendars (
data__kind,
data__etags,
data__resourceName,
data__resourceDescription,
data__resourceType,
data__resourceEmail,
data__resourceCategory,
data__userVisibleDescription,
data__generatedResourceName,
data__featureInstances,
data__resourceId,
data__capacity,
data__floorName,
data__buildingId,
data__floorSection,
customer
)
SELECT
'{{ kind }}',
'{{ etags }}',
'{{ resourceName }}',
'{{ resourceDescription }}',
'{{ resourceType }}',
'{{ resourceEmail }}',
'{{ resourceCategory }}',
'{{ userVisibleDescription }}',
'{{ generatedResourceName }}',
'{{ featureInstances }}',
'{{ resourceId }}',
{{ capacity }},
'{{ floorName }}',
'{{ buildingId }}',
'{{ floorSection }}',
'{{ customer }}'
RETURNING
buildingId,
capacity,
etags,
featureInstances,
floorName,
floorSection,
generatedResourceName,
kind,
resourceCategory,
resourceDescription,
resourceEmail,
resourceId,
resourceName,
resourceType,
userVisibleDescription
;

UPDATE examples

Patches a calendar resource.

UPDATE googleadmin.directory.calendars
SET
data__kind = '{{ kind }}',
data__etags = '{{ etags }}',
data__resourceName = '{{ resourceName }}',
data__resourceDescription = '{{ resourceDescription }}',
data__resourceType = '{{ resourceType }}',
data__resourceEmail = '{{ resourceEmail }}',
data__resourceCategory = '{{ resourceCategory }}',
data__userVisibleDescription = '{{ userVisibleDescription }}',
data__generatedResourceName = '{{ generatedResourceName }}',
data__featureInstances = '{{ featureInstances }}',
data__resourceId = '{{ resourceId }}',
data__capacity = {{ capacity }},
data__floorName = '{{ floorName }}',
data__buildingId = '{{ buildingId }}',
data__floorSection = '{{ floorSection }}'
WHERE
customer = '{{ customer }}' --required
AND calendarResourceId = '{{ calendarResourceId }}' --required
RETURNING
buildingId,
capacity,
etags,
featureInstances,
floorName,
floorSection,
generatedResourceName,
kind,
resourceCategory,
resourceDescription,
resourceEmail,
resourceId,
resourceName,
resourceType,
userVisibleDescription;

REPLACE examples

Updates a calendar resource. This method supports patch semantics, meaning you only need to include the fields you wish to update. Fields that are not present in the request will be preserved.

REPLACE googleadmin.directory.calendars
SET
data__kind = '{{ kind }}',
data__etags = '{{ etags }}',
data__resourceName = '{{ resourceName }}',
data__resourceDescription = '{{ resourceDescription }}',
data__resourceType = '{{ resourceType }}',
data__resourceEmail = '{{ resourceEmail }}',
data__resourceCategory = '{{ resourceCategory }}',
data__userVisibleDescription = '{{ userVisibleDescription }}',
data__generatedResourceName = '{{ generatedResourceName }}',
data__featureInstances = '{{ featureInstances }}',
data__resourceId = '{{ resourceId }}',
data__capacity = {{ capacity }},
data__floorName = '{{ floorName }}',
data__buildingId = '{{ buildingId }}',
data__floorSection = '{{ floorSection }}'
WHERE
customer = '{{ customer }}' --required
AND calendarResourceId = '{{ calendarResourceId }}' --required
RETURNING
buildingId,
capacity,
etags,
featureInstances,
floorName,
floorSection,
generatedResourceName,
kind,
resourceCategory,
resourceDescription,
resourceEmail,
resourceId,
resourceName,
resourceType,
userVisibleDescription;

DELETE examples

Deletes a calendar resource.

DELETE FROM googleadmin.directory.calendars
WHERE customer = '{{ customer }}' --required
AND calendarResourceId = '{{ calendarResourceId }}' --required;