Overview
Configuration is provided for establishing connections with the Google Calendar service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Demonstration
Configuration
Base URL address: https://www.googleapis.com/calendar/v3.
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}.The authentication has the following user-defined parameters:
- Scope:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
Documentation: https://developers.google.com/google-apps/calendar/auth.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/calendars/{{=parameters.get('calendarId', 'primary')}}/acl.The action has the following user-defined parameters:
- calendarId: Specifies calendar identifier. Set to 'primary' for active user calendar.
Documentation: https://developers.google.com/google-apps/calendar/v3/reference/acl/list.
- [Create] action
-
Endpoint URL address:
/calendars/{{=item.calendarId}}/acl.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/acl/insert.
- [Update] action
-
Endpoint URL address:
/calendars/{{=item.calendarId}}/acl/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/acl/update.
- [Delete] action
-
Endpoint URL address:
/calendars/{{=item.calendarId}}/acl/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/acl/delete.
- id
A key field. Template: ShortText.
- role
Template: ShortText.
- scope
Field components:
-
Uses template:
ShortText. - Contains the following components: type, value.
-
Uses template:
- calendarId
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/me/calendarList.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendarList/list.
- [Create] action
-
Endpoint URL address:
/users/me/calendarList.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendarList/insert.
- [Update] action
-
Endpoint URL address:
/users/me/calendarList/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendarList/update.
- [Delete] action
-
Endpoint URL address:
/users/me/calendarList/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendarList/delete.
- id
A key field. Template: ShortText.
- accessRole
Template: ShortText. A read-only field.
- backgroundColor
Template: ShortText.
- colorId
Template: ShortText.
- defaultReminders
Field components:
- An array.
- Contains the following components: method, minutes.
- deleted
Data type: DT_BOOL A read-only field.
- description
Template: LongText. A read-only field.
- foregroundColor
Template: ShortText.
- hidden
Data type: DT_BOOL
- location
Template: ShortText. A read-only field.
- notificationSettings
Field components:
- An array.
- Contains the following components: method, type.
- primary
Data type: DT_BOOL A read-only field.
- selected
Data type: DT_BOOL
- summary
Template: ShortText. A read-only field.
- summaryOverride
Template: ShortText.
- timeZone
Template: ShortText. A read-only field.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/calendars.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendars/insert.
- [Update] action
-
Endpoint URL address:
/calendars/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendars/update.
- [Delete] action
-
Endpoint URL address:
/calendars/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/calendars/delete.
- id
A key field. Template: ShortText.
- description
Template: LongText.
- location
Template: ShortText.
- summary
Template: ShortText.
- timeZone
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/calendars/{{=parameters.get('calendarId', 'primary')}}/events.The action has the following user-defined parameters:
- calendarId: Specifies calendar identifier. Set to 'primary' for active user calendar.
Documentation: https://developers.google.com/google-apps/calendar/v3/reference/events/list.
- [Create] action
-
Endpoint URL address:
/calendars/{{=item.calendarId}}/events.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/events/insert.
- [Update] action
-
Endpoint URL address:
/calendars/{{=item.calendarId}}/events/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/events/update.
- [Delete] action
-
Endpoint URL address:
/calendars/{{=item.calendarId}}/events/{{=item.id}}.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/events/delete.
- id
A key field. Template: ShortText.
- anyoneCanAddSelf
Data type: DT_BOOL
- attachments
Field components:
- An array.
- Contains the following components: fileId, fileUrl, iconLink, mimeType, title.
- attendeesOmitted
Data type: DT_BOOL
- attendees
Field components:
- An array.
- Contains the following components: additionalGuests, comment, displayName, email, id, optional, organizer, resource, responseStatus, self.
- colorId
Template: ShortText.
- created
Template: DateTime. A read-only field.
- creator
Template: User. A read-only field.
- description
Template: LongText.
- end
Template: DateTimeCombo.
- endTimeUnspecified
Data type: DT_BOOL
- extendedProperties
Field components:
-
Uses template:
LongText. - Contains the following components: private, shared.
-
Uses template:
- gadget
Field components:
-
Uses template:
ShortText. - Contains the following components: display, height, iconLink, link, preferences, title, type, width.
-
Uses template:
- guestsCanInviteOthers
Data type: DT_BOOL
- guestsCanSeeOtherGuests
Data type: DT_BOOL
- hangoutLink
Template: LongText. A read-only field.
- htmlLink
Template: LongText. A read-only field.
- iCalUID
Template: ShortText.
- location
Template: ShortText.
- locked
Data type: DT_BOOL A read-only field.
- organizer
Template: User.
- originalStartTime
Template: DateTimeCombo.
- privateCopy
Data type: DT_BOOL
- recurrence
Template: LongText. A composite field.
- recurringEventId
Template: ShortText.
- reminders
Field components:
- Contains the following components: overrides, useDefault.
- sequence
Data type: DT_I4
- source
Field components:
-
Uses template:
ShortText. - Contains the following components: title, url.
-
Uses template:
- start
Template: DateTimeCombo.
- status
Template: ShortText.
- summary
Template: ShortText.
- transparency
Template: ShortText.
- updated
Template: DateTime. A read-only field.
- visibility
Template: ShortText.
- calendarId
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/me/settings.Documentation: https://developers.google.com/google-apps/calendar/v3/reference/settings/list.
- id
A key field. Template: ShortText.
- value
Template: LongText.
- [Read] action
-
The result is extracted from:{{=response.items}}.
The result is paginated.The following request parameters will be automatically processed:
-
pageToken:
{{=parameters.iterator}} -
maxResults:
{{=parameters.batchSize}} -
fields:
nextPageToken, items({{=_.filter(_.without(parameters.fields, 'calendarId'), function(item) { return item.indexOf('.') == -1; }).join()}}) -
_includeUserParameters:
{{=parameters}}
-
pageToken:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Delete] action
-
The action uses DELETE method.
- kind
Template: ShortText. A read-only field.
- etag
Template: ShortText. A read-only field.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- User
Field components:
-
Uses template:
ShortText. - Contains the following components: displayName, email, id, self.
-
Uses template:
- DateTimeCombo
Field components:
-
Uses template:
ShortText. - Contains the following components: date, dateTime, timeZone.
-
Uses template:
What's New
- New: Introduced connection.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.