PowerBuilder
PowerBuilder
OneDrive -- Search for Files
See more OneDrive Examples
Search for files within a hierarchy of items for items matching a query. You can search within a folder hierarhcy or a whole drive.Note: This example requires Chilkat v9.5.0.97 or greater.
Chilkat PowerBuilder Downloads
integer li_rc
long li_Success
oleobject loo_Json
oleobject loo_Http
oleobject loo_SbResults
oleobject loo_LastMod
oleobject loo_PhotoTaken
long i
long li_NumItems
li_Success = 0
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
// Use your client ID, client secret, and tenant ID in the following lines
loo_Json = create oleobject
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
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
loo_Http.AuthToken = loo_Json.Emit()
// Sends the following GET request:
// Search the entire drive like this:
// If not using "me", then the path should be /v1.0/users/{id | userPrincipalName}/...
// GET /v1.0/users/{user-id}/drive/root/search(q='{search-text}')
// Or search under a particular folder like this:
// GET /v1.0/users/{user-id}/drive/root:/{item-path}:/search(q='{search-text}')
// This example will search for files in or under the "/Misc" directory, having "penguin" in the file path.
loo_Http.SetUrlVar("item_path","/Misc")
loo_Http.SetUrlVar("search_text","penguins")
loo_Http.SetUrlVar("user_id","4fe732c3-322e-4a6b-b729-2fd1eb5c6104")
loo_SbResults = create oleobject
li_rc = loo_SbResults.ConnectToNewObject("Chilkat.StringBuilder")
li_Success = loo_Http.QuickGetSb("https://graph.microsoft.com/v1.0/users/{$user_id}/drive/root:/{$item_path}:/search(q='{$search_text}')",loo_SbResults)
if loo_Http.LastMethodSuccess <> 1 then
Write-Debug loo_Http.LastErrorText
destroy loo_Json
destroy loo_Http
destroy loo_SbResults
return
end if
// The response should be JSON.
loo_Json.EmitCompact = 0
loo_Json.LoadSb(loo_SbResults)
// 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
destroy loo_SbResults
return
end if
Write-Debug loo_Json.Emit()
Write-Debug "--"
// Iterate over the results in the JSON response:
loo_LastMod = create oleobject
li_rc = loo_LastMod.ConnectToNewObject("Chilkat.CkDateTime")
loo_PhotoTaken = create oleobject
li_rc = loo_PhotoTaken.ConnectToNewObject("Chilkat.CkDateTime")
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
// Sample JSON OneDrive search response:
// {
// "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#Collection(driveItem)",
// "value": [
// {
// "@odata.type": "#microsoft.graph.driveItem",
// "@microsoft.graph.downloadUrl": "https://public.dm2301.livefilestore.com/y4m01N6dLIV7ditztcRwWDx2Jzf1qiwJNASFiHfajfZUuJnEMgHmIZTASy3lNzwUFHQgET0I11hzqCyb0A6I5jhI9FgFAJlBJHFrToT7QXj2xvCV46LOZVJASk79LEWRRM97aOhdOHhKeIl_HxoIWSl08sX3kGyC50RP72rDE7ERSVdZAa3CmMNkp6tRtfKI5wfJNqSx3NeqLQ6LxwBBY4KgniPQOgEna0G_MKTGDt10T4",
// "createdBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "createdDateTime": "2017-06-04T20:40:22.48Z",
// "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NzIuMjU3",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODcyLjI",
// "id": "3A33FCEB9B74CC15!4872",
// "lastModifiedBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "lastModifiedDateTime": "2017-06-04T20:40:23.463Z",
// "name": "penguins.jpg",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!4871",
// "name": "wildlife",
// "path": "/drive/root:/Misc/wildlife"
// },
// "size": 777835,
// "webUrl": "https://1drv.ms/i/s!ABXMdJvr_DM6pgg",
// "file": {
// "hashes": {
// "sha1Hash": "DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0"
// },
// "mimeType": "image/jpeg"
// },
// "fileSystemInfo": {
// "createdDateTime": "2017-06-04T20:40:22.48Z",
// "lastModifiedDateTime": "2009-07-14T05:32:31.674Z"
// },
// "image": {
// "height": 768,
// "width": 1024
// },
// "photo": {
// "takenDateTime": "2008-02-18T05:07:31Z"
// },
// "searchResult": {
// "onClickTelemetryUrl": "https://www.bing.com/personalsearchclick?IG=D10F15177AE54D49A97F361270D53290&CID=3A33FCEB9B74CC150000000000000000&ID=DevEx%2c5005&q=penguins&resid=3A33FCEB9B74CC15%214872"
// }
// }
// ]
// }
destroy loo_Json
destroy loo_Http
destroy loo_SbResults
destroy loo_LastMod
destroy loo_PhotoTaken