Google Calendar Connector
Documentation
Version: 6
Documentation
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).