VBScript
VBScript
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 VBScript Downloads
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
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
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("client_id","2871da2c-8176-4b7f-869b-2311aa82e743")
success = json.UpdateString("client_secret","2hu9Q~r5QuryUcEkNbg1btLtnfU1VUXzhSCG6brH")
success = json.UpdateString("scope","https://graph.microsoft.com/.default")
success = json.UpdateString("token_endpoint","https://login.microsoftonline.com/114d7ed6-71bf-4dbe-a866-748364121bf2/oauth2/v2.0/token")
set http = CreateObject("Chilkat.Http")
http.AuthToken = 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.
success = http.SetUrlVar("item_path","/Misc")
success = http.SetUrlVar("search_text","penguins")
success = http.SetUrlVar("user_id","4fe732c3-322e-4a6b-b729-2fd1eb5c6104")
set sbResults = CreateObject("Chilkat.StringBuilder")
success = http.QuickGetSb("https://graph.microsoft.com/v1.0/users/{$user_id}/drive/root:/{$item_path}:/search(q='{$search_text}')",sbResults)
If (http.LastMethodSuccess <> 1) Then
outFile.WriteLine(http.LastErrorText)
WScript.Quit
End If
' The response should be JSON.
json.EmitCompact = 0
success = json.LoadSb(sbResults)
' A successful response should return a status code of 200.
If (http.LastStatus <> 200) Then
outFile.WriteLine(json.Emit())
outFile.WriteLine("Response status = " & http.LastStatus)
WScript.Quit
End If
outFile.WriteLine(json.Emit())
outFile.WriteLine("--")
' Iterate over the results in the JSON response:
set lastMod = CreateObject("Chilkat.CkDateTime")
set photoTaken = CreateObject("Chilkat.CkDateTime")
i = 0
numItems = json.SizeOfArray("value")
Do While i < numItems
json.I = i
outFile.WriteLine("-- DriveItem " & (i + 1))
outFile.WriteLine("id: " & json.StringOf("value[i].id"))
outFile.WriteLine("name: " & json.StringOf("value[i].name"))
outFile.WriteLine("size: " & json.IntOf("value[i].size"))
' Get the lastModifiedDateTime
success = lastMod.SetFromTimestamp(json.StringOf("value[i].fileSystemInfo.lastModifiedDateTime"))
' Is this a folder?
If (json.HasMember("value[i].folder") = 1) Then
outFile.WriteLine("This is a folder with " & json.IntOf("value[i].folder.childCount") & " children")
End If
If (json.HasMember("value[i].file") = 1) Then
outFile.WriteLine("This is a file.")
outFile.WriteLine("SHA1 hash: " & json.StringOf("value[i].file.hashes.sha1Hash"))
outFile.WriteLine("mimeType: " & json.StringOf("value[i].mimeType"))
End If
If (json.HasMember("value[i].image") = 1) Then
outFile.WriteLine("This is an image.")
outFile.WriteLine("height: " & json.IntOf("value[i].image.height"))
outFile.WriteLine("width: " & json.IntOf("value[i].image.width"))
End If
If (json.HasMember("value[i].photo") = 1) Then
outFile.WriteLine("This is a photo.")
success = photoTaken.SetFromTimestamp(json.StringOf("value[i].photo.takenDateTime"))
outFile.WriteLine("photo taken on " & photoTaken.GetAsRfc822(1))
End If
If (json.HasMember("value[i].audio") = 1) Then
outFile.WriteLine("This is an audio file.")
outFile.WriteLine("duration: " & 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"
' }
' }
' ]
' }
outFile.Close