PowerBuilder
PowerBuilder
Get File Metadata
See more Google Drive Examples
Gets a file's metadata or content by ID.See Google Drive Files get for additional details.
Chilkat PowerBuilder Downloads
integer li_rc
long li_Success
oleobject loo_GAuth
oleobject loo_Rest
long li_BAutoReconnect
oleobject loo_SbPath
string ls_AllFields
string ls_JsonResponse
oleobject loo_Json
long li_WasLastModifiedUserMe
long li_Width
long i
long li_NumParents
long li_NumOwners
long li_NumPermissions
li_Success = 0
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
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
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
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
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