Endpoint

Create event

Name

create_event

Description

Creates event

Related Tables

Events

Parameters

Parameter	Label	Required	Options	Description
CalendarId	CalendarId	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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`

If the column you are looking for is missing, consider customizing Google Calendar Connector.

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

ODBC application

Use these SQL queries in your ODBC application data source:

Create event

Creates 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='YourCalendarId')

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

Creates 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=''YourCalendarId'')';

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).