Visual FoxPro
Visual FoxPro
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 Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loJson
LOCAL loHttp
LOCAL lcResp
LOCAL loLastMod
LOCAL loPhotoTaken
LOCAL i
LOCAL lnNumItems
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()
* 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:
loHttp.SetUrlVar("userId","4fe732c3-322e-4a6b-b729-2fd1eb5c6104")
loHttp.SetUrlVar("itemId","root")
lcResp = loHttp.QuickGetStr("https://graph.microsoft.com/v1.0/users/{$userId}/drive/items/{$itemId}/children")
IF (loHttp.LastMethodSuccess <> 1) THEN
? loHttp.LastErrorText
RELEASE loJson
RELEASE loHttp
CANCEL
ENDIF
* The response should be JSON.
loJson.EmitCompact = 0
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
? loJson.Emit()
* See the sample JSON response and output below..
loLastMod = CreateObject('Chilkat.CkDateTime')
loPhotoTaken = CreateObject('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.)
i = 0
lnNumItems = loJson.SizeOfArray("value")
DO WHILE i < lnNumItems
loJson.I = i
? "-- DriveItem " + STR(i + 1)
? "id: " + loJson.StringOf("value[i].id")
? "name: " + loJson.StringOf("value[i].name")
? "size: " + STR(loJson.IntOf("value[i].size"))
* Get the lastModifiedDateTime
loLastMod.SetFromTimestamp(loJson.StringOf("value[i].fileSystemInfo.lastModifiedDateTime"))
* Is this a folder?
IF (loJson.HasMember("value[i].folder") = 1) THEN
? "This is a folder with " + STR(loJson.IntOf("value[i].folder.childCount")) + " children"
ENDIF
IF (loJson.HasMember("value[i].file") = 1) THEN
? "This is a file."
? "SHA1 hash: " + loJson.StringOf("value[i].file.hashes.sha1Hash")
? "mimeType: " + loJson.StringOf("value[i].mimeType")
ENDIF
IF (loJson.HasMember("value[i].image") = 1) THEN
? "This is an image."
? "height: " + STR(loJson.IntOf("value[i].image.height"))
? "width: " + STR(loJson.IntOf("value[i].image.width"))
ENDIF
IF (loJson.HasMember("value[i].photo") = 1) THEN
? "This is a photo."
loPhotoTaken.SetFromTimestamp(loJson.StringOf("value[i].photo.takenDateTime"))
? "photo taken on " + loPhotoTaken.GetAsRfc822(1)
ENDIF
IF (loJson.HasMember("value[i].audio") = 1) THEN
? "This is an audio file."
? "duration: " + STR(loJson.IntOf("value[i].audio.duration"))
ENDIF
i = i + 1
ENDDO
* 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"
* }
* }
* ]
* }
RELEASE loJson
RELEASE loHttp
RELEASE loLastMod
RELEASE loPhotoTaken