(VBScript) Retrieve the metadata for a DriveItem

See more OneDrive Examples

Fetches the JSON metadata for a DriveItem.

For more information, see https://docs.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_get?view=odsp-graph-online

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

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' 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
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
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")

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")
http.AuthToken = json.Emit()

' Sends the following GET request:
' GET https://graph.microsoft.com/v1.0/users/{user-id}/drive/root:/{item-path}

' Make sure to automatically follow redirects
http.FollowRedirects = 1

' This example will get the metadata for /Misc/wildlife/penguins.jpg
success = http.SetUrlVar("item_path","Misc//penguins.jpg")
success = http.SetUrlVar("user_id","4fe732c3-322e-4a6b-b729-2fd1eb5c6104")

metaData = http.QuickGetStr("https://graph.microsoft.com/v1.0/users/{$user_id}/drive/root:/{$item_path}")
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

json.EmitCompact = 0
success = json.Load(metaData)
outFile.WriteLine(json.Emit())

' Sample JSON metadata result:

' {
'   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('admin%40chilkat.io')/drive/root/$entity",
'   "@microsoft.graph.downloadUrl": "https://public.dm.files.1drv.com/y4mh0z_Og97O7Q...o2q1HhNBU",
'   "createdDateTime": "2017-06-04T20:40:22.48Z",
'   "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NzIuMjU3",
'   "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODcyLjY",
'   "id": "3A33FCEB9B74CC15!4872",
'   "lastModifiedDateTime": "2018-10-20T18:22:29.977Z",
'   "name": "penguins.jpg",
'   "size": 777835,
'   "webUrl": "https://1drv.ms/i/s!ABXMdJvr_DM6pgg",
'   "rating": {
'     "rating": 75,
'     "simpleRating": 4
'   },
'   "createdBy": {
'     "user": {
'       "displayName": "Joe Programmer",
'       "id": "3a33fceb9b74cc15"
'     }
'   },
'   "lastModifiedBy": {
'     "user": {
'       "displayName": "Joe Programmer",
'       "id": "3a33fceb9b74cc15"
'     }
'   },
'   "parentReference": {
'     "driveId": "3a33fceb9b74cc15",
'     "driveType": "personal",
'     "id": "3A33FCEB9B74CC15!4871",
'     "name": "wildlife",
'     "path": "/drive/root:/Misc/wildlife"
'   },
'   "file": {
'     "mimeType": "image/jpeg",
'     "hashes": {
'       "sha1Hash": "DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0"
'     }
'   },
'   "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"
'   },
'   "shared": {
'     "scope": "users",
'     "owner": {
'       "user": {
'         "displayName": "Joe Programmer",
'         "id": "3a33fceb9b74cc15"
'       }
'     }
'   }
' }
' 

' If the response status code was not 200, then it failed.
If (http.LastStatus <> 200) Then
    outFile.WriteLine("Response Status Code = " & http.LastStatus)
    outFile.WriteLine("Failed.")
    WScript.Quit
End If

' Demonstrate how to parse the JSON...

odata_context = json.StringOf("""@odata.context""")
microsoft_graph_downloadUrl = json.StringOf("""@microsoft.graph.downloadUrl""")
createdDateTime = json.StringOf("createdDateTime")
cTag = json.StringOf("cTag")
eTag = json.StringOf("eTag")
id = json.StringOf("id")
lastModifiedDateTime = json.StringOf("lastModifiedDateTime")
name = json.StringOf("name")
size = json.IntOf("size")
webUrl = json.StringOf("webUrl")
ratingRating = json.IntOf("rating.rating")
ratingSimpleRating = json.IntOf("rating.simpleRating")
createdByUserDisplayName = json.StringOf("createdBy.user.displayName")
createdByUserId = json.StringOf("createdBy.user.id")
lastModifiedByUserDisplayName = json.StringOf("lastModifiedBy.user.displayName")
lastModifiedByUserId = json.StringOf("lastModifiedBy.user.id")
parentReferenceDriveId = json.StringOf("parentReference.driveId")
parentReferenceDriveType = json.StringOf("parentReference.driveType")
parentReferenceId = json.StringOf("parentReference.id")
parentReferenceName = json.StringOf("parentReference.name")
parentReferencePath = json.StringOf("parentReference.path")
fileMimeType = json.StringOf("file.mimeType")
fileHashesSha1Hash = json.StringOf("file.hashes.sha1Hash")
fileSystemInfoCreatedDateTime = json.StringOf("fileSystemInfo.createdDateTime")
fileSystemInfoLastModifiedDateTime = json.StringOf("fileSystemInfo.lastModifiedDateTime")
imageHeight = json.IntOf("image.height")
imageWidth = json.IntOf("image.width")
photoTakenDateTime = json.StringOf("photo.takenDateTime")
sharedScope = json.StringOf("shared.scope")
sharedOwnerUserDisplayName = json.StringOf("shared.owner.user.displayName")
sharedOwnerUserId = json.StringOf("shared.owner.user.id")

outFile.Close