Reference

Table Events

Description

Insert, update, delete and list datasets

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT list_events
INSERT create_event
UPDATE
UPSERT
DELETE delete_event
LOOKUP

Examples

SSIS

Use Google Calendar Connector in API Source component to read data or in API Destination component to read/write data:

Read from Events table using API Source

API Source - Google Calendar
Read / write Google Calendar data inside your app; perform many Google Calendar operations without coding, just using easy to use high performance API Connector for Google Calendar
Google Calendar
Events
Required Parameters
CalendarId Fill-in the parameter...
Optional Parameters
NextUrlAttributeOrExpr $.nextPageToken
NextUrlSuffix pageToken=<%nextlink%>
SSIS API Source - Read from table or endpoint

Read/write to Events table using API Destination

API Destination - Google Calendar
Read / write Google Calendar data inside your app; perform many Google Calendar operations without coding, just using easy to use high performance API Connector for Google Calendar
Google Calendar
Events
Select
Required Parameters
CalendarId Fill-in the parameter...
Optional Parameters
NextUrlAttributeOrExpr $.nextPageToken
NextUrlSuffix pageToken=<%nextlink%>
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List events

Lists events 

SELECT * FROM Events
  WITH (CalendarId='MyCalendarId')

Create event

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

Gets event 

DELETE FROM Events
    WITH (CalendarId='MyCalendarId',
    EventId='MyEventId')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List events

Lists events 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Events
  WITH (CalendarId=''MyCalendarId'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

Create event

Creates event 

DECLARE @MyQuery NVARCHAR(MAX) = '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'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

Get event

Gets event 

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Events
    WITH (CalendarId=''MyCalendarId'',
    EventId=''MyEventId'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];