(Excel) OneDrive -- List Drives

Example to retrieve the list of Drive resources available for a target User or Group.

Note: This example requires Chilkat v9.5.0.68 or greater.

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:
' See the following examples for getting an access token:
'    Get Microsoft Graph OAuth2 Access Token (Azure AD v2.0 Endpoint).
'    Get Microsoft Graph OAuth2 Access Token (Azure AD Endpoint).
'    Refresh Access Token (Azure AD v2.0 Endpoint).
'    Refresh Access Token (Azure AD Endpoint).

' (Make sure your token was obtained with the FilesRead or Files.ReadWrite scope.)
http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

' Sends the following GET request:
' GET https://graph.microsoft.com/v1.0/me/drives


resp = http.QuickGetStr("https://graph.microsoft.com/v1.0/me/drives")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' The response should be JSON.
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False
Dim success As Boolean
success = json.Load(resp)

' A successful response should return a status code of 200.
If (http.LastStatus <> 200) Then
    Debug.Print json.Emit()
    Debug.Print "Response status = "; http.LastStatus
    Exit Sub
End If

Debug.Print json.Emit()

' Sample output:

' 	{
' 	  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#drives",
' 	  "value": [
' 	    {
' 	      "id": "3a33fceb9b74cc15",
' 	      "driveType": "personal",
' 	      "owner": {
' 	        "user": {
' 	          "displayName": "Matt Smith",
' 	          "id": "3a33fceb9b74cc15"
' 	        }
' 	      },
' 	      "quota": {
' 	        "deleted": 0,
' 	        "remaining": 1114571275977,
' 	        "state": "normal",
' 	        "total": 1115617755136,
' 	        "used": 1046479159
' 	      }
' 	    }
' 	  ]
' 	}

' Iterate over the drives in the JSON response:

i = 0

numDrives = json.SizeOfArray("value")
Do While i < numDrives
    json.I = i
    Debug.Print "-- Drive "; (i + 1)
    Debug.Print "id: "; json.StringOf("value[i].id")
    ' The size will be a number larger than what can fit in a 32-bit integer.
    ' Get the integer as a string..
    Debug.Print "total: "; json.StringOf("value[i].quota.total")
    i = i + 1
Loop