Reference

Endpoint Get event

Name

get_event

Description

Gets event

Related Tables

Events

Parameters

Parameter Required Options
Name: CalendarId

Label: Calendar ID (e.g. 'primary' or calendar ID)

 YES
Name: EventId

Label: Event ID

 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_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
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 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...
Event ID Fill-in the parameter...
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 get event:

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
Lookup
Required Parameters
Calendar ID (e.g. 'primary' or calendar ID) Fill-in the parameter...
Event ID Fill-in the parameter...
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get event 

SELECT * FROM get_event  -- Direct endpoint for getting a single event
WITH (CalendarId='MyCalendarId'  -- ID of the calendar containing the event
     ,EventId='MyEventId')        -- Unique ID of the event to retrieve
	 
--OR-- Use TableName + WHERE clause
--SELECT * FROM Events WHERE Id='MyEventId'  -- Filter by event ID in WHERE clause

get_event 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:

Get event 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_event  -- Direct endpoint for getting a single event
WITH (CalendarId=''MyCalendarId''  -- ID of the calendar containing the event
     ,EventId=''MyEventId'')        -- Unique ID of the event to retrieve
	 
--OR-- Use TableName + WHERE clause
--SELECT * FROM Events WHERE Id=''MyEventId''  -- Filter by event ID in WHERE clause';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

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