Endpoint

Delete event

Name

delete_event

Description

Deletes event

Related Tables

Events

Parameters

Parameter	Label	Required	Options	Description
CalendarId	CalendarId	YES
EventId	EventId	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(50)`	50	`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
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 component to read data or in API Destination component to read/write data:

Delete rows from 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

Delete

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete event

SELECT * FROM delete_event
WITH
(
    "CalendarId" = 'abcd-1234-calendarid',
    "EventId" = 'abcd-1234-eventid'
)

Get event

Gets event

DELETE FROM Events
    WITH (CalendarId='MyCalendarId',
    EventId='MyEventId')

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

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_event
WITH
(
    "CalendarId" = ''abcd-1234-calendarid'',
    "EventId" = ''abcd-1234-eventid''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_CALENDAR_IN_GATEWAY];

Get event

Gets event

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Events
    WITH (CalendarId=''MyCalendarId'',
    EventId=''MyEventId'')';

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