(Excel) OneDrive -- List Non-Root Directory

This gets the collection of DriveItem children for a non-root DriveItem. This is the same as for getting the children for the root DriveItem, except the URL includes the path to the desired non-root DriveItem.

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"

' Send a Get request like this:
' GET /me/drive/root:/{item-path}:/children

' This example will get the DriveItems in /Misc/old
' (In other words, we're getting the directory listing for /Misc/old.)
Dim success As Boolean
success = http.SetUrlVar("item_path","/Misc/old")


resp = http.QuickGetStr("https://graph.microsoft.com/v1.0/me/drive/root:{$item_path}:/children")
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
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()

Dim lastMod As Chilkat.CkDateTime
Set lastMod = Chilkat.NewCkDateTime
Dim photoTaken As Chilkat.CkDateTime
Set photoTaken = Chilkat.NewCkDateTime

' Iterate over the DriveItems in the JSON response:

i = 0

numItems = json.SizeOfArray("value")
Do While i < numItems
    json.I = i
    Debug.Print "-- DriveItem "; (i + 1)
    Debug.Print "id: "; json.StringOf("value[i].id")
    Debug.Print "name: "; json.StringOf("value[i].name")
    Debug.Print "size: "; json.IntOf("value[i].size")

    ' Get the lastModifiedDateTime
    success = lastMod.SetFromTimestamp(json.StringOf("value[i].fileSystemInfo.lastModifiedDateTime"))

    ' Is this a folder?
    If (json.HasMember("value[i].folder") = True) Then
        Debug.Print "This is a folder with "; json.IntOf("value[i].folder.childCount"); " children"
    End If

    If (json.HasMember("value[i].file") = True) Then
        Debug.Print "This is a file."
        Debug.Print "SHA1 hash: "; json.StringOf("value[i].file.hashes.sha1Hash")
        Debug.Print "mimeType: "; json.StringOf("value[i].mimeType")
    End If

    If (json.HasMember("value[i].image") = True) Then
        Debug.Print "This is an image."
        Debug.Print "height: "; json.IntOf("value[i].image.height")
        Debug.Print "width: "; json.IntOf("value[i].image.width")
    End If

    If (json.HasMember("value[i].photo") = True) Then
        Debug.Print "This is a photo."
        success = photoTaken.SetFromTimestamp(json.StringOf("value[i].photo.takenDateTime"))
        Debug.Print "photo taken on "; photoTaken.GetAsRfc822(True)
    End If

    If (json.HasMember("value[i].audio") = True) Then
        Debug.Print "This is an audio file."
        Debug.Print "duration: "; json.IntOf("value[i].audio.duration")
    End If

    i = i + 1
Loop