Reference

Endpoint List events

Name

list_events

Description

Lists events

Related Tables

Events

Parameters

Parameter Required Options
Name: CalendarId

Label: CalendarId

 YES

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_WSTR nvarchar(4000) 4000
CreatorEmail DT_WSTR nvarchar(300) 300
OrganizerEmail DT_WSTR nvarchar(300) 300
OrganizerDisplayName DT_WSTR nvarchar(300) 300
StartsAt DT_DBTIMESTAMP datetime
StartTimeZone DT_WSTR nvarchar(300) 300
EndsAt DT_DBTIMESTAMP datetime
EndTimeZone DT_WSTR nvarchar(300) 300
Attendees DT_NTEXT nvarchar(MAX)
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 Events table, therefore it is better to use it, instead of accessing the endpoint directly:

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

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 / 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')

list_events endpoint belongs to Events 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

Lists events 

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

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