EndPoint Create event

Name

create_event

Creates event

Parameter	Label	Required	Options	Description
CalendarId	CalendarId	YES

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.

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.

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

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