Xojo Plugin
Xojo Plugin
OneDrive -- List Root Directory
See more OneDrive Examples
This gets the collection of DriveItem children of the root DriveItem. In OneDrive, a driveItem resource represents a file, folder, or other item stored in a drive. All file system objects in OneDriveare returned as driveItem resources (which are JSON objects).This example returns the collection of child DriveItems for the root DriveItem.
Note: This example requires Chilkat v9.5.0.97 or greater.
Chilkat Xojo Plugin Downloads
Dim success As Boolean
success = False
// 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
Dim json As New 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")
Dim http As New Chilkat.Http
http.AuthToken = json.Emit()
// Sends the following GET request:
// GET https://graph.microsoft.com/v1.0/users/{user-id}/drive/items/{item-id}/children
// Use your specific Id instead of what we're using here:
success = http.SetUrlVar("userId","4fe732c3-322e-4a6b-b729-2fd1eb5c6104")
success = http.SetUrlVar("itemId","root")
Dim resp As String
resp = http.QuickGetStr("https://graph.microsoft.com/v1.0/users/{$userId}/drive/items/{$itemId}/children")
If (http.LastMethodSuccess <> True) Then
System.DebugLog(http.LastErrorText)
Return
End If
// The response should be JSON.
json.EmitCompact = False
success = json.Load(resp)
// A successful response should return a status code of 200.
If (http.LastStatus <> 200) Then
System.DebugLog(json.Emit())
System.DebugLog("Response status = " + Str(http.LastStatus))
Return
End If
System.DebugLog(json.Emit())
// See the sample JSON response and output below..
Dim lastMod As New Chilkat.CkDateTime
Dim photoTaken As New Chilkat.CkDateTime
// Iterate over the DriveItems in the JSON response:
// (I tested this example with a root that contains a several folders,
// a JPG image file, an XML file, and a WAV audio file.)
Dim i As Int32
i = 0
Dim numItems As Int32
numItems = json.SizeOfArray("value")
While i < numItems
json.I = i
System.DebugLog("-- DriveItem " + Str(i + 1))
System.DebugLog("id: " + json.StringOf("value[i].id"))
System.DebugLog("name: " + json.StringOf("value[i].name"))
System.DebugLog("size: " + Str(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") = True) Then
System.DebugLog("This is a folder with " + Str(json.IntOf("value[i].folder.childCount")) + " children")
End If
If (json.HasMember("value[i].file") = True) Then
System.DebugLog("This is a file.")
System.DebugLog("SHA1 hash: " + json.StringOf("value[i].file.hashes.sha1Hash"))
System.DebugLog("mimeType: " + json.StringOf("value[i].mimeType"))
End If
If (json.HasMember("value[i].image") = True) Then
System.DebugLog("This is an image.")
System.DebugLog("height: " + Str(json.IntOf("value[i].image.height")))
System.DebugLog("width: " + Str(json.IntOf("value[i].image.width")))
End If
If (json.HasMember("value[i].photo") = True) Then
System.DebugLog("This is a photo.")
success = photoTaken.SetFromTimestamp(json.StringOf("value[i].photo.takenDateTime"))
System.DebugLog("photo taken on " + photoTaken.GetAsRfc822(True))
End If
If (json.HasMember("value[i].audio") = True) Then
System.DebugLog("This is an audio file.")
System.DebugLog("duration: " + Str(json.IntOf("value[i].audio.duration")))
End If
i = i + 1
Wend
// The output for the above loop:
// -- DriveItem 1
// id: 3A33FCEB9B74CC15!187
// name: Documents
// size: 4452847
// This is a folder with 8 children
// -- DriveItem 2
// id: 3A33FCEB9B74CC15!4114
// name: Downloads
// size: 18240001
// This is a folder with 6 children
// -- DriveItem 3
// id: 3A33FCEB9B74CC15!4407
// name: lots-of-files
// size: 7542
// This is a folder with 450 children
// -- DriveItem 4
// id: 3A33FCEB9B74CC15!4858
// name: Misc
// size: 819922938
// This is a folder with 6 children
// -- DriveItem 5
// id: 3A33FCEB9B74CC15!185
// name: Pictures
// size: 0
// This is a folder with 3 children
// -- DriveItem 6
// id: 3A33FCEB9B74CC15!186
// name: Public
// size: 0
// This is a folder with 0 children
// -- DriveItem 7
// id: 3A33FCEB9B74CC15!4860
// name: hamlet.xml
// size: 279658
// This is a file.
// SHA1 hash: C6AD0095E07141C97A3C6B85778602AD883F5500
// mimeType:
// -- DriveItem 8
// id: 3A33FCEB9B74CC15!4861
// name: msg_123_abc.wav
// size: 155564
// This is a file.
// SHA1 hash: 1F51ADBDAADEAABC2D588C2A795AE86758525984
// mimeType:
// This is an audio file.
// duration: 9720
// -- DriveItem 9
// id: 3A33FCEB9B74CC15!4859
// name: penguins.jpg
// size: 777835
// This is a file.
// SHA1 hash: DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0
// mimeType:
// This is an image.
// height: 768
// width: 1024
// This is a photo.
// photo taken on Sun, 17 Feb 2008 23:07:31 -0600
//
// -------------------------------------------------------
// This is the JSON response when this example was tested:
// {
// "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/drive/root/children",
// "value": [
// {
// "createdBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "createdDateTime": "2013-06-12T19:49:08.367Z",
// "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITE4Ny42MzYyODA2Nzc4MjI3MzAwMDA",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSExODcuMA",
// "id": "3A33FCEB9B74CC15!187",
// "lastModifiedBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "lastModifiedDateTime": "2017-04-17T23:16:22.273Z",
// "name": "Documents",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 4452847,
// "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6gTs",
// "fileSystemInfo": {
// "createdDateTime": "2013-06-12T19:49:08.366Z",
// "lastModifiedDateTime": "2013-06-12T19:49:08.367Z"
// },
// "folder": {
// "childCount": 8
// },
// "specialFolder": {
// "name": "documents"
// }
// },
// {
// "createdBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "createdDateTime": "2016-12-07T14:02:22.417Z",
// "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITQxMTQuNjM2MjQzMzEyODEwMjAwMDAw",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0MTE0LjE",
// "id": "3A33FCEB9B74CC15!4114",
// "lastModifiedBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "lastModifiedDateTime": "2017-03-05T17:21:21.02Z",
// "name": "Downloads",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 18240001,
// "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6oBI",
// "fileSystemInfo": {
// "createdDateTime": "2016-12-07T14:02:09Z",
// "lastModifiedDateTime": "2016-12-07T14:02:09Z"
// },
// "folder": {
// "childCount": 6
// }
// },
// {
// "createdBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "createdDateTime": "2017-06-02T02:14:59.797Z",
// "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITQ0MDcuNjM2MzE5NjY2MDIzNDcwMDAw",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0NDA3LjA",
// "id": "3A33FCEB9B74CC15!4407",
// "lastModifiedBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "lastModifiedDateTime": "2017-06-02T02:16:42.347Z",
// "name": "lots-of-files",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 7542,
// "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6ojc",
// "fileSystemInfo": {
// "createdDateTime": "2017-06-02T02:13:11Z",
// "lastModifiedDateTime": "2017-06-02T02:14:54Z"
// },
// "folder": {
// "childCount": 450
// }
// },
// {
// "createdBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "createdDateTime": "2017-06-02T19:06:10.293Z",
// "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITQ4NTguNjM2MzIwMjcxOTAxNDcwMDAw",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODU4LjA",
// "id": "3A33FCEB9B74CC15!4858",
// "lastModifiedBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "lastModifiedDateTime": "2017-06-02T19:06:30.147Z",
// "name": "Misc",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 819922938,
// "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6pXo",
// "fileSystemInfo": {
// "createdDateTime": "2017-06-02T19:06:02Z",
// "lastModifiedDateTime": "2017-06-02T19:06:02Z"
// },
// "folder": {
// "childCount": 6
// }
// },
// {
// "createdBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "createdDateTime": "2013-06-12T19:49:08.123Z",
// "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITE4NS42MzYxNDU5MzkxMDcyMDAwMDA",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSExODUuMA",
// "id": "3A33FCEB9B74CC15!185",
// "lastModifiedBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "lastModifiedDateTime": "2016-11-13T00:31:50.72Z",
// "name": "Pictures",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 0,
// "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6gTk",
// "fileSystemInfo": {
// "createdDateTime": "2013-06-12T19:49:08.123Z",
// "lastModifiedDateTime": "2013-06-12T19:49:08.123Z"
// },
// "folder": {
// "childCount": 3
// },
// "specialFolder": {
// "name": "photos"
// }
// },
// {
// "createdBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "createdDateTime": "2013-06-12T19:49:08.183Z",
// "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITE4Ni42MzUwNjY2MzM0ODMwMzAwMDA",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSExODYuMQ",
// "id": "3A33FCEB9B74CC15!186",
// "lastModifiedBy": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "lastModifiedDateTime": "2013-06-12T19:49:08.303Z",
// "name": "Public",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 0,
// "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6gTo",
// "fileSystemInfo": {
// "createdDateTime": "2013-06-12T19:49:08.183Z",
// "lastModifiedDateTime": "2013-06-12T19:49:08.183Z"
// },
// "folder": {
// "childCount": 0
// },
// "shared": {
// "owner": {
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// }
// },
// "scope": "anonymous"
// },
// "specialFolder": {
// "name": "public"
// }
// },
// {
// "@microsoft.graph.downloadUrl": "https://public.dm2301.livefilestore.com/y4m8Y4r_Ewfy3hIxqpU-_dxvY455X2gAZd3LJXE908zgA1ErQUm5wZpiyz6Rs0YfFb_c5SKgOFZV6HU1YpEmd0MvWbQ-dJVy2lLfRqTUnHEY8znUIQrljmTk1GR2auv4rTitRzWEZztQV0iId2-_FdQj2aZK5sdpmkdbgNuishP0NalJBsLdiBeKBVsy7A_zFTUXbw28ZzJctfyqITNUtBPxmDRzF39UWRjTo74CksCHc4",
// "createdBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "createdDateTime": "2017-06-02T19:08:34.14Z",
// "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NjAuMjU3",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODYwLjA",
// "id": "3A33FCEB9B74CC15!4860",
// "lastModifiedBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "lastModifiedDateTime": "2017-06-02T19:08:34.14Z",
// "name": "hamlet.xml",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 279658,
// "webUrl": "https://1drv.ms/u/s!ABXMdJvr_DM6pXw",
// "file": {
// "hashes": {
// "sha1Hash": "C6AD0095E07141C97A3C6B85778602AD883F5500"
// },
// "mimeType": "application/xml"
// },
// "fileSystemInfo": {
// "createdDateTime": "2017-06-02T19:08:30Z",
// "lastModifiedDateTime": "2016-03-03T23:10:30Z"
// }
// },
// {
// "@microsoft.graph.downloadUrl": "https://public.dm2301.livefilestore.com/y4mZ4m1N8Vzd40ZtPERT8qEo4nOxt786w5uHDuX4VkessshXBY9z9wyG3rb0GYAAaCYWd64tLCmFcObsobWoLZXkGwgAdBE5ebvHTxmS3W6Z7U0ZzBHviaIa2RufoGhOtAWCImPxRKxID3wPvqPW5jCG31tCXhtrJMuGHnW2TkWg3FxJEvezSkI2PBTGpMzvGVjjX-qsHSnP5OMFyx0ikwVMaGU7_KvGcDUZtj9clz8rXQ",
// "createdBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "createdDateTime": "2017-06-02T19:08:53.167Z",
// "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NjEuMjU3",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODYxLjA",
// "id": "3A33FCEB9B74CC15!4861",
// "lastModifiedBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "lastModifiedDateTime": "2017-06-02T19:08:53.167Z",
// "name": "msg_123_abc.wav",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 155564,
// "webUrl": "https://1drv.ms/u/s!ABXMdJvr_DM6pX0",
// "audio": {
// "bitrate": 128,
// "duration": 9720,
// "hasDrm": false
// },
// "file": {
// "hashes": {
// "sha1Hash": "1F51ADBDAADEAABC2D588C2A795AE86758525984"
// },
// "mimeType": "audio/wav"
// },
// "fileSystemInfo": {
// "createdDateTime": "2017-06-02T19:08:49Z",
// "lastModifiedDateTime": "2017-04-18T14:27:12Z"
// }
// },
// {
// "@microsoft.graph.downloadUrl": "https://public.dm2301.livefilestore.com/y4m5U-QanvmGcb5NeRyPaf2dy32EyX2yf_uNvPgnioU2JGrvB25yZq4uKEiQGMex99sWQ2LXcjAQbQx41C-SpqRrccIKsTvnIbbyaB45gaBSLsTeryE75p70-l4FOXb8HJWfPZmMl30BhCqpMge2ZLVo8h3uUlL7WIijap5wHdVlb0g_nm47EMDFh3USIL43kY5u4NPpoaxNEoMGYtYZ2ojzDwu-kBgKgD0S3wxCvmlD8o",
// "createdBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "createdDateTime": "2017-06-02T19:07:06.813Z",
// "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NTkuMjU3",
// "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODU5LjI",
// "id": "3A33FCEB9B74CC15!4859",
// "lastModifiedBy": {
// "device": {
// "id": "187ffebfaf8fa5"
// },
// "user": {
// "displayName": "Matt Smith",
// "id": "3a33fceb9b74cc15"
// },
// "oneDriveSync": {
// "@odata.type": "#microsoft.graph.identity",
// "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
// }
// },
// "lastModifiedDateTime": "2017-06-02T19:07:09.203Z",
// "name": "penguins.jpg",
// "parentReference": {
// "driveId": "3a33fceb9b74cc15",
// "id": "3A33FCEB9B74CC15!184",
// "path": "/drive/root:"
// },
// "size": 777835,
// "webUrl": "https://1drv.ms/i/s!ABXMdJvr_DM6pXs",
// "file": {
// "hashes": {
// "sha1Hash": "DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0"
// },
// "mimeType": "image/jpeg"
// },
// "fileSystemInfo": {
// "createdDateTime": "2017-06-02T19:06:54Z",
// "lastModifiedDateTime": "2009-07-14T05:32:31Z"
// },
// "image": {
// "height": 768,
// "width": 1024
// },
// "photo": {
// "takenDateTime": "2008-02-18T05:07:31Z"
// }
// }
// ]
// }