Google Calendar Connector
Documentation
Version: 6
Documentation

EndPoint Create event


Name

create_event

Description

Creates event

Parameters

Parameter Label Required Options Description
CalendarId CalendarId YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(50) 50 False
Status DT_WSTR nvarchar(50) 50 False
Created DT_DBTIMESTAMP datetime False
Updated DT_DBTIMESTAMP datetime False
HtmlLink DT_WSTR nvarchar(4000) 4000 False
iCalUID DT_WSTR nvarchar(1024) 1024 False
eventType DT_WSTR nvarchar(128) 128 False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
StartsOn DT_DBDATE date False Use StartsOn OR StartsAt
StartsAt DT_DBTIMESTAMP datetime False Use StartsOn OR StartsAt
StartsInTimeZone DT_WSTR nvarchar(300) 300 False
EndsOn DT_DBDATE date False
EndsAt DT_DBTIMESTAMP datetime False
EndsInTimeZone DT_WSTR nvarchar(300) 300 False
Kind DT_WSTR nvarchar(300) 300 False
Attendees DT_NTEXT nvarchar(MAX) False
Description DT_WSTR nvarchar(4000) 4000 False
GuestsCanInviteOthers DT_WSTR nvarchar(4000) 4000 False
GuestsCanModify DT_WSTR nvarchar(4000) 4000 False
GuestsCanSeeOtherGuests DT_WSTR nvarchar(4000) 4000 False
Location DT_WSTR nvarchar(1024) 1024 False
Recurrence DT_WSTR nvarchar(1024) 1024 False
Status DT_WSTR nvarchar(50) 50 False
Summary DT_WSTR nvarchar(300) 300 False
Transparency DT_WSTR nvarchar(300) 300 False
Visibility DT_WSTR nvarchar(300) 300 False
Required columns that you need to supply are bolded.

Examples

SSIS

Use Google Calendar Connector in API Source component to read data or in API Destination component to read/write data:

Insert into Events table using API Destination

This EndPoint belongs to Events table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Google Calendar
Events
Insert
SSIS API Destination - Access table operation