(Excel) Outlook Calendar List Events

See more Outlook Calendar Examples

Retrieve a list of events in a calendar.

For more information, see https://docs.microsoft.com/en-us/graph/api/calendar-list-events?view=graph-rest-1.0&tabs=http

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.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Use your previously obtained access token here: Get Outlook Calendar OAuth2 Access Token (Azure AD v2.0 Endpoint).

Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/outlookCalendar.json")
If (success = False) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

http.AuthToken = jsonToken.StringOf("access_token")

' Specify the ID of the calendar to list.

calendarId = "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEGAAAA5_vF7TKKdE6bGCRqXyl2PQAAAiCsAAAA"

Dim success As Boolean
success = http.SetUrlVar("id",calendarId)

' To list the events in the default calendar, use the following URL: https://graph.microsoft.com/v1.0/me/calendars/events


Set resp = http.QuickRequest("GET","https://graph.microsoft.com/v1.0/me/calendars/{$id}/events")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; resp.StatusCode

' The HTTP request succeeded if the response status code = 200.
If (resp.StatusCode <> 200) Then
    Debug.Print resp.BodyStr
    Debug.Print "Failed"

    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(resp.BodyStr)
json.EmitCompact = False
Debug.Print json.Emit()

' Here is a sample response:

' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

' {
'   "value": [
'     {
'       "originalStartTimeZone": "originalStartTimeZone-value",
'       "originalEndTimeZone": "originalEndTimeZone-value",
'       "responseStatus": {
'         "response": "",
'         "time": "datetime-value"
'       },
'       "iCalUId": "iCalUId-value",
'       "reminderMinutesBeforeStart": 99,
'       "isReminderOn": true
'     }
'   ]
' }


i = 0

count_i = json.SizeOfArray("value")
Do While i < count_i
    json.I = i
    originalStartTimeZone = json.StringOf("value[i].originalStartTimeZone")
    originalEndTimeZone = json.StringOf("value[i].originalEndTimeZone")
    responseStatusResponse = json.StringOf("value[i].responseStatus.response")
    responseStatusTime = json.StringOf("value[i].responseStatus.time")
    iCalUId = json.StringOf("value[i].iCalUId")
    reminderMinutesBeforeStart = json.IntOf("value[i].reminderMinutesBeforeStart")
    isReminderOn = json.BoolOf("value[i].isReminderOn")
    i = i + 1
Loop