Reference

Endpoint List events for all calendars

Name

list_events_all_calendars

Description

Lists events of all calendars

Related Tables

EventsAll

Parameters

Parameter Required Options
Name: UserId

Label: User ID (e.g. 'me' or other-user-email)

The UserId parameter can be 'me' (the authenticated user) or a specific user's email (e.g., 'someuser@example.com'). For OAuth, 'me' is the signed-in user; other users require domain-wide delegation. For Service Accounts, use 'me' for the service account itself, or specify an email if impersonation is enabled. 		YES
Name: StartTime

Label: Start Time

Lower bound for event start time (RFC3339 timestamp, e.g. 2026-01-26T00:00:00Z --OR-- 2026-01-27T05:00:00-05:00)
Option Value
As Local Time (with Timezone Offset) 2026-01-27T05:00:00-05:00
As UTC Time 2026-01-27T05:00:00Z
As Dynamic Local Time (with Timezone Offset) <>-05:00
As Dynamic UTC Time <>
Name: EndTime

Label: End Time

Upper bound for event end time (RFC3339 timestamp, e.g. 2026-01-27T00:00:00Z --OR-- 2026-01-27T05:00:00-05:00)
Option Value
As Local Time (with Timezone Offset) 2026-01-27T05:00:00-05:00
As UTC Time 2026-01-27T05:00:00Z
As Dynamic Local Time (with Timezone Offset) <>-05:00
As Dynamic UTC Time <>
Name: ShowDeleted

Label: Show Deleted

Whether to include deleted events (true/false)
Option Value
true true
false false
Name: SingleEvents

Label: Single Events

Expand recurring events into instances (true/false)
Option Value
true true
false false
Name: MaxResults

Label: Max Results

Maximum number of events per page
Name: OrderBy

Label: Order By

Order of the events returned (startTime or updated)
Option Value
startTime startTime
updated updated

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(300) 300
Kind DT_WSTR nvarchar(300) 300
Status DT_WSTR nvarchar(300) 300
HtmlLink DT_WSTR nvarchar(1000) 1000
CreatedAt DT_DBTIMESTAMP datetime
UpdatedAt DT_DBTIMESTAMP datetime
Summary DT_WSTR nvarchar(300) 300
Description DT_NTEXT nvarchar(MAX)
CreatorEmail DT_WSTR nvarchar(300) 300
OrganizerEmail DT_WSTR nvarchar(300) 300
OrganizerDisplayName DT_WSTR nvarchar(300) 300
StartsAt DT_DBTIMESTAMP datetime
StartsOn DT_DBDATE date
StartTimeZone DT_WSTR nvarchar(300) 300
EndsAt DT_DBTIMESTAMP datetime
EndsOn DT_DBDATE date
EndTimeZone DT_WSTR nvarchar(300) 300
Attendees DT_NTEXT nvarchar(MAX)
Location DT_WSTR nvarchar(1024) 1024
Recurrence DT_WSTR nvarchar(1000) 1000
ICalUID DT_WSTR nvarchar(300) 300
EventType DT_WSTR nvarchar(128) 128
ColorId DT_WSTR nvarchar(50) 50
Visibility DT_WSTR nvarchar(50) 50
Transparency DT_WSTR nvarchar(50) 50
Sequence DT_I4 int
Attachments DT_NTEXT nvarchar(MAX)
ConferenceDataConferenceId DT_WSTR nvarchar(500) 500
ConferenceDataEntryPoints DT_WSTR nvarchar(1000) 1000
ConferenceDataConferenceSolutionKeyType DT_WSTR nvarchar(500) 500
ConferenceDataConferenceSolutionIconUri DT_WSTR nvarchar(500) 500
ConferenceDataConferenceSolutionName DT_WSTR nvarchar(500) 500
GuestsCanInviteOthers DT_BOOL bit
RemindersUseDefault DT_BOOL bit
RemindersOverrides DT_WSTR nvarchar(1000) 1000
ETag DT_WSTR nvarchar(200) 200
HangoutLink DT_WSTR nvarchar(1000) 1000
RecurringEventId DT_WSTR nvarchar(300) 300
OriginalStartDateTime DT_DBTIMESTAMP datetime
OriginalStartDate DT_DBDATE date
SourceUrl DT_WSTR nvarchar(1024) 1024
SourceTitle DT_WSTR nvarchar(300) 300
CalendarId DT_WSTR nvarchar(300) 300
If the column you are looking for is missing, consider customizing Google Calendar Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google Calendar Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the EventsAll table, therefore it is better to use it, instead of accessing the endpoint directly:

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

API Destination

This Endpoint belongs to the EventsAll table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to list events for all calendars:

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

list_events_all_calendars endpoint belongs to EventsAll table(s), and can therefore be used via those table(s).

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];

list_events_all_calendars endpoint belongs to EventsAll table(s), and can therefore be used via those table(s).