Reference

Endpoint Create event

Name

create_event

Description

Creates event

Related Tables

Events

Parameters

Parameter Required Options
Name: CalendarId

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

 YES
Name: SendUpdates

Label: Send Event Updates

Whether to send notifications to guests (all, externalOnly, none)
Option Value
all all
externalOnly externalOnly
none none

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
Id DT_WSTR nvarchar(4000) 4000
StartsOn DT_DBDATE date Use StartsOn OR StartsAt
StartsAt DT_DBTIMESTAMP datetime Use StartsOn OR StartsAt
StartsInTimeZone DT_WSTR nvarchar(300) 300
EndsOn DT_DBDATE date
EndsAt DT_DBTIMESTAMP datetime
EndsInTimeZone DT_WSTR nvarchar(300) 300
Summary DT_WSTR nvarchar(300) 300 Event title
Description DT_NTEXT nvarchar(MAX) 4000 Event description
Location DT_WSTR nvarchar(1024) 1024 Event location
ConferenceData DT_NTEXT nvarchar(MAX)
Attendees DT_NTEXT nvarchar(MAX) List of attendees
Attachments DT_NTEXT nvarchar(MAX)
Recurrence DT_WSTR nvarchar(1024) 1024 Recurrence rule (RRULE)
Status DT_WSTR nvarchar(50) 50 Event status
Transparency DT_WSTR nvarchar(300) 300 Show as busy or free
Visibility DT_WSTR nvarchar(300) 300 Event visibility
RemindersUseDefault DT_BOOL bit
RemindersOverrides DT_WSTR nvarchar(1000) 1000
ColorId DT_WSTR nvarchar(50) 50 Color identifier for the event
GuestsCanInviteOthers DT_BOOL bit Allow guests to invite others
GuestsCanModify DT_BOOL bit Allow guests to modify event
GuestsCanSeeOtherGuests DT_BOOL bit Allow guests to see other guests
AnyoneCanAddSelf DT_BOOL bit Whether anyone can add themselves as an attendee
PrivateCopy DT_BOOL bit Whether this is a private event copy
ShowMeAs DT_WSTR nvarchar(50) 50 Show event as busy or free
SourceTitle DT_WSTR nvarchar(300) 300 Source title of the event
SourceUrl DT_WSTR nvarchar(1024) 1024 Source URL of the event
Required columns that you need to supply are bolded.

Examples

SSIS

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

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

ODBC application

Use these SQL queries in your ODBC application data source:

Create event 

INSERT INTO Events(StartsAt, StartsInTimeZone, EndsAt, EndsInTimeZone, Summary,
  Attendees, Description, Location, Status, Transparency, Visibility)
VALUES ('2021-11-26T16:30:50', 'Europe/Vilnius', '2021-11-27T16:30:50','Europe/Vilnius', 'This is an event',
        null, 'My Description', 'Vilnius', 'confirmed', 'opaque', 'default')
--WITH (CalendarId='primary')		   -- Use 'primary' for the main calendar
--WITH (CalendarId='YourCalendarId')  -- Or specify a custom calendar ID

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

Create event 

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Events(StartsAt, StartsInTimeZone, EndsAt, EndsInTimeZone, Summary,
  Attendees, Description, Location, Status, Transparency, Visibility)
VALUES (''2021-11-26T16:30:50'', ''Europe/Vilnius'', ''2021-11-27T16:30:50'',''Europe/Vilnius'', ''This is an event'',
        null, ''My Description'', ''Vilnius'', ''confirmed'', ''opaque'', ''default'')
--WITH (CalendarId=''primary'')		   -- Use ''primary'' for the main calendar
--WITH (CalendarId=''YourCalendarId'')  -- Or specify a custom calendar ID';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

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