(Excel) Retrieve the metadata for a DriveItem

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

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Use your previously obtained access token here:
' See the following examples for getting an access token:
'    Get Microsoft Graph OAuth2 Access Token (Azure AD v2.0 Endpoint).
'    Get Microsoft Graph OAuth2 Access Token (Azure AD Endpoint).
'    Refresh Access Token (Azure AD v2.0 Endpoint).
'    Refresh Access Token (Azure AD Endpoint).

' (Make sure your token was obtained with the FilesRead or Files.ReadWrite scope.)
http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

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

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

' This example will get the metadata for /Misc/wildlife/penguins.jpg
Dim success As Boolean
success = http.SetUrlVar("item_path","Misc/wildlife/penguins.jpg")


metaData = http.QuickGetStr("https://graph.microsoft.com/v1.0/me/drive/root:/{$item_path}")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False

success = json.Load(metaData)
Debug.Print 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
    Debug.Print "Response Status Code = "; http.LastStatus
    Debug.Print "Failed."
    Exit Sub
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")