(Excel) MS Graph Calendars List

Get all the user's calendars (/calendars navigation property), get the calendars from the default calendar group or from a specific calendar group.

For more details, see https://docs.microsoft.com/en-us/graph/api/user-list-calendars?view=graph-rest-1.0

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 as shown here:
'    Get Microsoft Graph OAuth2 Access Token with Calendars.ReadWrite scope.

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

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

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

' Send a GET request to https://graph.microsoft.com/v1.0/me/calendars

strResponse = http.QuickGetStr("https://graph.microsoft.com/v1.0/me/calendars")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(strResponse)
json.EmitCompact = False

If (http.LastStatus <> 200) Then
    Debug.Print json.Emit()
    Debug.Print "Failed, response status code = "; http.LastStatus
    Exit Sub
End If

Debug.Print json.Emit()

' Sample output:

' {
'   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/calendars",
'   "value": [
'     {
'       "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEGAAAA5_vF7TKKdE6bGCRqXyl2PQAAAiCsAAAA",
'       "name": "Calendar",
'       "color": "auto",
'       "changeKey": "5+vF7TKKdE6bGCRqXyl2PQAAAAAiEQ==",
'       "canShare": true,
'       "canViewPrivateItems": true,
'       "canEdit": true,
'       "owner": {
'         "name": "...",
'         "address": "outlook_3A33FCEB9B74CC15@outlook.com"
'       }
'     },
'     {
'       "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgEGAAAA5_vF7TKKdE6bGCRqXyl2PQAClEpRTgAAAA==",
'       "name": "Work",
'       "color": "auto",
'       "changeKey": "5+vF7TKKdE6bGCRqXyl2PQAClHjDcA==",
'       "canShare": true,
'       "canViewPrivateItems": true,
'       "canEdit": true,
'       "owner": {
'         "name": "...",
'         "address": "outlook_3A33FCEB9B74CC15@outlook.com"
'       }
'     }
'   ]
' }
' 
' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

odataContext = json.StringOf("""@odata.context""")
i = 0
count_i = json.SizeOfArray("value")
Do While i < count_i
    json.I = i
    id = json.StringOf("value[i].id")
    name = json.StringOf("value[i].name")
    color = json.StringOf("value[i].color")
    changeKey = json.StringOf("value[i].changeKey")
    canShare = json.BoolOf("value[i].canShare")
    canViewPrivateItems = json.BoolOf("value[i].canViewPrivateItems")
    canEdit = json.BoolOf("value[i].canEdit")
    ownerName = json.StringOf("value[i].owner.name")
    ownerAddress = json.StringOf("value[i].owner.address")
    i = i + 1
Loop

Debug.Print "Success."