Reference

Endpoint Update event

Name

update_event

Description

Updates 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
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 update 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
Update
Required Parameters
Calendar ID (e.g. 'primary' or calendar ID) Fill-in the parameter...
Event 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:

Update event 

UPDATE Events
SET	 Summary = 'Project Kickoff Meeting'            -- Event title
    ,Description = 'Your meeting description in <strong>bold HTML</strong>'
    
    --For all day event - Example '2026-01-28'
    --,StartsOn = '2026-02-01'                        -- All-day event start date (YYYY-MM-DD)    
    --,EndsOn = '2026-02-01'                          -- All-day event end date (YYYY-MM-DD)
    
    --,StartsOn = '<<monthend+1d,FUN_TO_DATE>>'      -- Dynamic date example
    --,EndsOn   = '<<monthend+1d,FUN_TO_DATE>>'
    
    --OR--

    --For events which has start/end time : Example '2026-01-28T15:59:00'
    ,StartsAt = '<<today+1d+10h,FUN_TO_DATETIME>>' -- Set time from today + 1 day + 10 hours (10AM)
    ,EndsAt = '<<today+1d+11h,FUN_TO_DATETIME>>'   -- Set time from today + 1 day + 11 hours (11AM)
    ,StartsInTimeZone = 'America/New_York'
    ,EndsInTimeZone = 'America/New_York'
        
    ,Location = 'Conference Room 2B'                -- Event location
    ,Attendees = '[{"email":"user1@example.com"},{"email":"user2@example.com"}]' -- JSON array of attendees
	,RemindersUseDefault = false                    -- Use custom reminders
	,RemindersOverrides = '[{"method": "popup","minutes": 12},{"method": "popup","minutes": 11}]'  -- JSON array of reminder overrides
    ,Recurrence = '["RRULE:FREQ=WEEKLY;WKST=SU;UNTIL=20260131T045959Z;BYDAY=MO,WE"]'      -- Recurrence rule
    ,Status = 'confirmed'                           -- confirmed | tentative | cancelled
    ,Transparency = 'opaque'                        -- opaque | transparent
    ,Visibility = 'default'                         -- default | public | private | confidential
    ,ColorId = '5'                                  -- Color identifier
    ,GuestsCanInviteOthers = true                   -- Allow guests to invite others
    ,GuestsCanModify = false                        -- Allow guests to modify event
    ,GuestsCanSeeOtherGuests = true                 -- Allow guests to see other guests
    ,AnyoneCanAddSelf = false                       -- Anyone can add themselves as attendee
    ,PrivateCopy = false                            -- Private event copy
    ,ShowMeAs = 'busy'                              -- busy | free | tentative | workingElsewhere
    ,SourceTitle = 'Project Plan'                   -- Source title
    ,SourceUrl = 'https://example.com/project-plan' -- Source URL
WHERE Id = '5hr02mkhg09atao1clih4jco6e'  -- Event ID to update
WITH (
   CalendarId = 'primary' --or 'some-calendar-id'
 , SendUpdates='none' --'all' or 'externalOnly' to notify attendees
)

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

Update event 

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Events
SET	 Summary = ''Project Kickoff Meeting''            -- Event title
    ,Description = ''Your meeting description in <strong>bold HTML</strong>''
    
    --For all day event - Example ''2026-01-28''
    --,StartsOn = ''2026-02-01''                        -- All-day event start date (YYYY-MM-DD)    
    --,EndsOn = ''2026-02-01''                          -- All-day event end date (YYYY-MM-DD)
    
    --,StartsOn = ''<<monthend+1d,FUN_TO_DATE>>''      -- Dynamic date example
    --,EndsOn   = ''<<monthend+1d,FUN_TO_DATE>>''
    
    --OR--

    --For events which has start/end time : Example ''2026-01-28T15:59:00''
    ,StartsAt = ''<<today+1d+10h,FUN_TO_DATETIME>>'' -- Set time from today + 1 day + 10 hours (10AM)
    ,EndsAt = ''<<today+1d+11h,FUN_TO_DATETIME>>''   -- Set time from today + 1 day + 11 hours (11AM)
    ,StartsInTimeZone = ''America/New_York''
    ,EndsInTimeZone = ''America/New_York''
        
    ,Location = ''Conference Room 2B''                -- Event location
    ,Attendees = ''[{"email":"user1@example.com"},{"email":"user2@example.com"}]'' -- JSON array of attendees
	,RemindersUseDefault = false                    -- Use custom reminders
	,RemindersOverrides = ''[{"method": "popup","minutes": 12},{"method": "popup","minutes": 11}]''  -- JSON array of reminder overrides
    ,Recurrence = ''["RRULE:FREQ=WEEKLY;WKST=SU;UNTIL=20260131T045959Z;BYDAY=MO,WE"]''      -- Recurrence rule
    ,Status = ''confirmed''                           -- confirmed | tentative | cancelled
    ,Transparency = ''opaque''                        -- opaque | transparent
    ,Visibility = ''default''                         -- default | public | private | confidential
    ,ColorId = ''5''                                  -- Color identifier
    ,GuestsCanInviteOthers = true                   -- Allow guests to invite others
    ,GuestsCanModify = false                        -- Allow guests to modify event
    ,GuestsCanSeeOtherGuests = true                 -- Allow guests to see other guests
    ,AnyoneCanAddSelf = false                       -- Anyone can add themselves as attendee
    ,PrivateCopy = false                            -- Private event copy
    ,ShowMeAs = ''busy''                              -- busy | free | tentative | workingElsewhere
    ,SourceTitle = ''Project Plan''                   -- Source title
    ,SourceUrl = ''https://example.com/project-plan'' -- Source URL
WHERE Id = ''5hr02mkhg09atao1clih4jco6e''  -- Event ID to update
WITH (
   CalendarId = ''primary'' --or ''some-calendar-id''
 , SendUpdates=''none'' --''all'' or ''externalOnly'' to notify attendees
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

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