Visual FoxPro

OneDrive -- List Large Directory

See more OneDrive Examples

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.97 or greater.

Visual FoxPro

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

lnSuccess = 0

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

* This example uses the OAuth client credentials flow.
* See How to Create an Azure App Registration for OAuth 2.0 Client Credentials

* Use your client ID, client secret, and tenant ID in the following lines
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("client_id","2871da2c-8176-4b7f-869b-2311aa82e743")
loJson.UpdateString("client_secret","2hu9Q~r5QuryUcEkNbg1btLtnfU1VUXzhSCG6brH")
loJson.UpdateString("scope","https://graph.microsoft.com/.default")
loJson.UpdateString("token_endpoint","https://login.microsoftonline.com/114d7ed6-71bf-4dbe-a866-748364121bf2/oauth2/v2.0/token")

loHttp = CreateObject('Chilkat.Http')
loHttp.AuthToken = loJson.Emit()

* This example will get the DriveItems in /lots-of-files, which has 450 children..
loHttp.SetUrlVar("item_path","/lots-of-files")
loHttp.SetUrlVar("user_id","4fe732c3-322e-4a6b-b729-2fd1eb5c6104")

loJson.EmitCompact = 0

* This loop will download DriveItems in sets of 25 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/users/{$user_id}/drive/root:{$item_path}:/children?$top=25"

DO WHILE (lnBGetMore = 1)

    * Get the next chunk of DriveItems
    lcResp = loHttp.QuickGetStr(lcNextLink)
    IF (loHttp.LastMethodSuccess <> 1) THEN
        ? loHttp.LastErrorText
        RELEASE loJson
        RELEASE loHttp
        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 loJson
        RELEASE loHttp
        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 loJson
RELEASE loHttp