(Excel) Delete a Google Calendar Event

See more Google Calendar Examples

Demonstrates how to delete a Google Calendar event.

For more information, see https://developers.google.com/calendar/v3/reference/events/delete

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' This example uses a previously obtained access token having permission for the 
' Google Calendar scope.

' In this example, Get Google Calendar OAuth2 Access Token, the access
' token was saved to a JSON file.  This example fetches the access token from the file..
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/googleCalendar.json")
If (jsonToken.HasMember("access_token") = False) Then
    Debug.Print "No access token found."
    Exit Sub
End If

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
http.AuthToken = jsonToken.StringOf("access_token")

' Your URL should use the actual calendar ID and the actual event ID for the event to be deleted.

url = "https://www.googleapis.com/calendar/v3/calendars/your_calendar_id/events/your_event_id"


Set resp = http.QuickRequest("DELETE",url)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

If (resp.StatusCode = 204) Then
    ' Success.
    Debug.Print "Event deleted"
Else
    If (resp.StatusCode = 401) Then
        Debug.Print "Try refreshing the access token and then retry..."
    End If

    ' Failed. 
    Debug.Print resp.BodyStr
End If