Google Calendar Connector
The high-performance Google Calendar Connector provides read/write capabilities within your application, allowing you to perform numerous Google Calendar operations with minimal coding or even no-coding at all. Integrate Google Calendar data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.
Download for SSIS Download for SQL Server and ODBC Documentation
Integrate Google Calendar with these applications
All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications
Actions supported by Google Calendar Connector
Google Calendar Connector support following actions for REST API integration. If some actions are not listed below then you can easily edit Connector file and enhance out of the box functionality.
List calendars
Lists calendars [
Read more...
]
List events
Lists events [
Read more...
]
Parameter | Description |
---|---|
CalendarId |
|
Get event
Gets event [
Read more...
]
Parameter | Description |
---|---|
CalendarId |
|
EventId |
|
Create event
Creates event [
Read more...
]
Parameter | Description |
---|---|
CalendarId |
|
Delete event
Deletes event [
Read more...
]
Parameter | Description |
---|---|
CalendarId |
|
EventId |
|
Move event to another calendar
Moves event from one calendar to another [
Read more...
]
Parameter | Description |
---|---|
SourceCalendarId |
|
TargetCalendarId |
|
EventId |
|
Generic Request
This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL. [
Read more...
]
Parameter | Description | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Url |
|
||||||||||||||||||||||||||
Body |
|
||||||||||||||||||||||||||
IsMultiPart |
|
||||||||||||||||||||||||||
Filter |
|
||||||||||||||||||||||||||
Headers |
|
Generic Request (Bulk Write)
This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL. [
Read more...
]
Parameter | Description |
---|---|
Url |
|
IsMultiPart |
|
Filter |
|
Headers |
|
SQL examples for Google Calendar Connector
Use these example Google Calendar SQL queries within SQL Server or any other ODBC-compatible application:
List calendars [ Read more... ]
Lists calendars
SELECT * FROM Calendars
List events [ Read more... ]
Lists events
SELECT * FROM Events
WITH (CalendarId='MyCalendarId')
Get event [ Read more... ]
Gets event
SELECT * FROM get_event
WITH (CalendarId='MyCalendarId'
,EventId='MyEventId')
Create event [ Read more... ]
Creates event
INSERT INTO Events(StartsAt, StartsInTimeZone, EndsAt, EndsInTimeZone, Summary,
Attendees, Description, Location, Status, Transparency, Visibility)
VALUES ('2021-11-26T16:30:50', 'Europe/Vilnius', '2021-11-27T16:30:50','Europe/Vilnius', 'This is an event',
null, 'My Description', 'Vilnius', 'confirmed', 'opaque', 'default')
WITH (CalendarId='YourCalendarId')
Get event [ Read more... ]
Gets event
DELETE FROM Events
WITH (CalendarId='MyCalendarId',
EventId='MyEventId')
Move event to a different calendar [ Read more... ]
Moves event to a different calendar
UPDATE move_event
WITH (SourceCalendarId='MySourceCalendarId',
TargetCalendarId='MyTargetCalendarId',
EventId='MyEventId'
)