Reference

Endpoint Delete event

Name

delete_event

Description

Deletes 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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(50) 50
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
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

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

API Source

API Source - Google Calendar
Read and write Google Calendar data effortlessly. Integrate, manage, and automate events, calendars, and availability — almost no coding required.
Google Calendar
Delete event
Required Parameters
Calendar ID (e.g. 'primary' or calendar ID) Fill-in the parameter...
Event ID Fill-in the parameter...
SSIS API Source - Read from table or endpoint

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

ODBC application

Use these SQL queries in your ODBC application data source:

Delete event

<p>This example deletes an event by ID from the specified calendar. Supply the calendar ID and the event ID.</p> <p><strong>Warning:</strong> This action is irreversible.</p> 

DELETE FROM Events  -- Deletes the specified event
WITH (CalendarId='MyCalendarId',  -- Calendar containing the event
      Id='MyEventId')              -- ID of the event to delete

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

Delete event

<p>This example deletes an event by ID from the specified calendar. Supply the calendar ID and the event ID.</p> <p><strong>Warning:</strong> This action is irreversible.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Events  -- Deletes the specified event
WITH (CalendarId=''MyCalendarId'',  -- Calendar containing the event
      Id=''MyEventId'')              -- ID of the event to delete';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

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