(Excel) Insert a New Google Calendar Event

See more Google Calendar Examples

Demonstrates how to insert a new Google Calendar event.

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

' Build a Google Calendar event:
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False
Dim success As Boolean
success = json.UpdateString("kind","calendar#event")
success = json.UpdateString("summary","Eat Lou Malnati's Pizza")
success = json.UpdateString("start.dateTime","2021-03-12T12:00:00-05:00")
success = json.UpdateString("end.dateTime","2021-03-12T13:00:00-05:00")

Debug.Print json.Emit()

' This is the event JSON we'll be sending the HTTP POST:

' {
'   "kind": "calendar#event",
'   "summary": "Eat Lou Malnati's Pizza",
'   "start": {
'     "dateTime": "2021-03-12T12:00:00-05:00"
'   },
'   "end": {
'     "dateTime": "2021-03-12T13:00:00-05:00"
'   }
' }


url = "https://www.googleapis.com/calendar/v3/calendars/{$calendarId}/events"
success = http.SetUrlVar("calendarId","primary")

Set resp = http.PostJson3(url,"application/json",json)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim jsonResp As Chilkat.JsonObject
Set jsonResp = Chilkat.NewJsonObject
jsonResp.EmitCompact = False
success = jsonResp.Load(resp.BodyStr)

If (resp.StatusCode = 200) Then
    ' Success.
    ' The newly created event resource JSON is returned.
    Debug.Print jsonResp.Emit()
Else
    If (resp.StatusCode = 401) Then
        Debug.Print "Try refreshing the access token and then retry..."
    End If

    ' Failed. 
    ' Show the JSON error response.
    Debug.Print jsonResp.Emit()
End If

' A successful response body:

' {
'   "kind": "calendar#event",
'   "etag": "\"3004969011208000\"",
'   "id": "v7kvmsvsoms3hjl5uq423jqhb0",
'   "status": "confirmed",
'   "htmlLink": "https://www.google.com/calendar/event?eid=djdrdm1zdnNvbXMzaGpsNXVxNDIzanFoYjAgc3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t",
'   "created": "2017-08-11T20:48:25.000Z",
'   "updated": "2017-08-11T20:48:25.604Z",
'   "summary": "Eat Lou Malnati's Pizza",
'   "creator": {
'     "email": "support@chilkatcloud.com",
'     "self": true
'   },
'   "organizer": {
'     "email": "support@chilkatcloud.com",
'     "self": true
'   },
'   "start": {
'     "dateTime": "2017-08-12T12:00:00-05:00"
'   },
'   "end": {
'     "dateTime": "2017-08-12T13:00:00-05:00"
'   },
'   "iCalUID": "v7kvmsvsoms3hjl5uq423jqhb0@google.com",
'   "sequence": 0,
'   "hangoutLink": "https://plus.google.com/hangouts/_/chilkatcloud.com/support?hceid=c3VwcG9ydEBjaGlsa2F0Y2xvdWQuY29t.v7kvmsvsoms3hjl5uq423jqhb0",
'   "reminders": {
'     "useDefault": true
'   }
' }