Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.6.0+

Outlook Calendar: Delete an Event

See more Outlook Calendar Examples

Delete one event by its opaque Graph ID. Requires delegated Calendars.ReadWrite. Replace YOUR_EVENT_ID with the ID returned by the create/list example, preserving case; the code encodes it as a single URL path segment. An iCalUId, subject, or calendar ID cannot replace an event ID.

Live deletion: deleting a meeting from its organizer's calendar sends cancellations to attendees. Deleting a recurring-series master removes the series; use an occurrence ID only when you intend to delete that occurrence. To decline an invitation or send a cancellation with a comment, use the corresponding event action instead of treating every workflow as DELETE.

A successful response is 204 No Content, so there is no JSON to parse. A 404 can reflect an absent event, an incorrect ID, or the wrong mailbox/context; the example does not report it as a confirmed deletion. The immutable-ID preference matches the revised create/list examples. Use the ID format consistently when integrating existing records.

Uses Microsoft Graph v1.0 in the global cloud with a delegated access token saved by the calendar OAuth2 example. Both personal Outlook.com accounts and Microsoft 365 work/school accounts with a mailbox can use this flow. The app registration must support the selected account type. A token for SMTP/IMAP/POP or another API is not a Graph token.

/me means the signed-in user and requires delegated authentication. An unattended Microsoft 365 service instead needs application permissions and administrator consent, and addresses an explicit mailbox through /users/{id-or-userPrincipalName}. That client-credentials flow does not apply to personal Outlook.com accounts. These samples target the global cloud; national clouds use different authority and Graph hosts.

HTTP methods can return false for an HTTP error as well as a connection failure. The code distinguishes those cases and checks the expected status before reading JSON. For 401, refresh the access token or authorize again; for 403, check permissions, mailbox access, and tenant policy. For 429, honor Retry-After before a bounded retry. Do not automatically repeat a write after an uncertain outcome. Keep detailed errors and calendar data private.

Microsoft documentation

Chilkat SQL Server Downloads

SQL Server
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @iTmp1 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Assumes Chilkat is unlocked. See Global Unlock Sample.
    SELECT @success = 0
    --  Obtain a delegated Microsoft Graph token using the calendar authorization example.
    --  See Authorize Outlook Calendar with OAuth2 and PKCE.
    DECLARE @token int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @token OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @token, 'Strict', 1
    EXEC sp_OAMethod @token, 'LoadFile', @success OUT, 'qa_data/tokens/outlookCalendar.json'
    IF @success <> 1
      BEGIN

        PRINT 'Could not read the private calendar token cache.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    EXEC sp_OAMethod @token, 'JsonTypeOf', @iTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @token, 'StringOfEquals', @iTmp1 OUT, 'access_token', '', 1
    IF (@iTmp0 <> 1) or (@iTmp1 = 1)
      BEGIN

        PRINT 'Expected a nonempty access_token in the JSON.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT

    EXEC sp_OAMethod @token, 'StringOf', @sTmp0 OUT, 'access_token'
    EXEC sp_OASetProperty @http, 'AuthToken', @sTmp0
    EXEC sp_OASetProperty @http, 'RequireSslCertVerify', 1
    EXEC sp_OASetProperty @http, 'FollowRedirects', 0
    EXEC sp_OASetProperty @http, 'ConnectTimeout', 20
    EXEC sp_OASetProperty @http, 'ReadTimeout', 30
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/json'
    DECLARE @resp int
    EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT

    DECLARE @result int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @result OUT

    EXEC sp_OASetProperty @result, 'Strict', 1
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Prefer', 'outlook.timezone="UTC", IdType="ImmutableId"'
    --  Live deletion. Use the exact event ID returned by a previous Graph request.
    --  Deleting an organizer's meeting sends cancellation messages to attendees.
    DECLARE @eventId nvarchar(4000)
    SELECT @eventId = 'YOUR_EVENT_ID'
    DECLARE @url int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @url OUT

    EXEC sp_OAMethod @url, 'Append', @success OUT, 'https://graph.microsoft.com/v1.0/me/events/'
    EXEC sp_OAMethod @http, 'UrlEncode', @sTmp0 OUT, @eventId
    EXEC sp_OAMethod @url, 'Append', @success OUT, @sTmp0
    EXEC sp_OAMethod @url, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @http, 'HttpNoBody', @success OUT, 'DELETE', @sTmp0, @resp
    --  A false result can still include an HTTP error response.
    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    IF (@success <> 1) and (@iTmp0 = 0)
      BEGIN

        PRINT 'No HTTP response was received. Inspect diagnostics privately; reconcile a write before retrying.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @resp
        EXEC @hr = sp_OADestroy @result
        EXEC @hr = sp_OADestroy @url
        RETURN
      END
    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    IF @iTmp0 <> 204
      BEGIN

        EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
        PRINT 'Unexpected HTTP status: ' + @iTmp0

        EXEC sp_OAMethod @resp, 'GetHeaderField', @sTmp0 OUT, 'request-id'
        PRINT 'Request ID: ' + @sTmp0
        EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
        IF @iTmp0 = 429
          BEGIN

            EXEC sp_OAMethod @resp, 'GetHeaderField', @sTmp0 OUT, 'Retry-After'
            PRINT 'Retry-After: ' + @sTmp0
          END
        EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
        IF @iTmp0 = 401
          BEGIN

            PRINT 'Refresh the Graph access token or authorize again.'
          END
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @resp
        EXEC @hr = sp_OADestroy @result
        EXEC @hr = sp_OADestroy @url
        RETURN
      END
    --  HTTP 204 has no JSON body.

    PRINT 'Event deleted.'

    EXEC @hr = sp_OADestroy @token
    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @resp
    EXEC @hr = sp_OADestroy @result
    EXEC @hr = sp_OADestroy @url


END
GO