Endpoint List events

Name

list_events

Description

Lists events

Related Tables

Events

Parameters

Output Columns

Input Columns

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 Events 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

Events

Required Parameters
Calendar ID (e.g. 'primary' or calendar ID)	Fill-in the parameter...

API Destination

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

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

Events

Select

Required Parameters
Calendar ID (e.g. 'primary' or calendar ID)	Fill-in the parameter...

ODBC application

Use these SQL queries in your ODBC application data source:

List events

SELECT * FROM Events
WITH (CalendarId='MyCalendarId')  -- Specify the calendar ID to list events from

--Get single event by Id
--SELECT * FROM Events WHERE Id='MyEventId'  -- Filter by event ID in WHERE clause
--SELECT * FROM Events WITH(EventId='MyEventId')  -- Use EventId parameter for direct lookup

List events with time range

SELECT * 
FROM Events
WITH (CalendarId='primary',
      StartTime='2026-01-01T00:00:00Z',
      EndTime='2026-01-31T23:59:59Z')

--OR-- From all accessible calendars (EventsAll table)

--SELECT * 
--FROM EventsAll
--WITH (StartTime='2026-01-01T00:00:00-05:00',  
--      EndTime='2026-01-31T23:59:59-05:00')

List events ordered by start time

SELECT * 
FROM Events
WITH (CalendarId='primary',
      OrderBy='startTime')

List events including deleted ones

SELECT * 
FROM Events
WITH (CalendarId='primary',
      ShowDeleted='true')

List events with max results and single events

SELECT * FROM Events

WITH (CalendarId='primary',
      MaxResults=10,
      SingleEvents='true')

List events for next week using dynamic dates

SELECT * FROM Events
--FROM EventsAll --(Get from All Calendars)
WITH (CalendarId='primary',
--//e.g. append -05:00 for EST (New York Time Zone) to convert local time to UTC -OR- just appends "Z" for UTC time (2026-01-01T05:00:00Z which is same as 2026-01-01T00:00:00-05:00 ).
      StartTime='<<today,FUN_TO_DATETIME>>-05:00',   
      EndTime='<<today+7d,FUN_TO_DATETIME>>-05:00')

List events ordered by updated time

SELECT * FROM Events
--FROM EventsAll --(Get from All Calendars)
WITH (CalendarId='primary',
      OrderBy='updated')

List events for today and tomorrow with dynamic placeholders

SELECT * 
FROM Events
--FROM EventsAll --(Get from All Calendars)
WITH (CalendarId='primary',
      StartTime='<<today,FUN_TO_DATETIME>>-05:00',   
      EndTime='<<today+1d,FUN_TO_DATETIME>>-05:00')

SQL Server

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

List events

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Events
WITH (CalendarId=''MyCalendarId'')  -- Specify the calendar ID to list events from

--Get single event by Id
--SELECT * FROM Events WHERE Id=''MyEventId''  -- Filter by event ID in WHERE clause
--SELECT * FROM Events WITH(EventId=''MyEventId'')  -- Use EventId parameter for direct lookup';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

List events with time range

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * 
FROM Events
WITH (CalendarId=''primary'',
      StartTime=''2026-01-01T00:00:00Z'',
      EndTime=''2026-01-31T23:59:59Z'')

--OR-- From all accessible calendars (EventsAll table)

--SELECT * 
--FROM EventsAll
--WITH (StartTime=''2026-01-01T00:00:00-05:00'',  
--      EndTime=''2026-01-31T23:59:59-05:00'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

List events ordered by start time

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * 
FROM Events
WITH (CalendarId=''primary'',
      OrderBy=''startTime'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

List events including deleted ones

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * 
FROM Events
WITH (CalendarId=''primary'',
      ShowDeleted=''true'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

List events with max results and single events

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Events

WITH (CalendarId=''primary'',
      MaxResults=10,
      SingleEvents=''true'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

List events for next week using dynamic dates

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Events
--FROM EventsAll --(Get from All Calendars)
WITH (CalendarId=''primary'',
--//e.g. append -05:00 for EST (New York Time Zone) to convert local time to UTC -OR- just appends "Z" for UTC time (2026-01-01T05:00:00Z which is same as 2026-01-01T00:00:00-05:00 ).
      StartTime=''<<today,FUN_TO_DATETIME>>-05:00'',   
      EndTime=''<<today+7d,FUN_TO_DATETIME>>-05:00'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

List events ordered by updated time

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Events
--FROM EventsAll --(Get from All Calendars)
WITH (CalendarId=''primary'',
      OrderBy=''updated'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

List events for today and tomorrow with dynamic placeholders

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * 
FROM Events
--FROM EventsAll --(Get from All Calendars)
WITH (CalendarId=''primary'',
      StartTime=''<<today,FUN_TO_DATETIME>>-05:00'',   
      EndTime=''<<today+1d,FUN_TO_DATETIME>>-05:00'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];