(Visual FoxPro) 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.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loHttp
LOCAL lcResp
LOCAL i
LOCAL lnNumItems
LOCAL loJson
LOCAL lnBGetMore
LOCAL lcNextLink

* This example requires the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

loHttp = CreateObject('Chilkat_9_5_0.Http')

* 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.)
loHttp.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

* This example will get the DriveItems in /lots-of-files, which has 450 children..
loHttp.SetUrlVar("item_path","/lots-of-files")

loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.EmitCompact = 0

* This loop will download DriveItems in sets of 50 until no more exist.
lnBGetMore = 1
* (Add the $top query parameter to define the page size, i.e. the max number of results to return).
lcNextLink = "https://graph.microsoft.com/v1.0/me/drive/root:{$item_path}:/children?$top=50"

DO WHILE (lnBGetMore = 1)

    * Get the next chunk of DriveItems
    lcResp = loHttp.QuickGetStr(lcNextLink)
    IF (loHttp.LastMethodSuccess <> 1) THEN
        ? loHttp.LastErrorText
        RELEASE loHttp
        RELEASE loJson
        CANCEL
    ENDIF

    * The response should be JSON.
    loJson.Load(lcResp)

    * A successful response should return a status code of 200.
    IF (loHttp.LastStatus <> 200) THEN
        ? loJson.Emit()
        ? "Response status = " + STR(loHttp.LastStatus)
        RELEASE loHttp
        RELEASE loJson
        CANCEL
    ENDIF

    * Iterate over the DriveItems in the JSON response:
    i = 0
    lnNumItems = loJson.SizeOfArray("value")
    DO WHILE i < lnNumItems
        loJson.I = i
        ? "name: " + loJson.StringOf("value[i].name")
        i = i + 1
    ENDDO

    * If a nextLink was included in the JSON, use it to get the next set of 50 DriveItems.
    * Otherwise, exit the loop.
    IF (loJson.HasMember('"@odata.nextLink"') = 1) THEN
        lcNextLink = loJson.StringOf('"@odata.nextLink"')
        ? "nextLink: " + lcNextLink
    ELSE
        lnBGetMore = 0
    ENDIF

ENDDO

RELEASE loHttp
RELEASE loJson