(PowerBuilder) Get File Metadata

Gets a file's metadata or content by ID.

See Google Drive Files get for additional details.

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

integer li_rc
integer li_Success
oleobject loo_GAuth
oleobject loo_Rest
integer li_BAutoReconnect
oleobject loo_SbPath
string ls_AllFields
string ls_JsonResponse
oleobject loo_Json
integer li_WasLastModifiedUserMe
integer li_Width
integer i
integer li_NumParents
integer li_NumOwners
integer li_NumPermissions

li_Success = 1

// It requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

// This example uses a previously obtained access token having permission for the 
// Google Drive scope.

loo_GAuth = create oleobject
// Use "Chilkat_9_5_0.AuthGoogle" for versions of Chilkat < 10.0.0
li_rc = loo_GAuth.ConnectToNewObject("Chilkat.AuthGoogle")
if li_rc < 0 then
    destroy loo_GAuth
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_GAuth.AccessToken = "GOOGLE-DRIVE-ACCESS-TOKEN"

loo_Rest = create oleobject
// Use "Chilkat_9_5_0.Rest" for versions of Chilkat < 10.0.0
li_rc = loo_Rest.ConnectToNewObject("Chilkat.Rest")

// Connect using TLS.
// A single REST object, once connected, can be used for many Google Drive REST API calls.
// The auto-reconnect indicates that if the already-established HTTPS connection is closed,
// then it will be automatically re-established as needed.
li_BAutoReconnect = 1
li_Success = loo_Rest.Connect("www.googleapis.com",443,1,li_BAutoReconnect)

// Provide the authentication credentials (i.e. the access token)
loo_Rest.SetAuthGoogle(loo_GAuth)

// ------------------------------------------------------------------------------

// We need to send a GET request like this:
// GET https://www.googleapis.com/drive/v3/files/fileId
// The fileId is part of the path.
loo_SbPath = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbPath.ConnectToNewObject("Chilkat.StringBuilder")

loo_SbPath.Append("/drive/v3/files/")
// Assume we previously obtained the fileId for the file of interest...
loo_SbPath.Append("0B53Q6OSTWYolbUF6WS1Gei1oalk")

// Indicate that we want ALL possible fields.
// If no fields are indicated, then only the basic fields are returned.
ls_AllFields = "appProperties,capabilities,contentHints,createdTime,description,explicitlyTrashed,fileExtension,folderColorRgb,fullFileExtension,headRevisionId,iconLink,id,imageMediaMetadata,isAppAuthorized,kind,lastModifyingUser,md5Checksum,mimeType,modifiedByMeTime,modifiedTime,name,originalFilename,ownedByMe,owners,parents,permissions,properties,quotaBytesUsed,shared,sharedWithMeTime,sharingUser,size,spaces,starred,thumbnailLink,trashed,version,videoMediaMetadata,viewedByMe,viewedByMeTime,viewersCanCopyContent,webContentLink,webViewLink,writersCanShare"

loo_Rest.AddQueryParam("fields",ls_AllFields)

ls_JsonResponse = loo_Rest.FullRequestNoBody("GET",loo_SbPath.GetAsString())
if loo_Rest.LastMethodSuccess <> 1 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_GAuth
    destroy loo_Rest
    destroy loo_SbPath
    return
end if

// A successful response will have a status code equal to 200.
if loo_Rest.ResponseStatusCode <> 200 then
    Write-Debug "response status code = " + string(loo_Rest.ResponseStatusCode)
    Write-Debug "response status text = " + loo_Rest.ResponseStatusText
    Write-Debug "response header: " + loo_Rest.ResponseHeader
    Write-Debug "response JSON: " + ls_JsonResponse
    destroy loo_GAuth
    destroy loo_Rest
    destroy loo_SbPath
    return
end if

// ---------------------------------------------------
// Sample code for parsing this JSON is shown below...
// ---------------------------------------------------

