(PowerBuilder) OneDrive -- List Non-Root Directory

See more OneDrive Examples

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

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

integer li_rc
oleobject loo_Json
oleobject loo_Http
string ls_Resp
oleobject loo_LastMod
oleobject loo_PhotoTaken
integer i
integer li_NumItems

// 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
loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")
if li_rc < 0 then
    destroy loo_Json
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_Json.UpdateString("client_id","2871da2c-8176-4b7f-869b-2311aa82e743")
loo_Json.UpdateString("client_secret","2hu9Q~~r5QuryUcEkNbg1btLtnfU1VUXzhSCG6brH")
loo_Json.UpdateString("scope","https://graph.microsoft.com/.default")
loo_Json.UpdateString("token_endpoint","https://login.microsoftonline.com/114d7ed6-71bf-4dbe-a866-748364121bf2/oauth2/v2.0/token")

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")

loo_Http.AuthToken = loo_Json.Emit()

// Send a Get request like this:
// GET /users/{user-id}/drive/root:/{item-path}:/children

// This example will get the DriveItems in /TestDir
// (In other words, we're getting the directory listing for /TestDir.)
loo_Http.SetUrlVar("item_path","/TestDir")
loo_Http.SetUrlVar("user_id","4fe732c3-322e-4a6b-b729-2fd1eb5c6104")

ls_Resp = loo_Http.QuickGetStr("https://graph.microsoft.com/v1.0/users/{$user_id}/drive/root:{$item_path}:/children")
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Json
    destroy loo_Http
    return
end if

// The response should be JSON.
loo_Json.EmitCompact = 0
loo_Json.Load(ls_Resp)

// A successful response should return a status code of 200.
if loo_Http.LastStatus <> 200 then
    Write-Debug loo_Json.Emit()
    Write-Debug "Response status = " + string(loo_Http.LastStatus)
    destroy loo_Json
    destroy loo_Http
    return
end if

Write-Debug loo_Json.Emit()

loo_LastMod = create oleobject
// Use "Chilkat_9_5_0.CkDateTime" for versions of Chilkat < 10.0.0
li_rc = loo_LastMod.ConnectToNewObject("Chilkat.CkDateTime")

loo_PhotoTaken = create oleobject
// Use "Chilkat_9_5_0.CkDateTime" for versions of Chilkat < 10.0.0
li_rc = loo_PhotoTaken.ConnectToNewObject("Chilkat.CkDateTime")

// Iterate over the DriveItems in the JSON response:
i = 0
li_NumItems = loo_Json.SizeOfArray("value")
do while i < li_NumItems
    loo_Json.I = i
    Write-Debug "-- DriveItem " + string(i + 1)
    Write-Debug "id: " + loo_Json.StringOf("value[i].id")
    Write-Debug "name: " + loo_Json.StringOf("value[i].name")
    Write-Debug "size: " + string(loo_Json.IntOf("value[i].size"))

    // Get the lastModifiedDateTime
    loo_LastMod.SetFromTimestamp(loo_Json.StringOf("value[i].fileSystemInfo.lastModifiedDateTime"))

    // Is this a folder?
    if loo_Json.HasMember("value[i].folder") = 1 then
        Write-Debug "This is a folder with " + string(loo_Json.IntOf("value[i].folder.childCount")) + " children"
    end if

    if loo_Json.HasMember("value[i].file") = 1 then
        Write-Debug "This is a file."
        Write-Debug "SHA1 hash: " + loo_Json.StringOf("value[i].file.hashes.sha1Hash")
        Write-Debug "mimeType: " + loo_Json.StringOf("value[i].mimeType")
    end if

    if loo_Json.HasMember("value[i].image") = 1 then
        Write-Debug "This is an image."
        Write-Debug "height: " + string(loo_Json.IntOf("value[i].image.height"))
        Write-Debug "width: " + string(loo_Json.IntOf("value[i].image.width"))
    end if

    if loo_Json.HasMember("value[i].photo") = 1 then
        Write-Debug "This is a photo."
        loo_PhotoTaken.SetFromTimestamp(loo_Json.StringOf("value[i].photo.takenDateTime"))
        Write-Debug "photo taken on " + loo_PhotoTaken.GetAsRfc822(1)
    end if

    if loo_Json.HasMember("value[i].audio") = 1 then
        Write-Debug "This is an audio file."
        Write-Debug "duration: " + string(loo_Json.IntOf("value[i].audio.duration"))
    end if

    i = i + 1
loop


destroy loo_Json
destroy loo_Http
destroy loo_LastMod
destroy loo_PhotoTaken