(Excel) OneDrive -- List Large Directory

Demonstrates how to get the entire collection of DriveItem children when the collection is large and multiple pages need to be requested. To test this example, I created a DriveItem with 450 children.

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"

' This example will get the DriveItems in /lots-of-files, which has 450 children..
Dim success As Boolean
success = http.SetUrlVar("item_path","/lots-of-files")

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False

' This loop will download DriveItems in sets of 50 until no more exist.

bGetMore = True
' (Add the $top query parameter to define the page size, i.e. the max number of results to return).

nextLink = "https://graph.microsoft.com/v1.0/me/drive/root:{$item_path}:/children?$top=50"

Do While (bGetMore = True)

    ' Get the next chunk of DriveItems
    resp = http.QuickGetStr(nextLink)
    If (http.LastMethodSuccess <> True) Then
        Debug.Print http.LastErrorText
        Exit Sub
    End If

    ' The response should be JSON.
    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

    ' Iterate over the DriveItems in the JSON response:
    i = 0
    numItems = json.SizeOfArray("value")
    Do While i < numItems
        json.I = i
        Debug.Print "name: "; json.StringOf("value[i].name")
        i = i + 1
    Loop

    ' If a nextLink was included in the JSON, use it to get the next set of 50 DriveItems.
    ' Otherwise, exit the loop.
    If (json.HasMember("""@odata.nextLink""") = True) Then
        nextLink = json.StringOf("""@odata.nextLink""")
        Debug.Print "nextLink: "; nextLink
    Else
        bGetMore = False
    End If

Loop