Reference

Table EventsAll

Description

List events from all calendars

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_all_calendars
INSERT
UPDATE
UPSERT
DELETE
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 EventsAll table using API Source

API Source - Google Calendar

Read and write Google Calendar data effortlessly. Integrate, manage, and automate events, calendars, and availability — almost no coding required.

Google Calendar

EventsAll

Required Parameters
User ID (e.g. 'me' or other-user-email)	Fill-in the parameter...

SSIS API Source - Read from table or endpoint

Read/write to EventsAll table using API Destination

API Destination - Google Calendar

Read and write Google Calendar data effortlessly. Integrate, manage, and automate events, calendars, and availability — almost no coding required.

Google Calendar

EventsAll

Select

Required Parameters
User ID (e.g. 'me' or other-user-email)	Fill-in the parameter...

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List events from all calendars

SELECT * FROM EventsAll  -- Lists events from all accessible calendars
--WITH (CalendarId='primary',
--      StartTime='<<today,FUN_TO_DATETIME>>-05:00',   
--      EndTime='<<today+7d,FUN_TO_DATETIME>>-05:00')

--OR--
--SELECT * FROM EventsAll WITH(UserId='me') -- for OAuth authenticated user
--SELECT * FROM EventsAll WITH(UserId='someuser@email.com') -- for specific user (requires domain-wide delegation for service accounts)
--SELECT * FROM EventsAll WITH(ContinueOn404Error='False') -- Fail on 404 errors when accessing calendars

SQL Server

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

List events from all calendars

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM EventsAll  -- Lists events from all accessible calendars
--WITH (CalendarId=''primary'',
--      StartTime=''<<today,FUN_TO_DATETIME>>-05:00'',   
--      EndTime=''<<today+7d,FUN_TO_DATETIME>>-05:00'')

--OR--
--SELECT * FROM EventsAll WITH(UserId=''me'') -- for OAuth authenticated user
--SELECT * FROM EventsAll WITH(UserId=''someuser@email.com'') -- for specific user (requires domain-wide delegation for service accounts)
--SELECT * FROM EventsAll WITH(ContinueOn404Error=''False'') -- Fail on 404 errors when accessing calendars';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];