// A successful response looks like this:
// {
//   "kind": "drive#file",
//   "id": "0B53Q6OSTWYolbUF6WS1Gei1oalk",
//   "name": "penguins.jpg",
//   "mimeType": "image/jpeg",
//   "starred": false,
//   "trashed": false,
//   "explicitlyTrashed": false,
//   "parents": [
//     "0B53Q6OSTWYola296ODZUSm5GYU0"
//   ],
//   "spaces": [
//     "drive"
//   ],
//   "version": "672",
//   "webContentLink": "https://docs.google.com/a/chilkatcloud.com/uc?id=0B53Q6OSTWYolbUF6WS1Gei1oalk&export=download",
//   "webViewLink": "https://drive.google.com/a/chilkatcloud.com/file/d/0B53Q6OSTWYolbUF6WS1Gei1oalk/view?usp=drivesdk",
//   "iconLink": "https://ssl.gstatic.com/docs/doclist/images/icon_11_image_list.png",
//   "thumbnailLink": "https://lh5.googleusercontent.com/uIV1dJdc8vsAQzaaIInpc9AV55AcdHhpM7fQeI2RN2qbCSnhjK9IDdNQAOTtkvjS9ZObqw=s220",
//   "viewedByMe": true,
//   "viewedByMeTime": "2016-10-08T12:38:02.258Z",
//   "createdTime": "2016-10-08T12:38:02.258Z",
//   "modifiedTime": "2016-10-08T12:38:02.258Z",
//   "modifiedByMeTime": "2016-10-08T12:38:02.258Z",
//   "owners": [
//     {
//       "kind": "drive#user",
//       "displayName": "Matthew Smith",
//       "me": true,
//       "permissionId": "08366696655122259092",
//       "emailAddress": "support@chilkatcloud.com"
//     }
//   ],
//   "lastModifyingUser": {
//     "kind": "drive#user",
//     "displayName": "Matthew Smith",
//     "me": true,
//     "permissionId": "08366696655122259092",
//     "emailAddress": "support@chilkatcloud.com"
//   },
//   "shared": false,
//   "ownedByMe": true,
//   "capabilities": {
//     "canEdit": true,
//     "canComment": true,
//     "canShare": true,
//     "canCopy": true,
//     "canReadRevisions": true
//   },
//   "viewersCanCopyContent": true,
//   "writersCanShare": true,
//   "permissions": [
//     {
//       "kind": "drive#permission",
//       "id": "08366696655122259092",
//       "type": "user",
//       "emailAddress": "support@chilkatcloud.com",
//       "role": "owner",
//       "displayName": "Matthew Smith"
//     }
//   ],
//   "originalFilename": "penguins.jpg",
//   "fullFileExtension": "jpg",
//   "fileExtension": "jpg",
//   "md5Checksum": "9d377b10ce778c4938b3c7e2c63a229a",
//   "size": "777835",
//   "quotaBytesUsed": "777835",
//   "headRevisionId": "0B53Q6OSTWYolUUlHVFhHdFlXQ0R1aHZuT0tORTVzc2h5NnZjPQ",
//   "imageMediaMetadata": {
//     "width": 1024,
//     "height": 768,
//     "rotation": 0,
//     "time": "2009:03:12 13:48:35"
//   },
//   "isAppAuthorized": false
// }

// Iterate over each file in the response and show the name, id, and mimeType.
loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.Load(ls_JsonResponse)

// Show the full JSON response.
loo_Json.EmitCompact = 0
Write-Debug loo_Json.Emit()
Write-Debug "-"

// Demonstrate how to get pieces of information:
Write-Debug "Original Filename: " + loo_Json.StringOf("originalFilename")

li_WasLastModifiedUserMe = loo_Json.BoolOf("lastModifyingUser.me")
Write-Debug "Was Last Modified by Me: " + string(li_WasLastModifiedUserMe)

// Assuming this is an image file...
li_Width = loo_Json.IntOf("imageMediaMetadata.width")
Write-Debug "Image Width: " + string(li_Width)

// Iterate over parents...

li_NumParents = loo_Json.SizeOfArray("parents")
i = 0
do while i < li_NumParents
    loo_Json.I = i
    Write-Debug "Parent " + string(i) + ": " + loo_Json.StringOf("parents[i]")
    i = i + 1
loop

// Iterate over owners...
li_NumOwners = loo_Json.SizeOfArray("owners")
i = 0
do while i < li_NumOwners
    loo_Json.I = i
    Write-Debug "Owner " + string(i) + ": kind=" + loo_Json.StringOf("owners[i].kind") + " displayName=" + loo_Json.StringOf("owners[i].displayName")
    i = i + 1
loop

// Iterate over permissions...
li_NumPermissions = loo_Json.SizeOfArray("permissions")
i = 0
do while i < li_NumPermissions
    loo_Json.I = i
    Write-Debug "Permission " + string(i) + ": kind=" + loo_Json.StringOf("permissions[i].kind") + " id=" + loo_Json.StringOf("permissions[i].id")
    i = i + 1
loop


destroy loo_GAuth
destroy loo_Rest
destroy loo_SbPath
destroy loo_Json