(PowerBuilder) Google Photos List Media Items

List all media items from a user's Google Photos library.

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

integer li_rc
oleobject loo_JsonToken
integer li_Success
oleobject loo_Http
oleobject loo_Resp
oleobject loo_Json
integer i
integer li_Count_i
string ls_Id
string ls_ProductUrl
string ls_BaseUrl
string ls_MimeType
string ls_MediaMetadataCreationTime
string ls_MediaMetadataWidth
string ls_MediaMetadataHeight
string ls_MediaMetadataPhotoCameraMake
string ls_MediaMetadataPhotoCameraModel
string ls_MediaMetadataPhotoFocalLength
string ls_MediaMetadataPhotoApertureFNumber
integer li_MediaMetadataPhotoIsoEquivalent
string ls_Filename
string ls_Description

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

// Get the previously obtained access token.
// See Get Google Photos Access Token.

loo_JsonToken = create oleobject
li_rc = loo_JsonToken.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
if li_rc < 0 then
    destroy loo_JsonToken
    MessageBox("Error","Connecting to COM object failed")
    return
end if
li_Success = loo_JsonToken.LoadFile("qa_data/tokens/googlePhotos.json")
if li_Success = 0 then
    Write-Debug loo_JsonToken.LastErrorText
    destroy loo_JsonToken
    return
end if

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.Http")

loo_Http.AuthToken = loo_JsonToken.StringOf("access_token")

// For more information, see Google Photos List Media Items API Documentation

loo_Resp = loo_Http.QuickRequest("GET","https://photoslibrary.googleapis.com/v1/mediaItems?pageSize=100")
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_JsonToken
    destroy loo_Http
    return
end if

// Examine the response status code.  Success is indicated by a status code of 200.
Write-Debug "response status code: " + string(loo_Resp.StatusCode)

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")

loo_Json.Load(loo_Resp.BodyStr)
destroy loo_Resp

// Sample response:
loo_Json.EmitCompact = 0
Write-Debug loo_Json.Emit()

// (See parsing code below...)

// {
//   "mediaItems": [
//     {
//       "id": "AKcbugGCOVK46E2qq6tv_wEuQuoK_a0iHet9rGH0-UWoZFnTMpEZ2jNjHWggz7Aq3hhjJv4YJsDY6ntowKsvnfnr1Bu3ASnS_w",
//       "productUrl": "https://photos.google.com/lr/photo/AKcbugGCOVK46E2qq6tv_wEuQuoK_a0iHet9rGH0-UWoZFnTMpEZ2jNjHWggz7Aq3hhjJv4YJsDY6ntowKsvnfnr1Bu3ASnS_w",
//       "baseUrl": "https://lh3.googleusercontent.com/lr/AGWb-e7ZcHJhUmxO8EgRSBFyBaGAyXE...YMWCAMDlNTA6-L5LiijXAUfKgD1ULhr9IabJBGTT7ETUdeeFTQTM",
//       "mimeType": "image/jpeg",
//       "mediaMetadata": {
//         "creationTime": "2019-04-11T17:55:53Z",
//         "width": "640",
//         "height": "480",
//         "photo": {
//           "cameraMake": "Apple",
//           "cameraModel": "iPhone 5s",
//           "focalLength": 4.15,
//           "apertureFNumber": 2.2,
//           "isoEquivalent": 32
//         }
//       },
//       "filename": "IMG_1206.JPG"
//     },
//     {
//       "id": "AKcbugFACWDNCQJ2nwhDemR6vRupHSvOUSKukyOHqTWO1CCIs0qw-C0b5MGmrveyjYe8ps8z1rZTRQ8hmSQsODSsobNqDl8vTg",
//       "productUrl": "https://photos.google.com/lr/photo/AKcbugFACWDNCQJ2nwhDemR6vRupHSvOUSKukyOHqTWO1CCIs0qw-C0b5MGmrveyjYe8ps8z1rZTRQ8hmSQsODSsobNqDl8vTg",
//       "baseUrl": "https://lh3.googleusercontent.com/lr/AGWb-e7NQe0qdoZrDHkfkK7LOsw-V...YJ1mrohD5duHsY2QJCzLTXZ65EOUrJefars3xDSwsCYlelY470kk",
//       "mimeType": "image/jpeg",
//       "mediaMetadata": {
//         "creationTime": "2016-10-09T01:49:58Z",
//         "width": "600",
//         "height": "427",
//         "photo": {}
//       },
//       "filename": "hedgehogs.jpg"
//     },
//     {
//       "id": "AKcbugHEVyTFgIYb7GzhRFP5KvhBRIIsRcb6Cd4-2ByHzad2oqZnWF2aMPoXY-vfrXmefdTlyF3yZ22Odz6IFLs8pnJlOoVBUg",
//       "productUrl": "https://photos.google.com/lr/photo/AKcbugHEVyTFgIYb7GzhRFP5KvhBRIIsRcb6Cd4-2ByHzad2oqZnWF2aMPoXY-vfrXmefdTlyF3yZ22Odz6IFLs8pnJlOoVBUg",
//       "baseUrl": "https://lh3.googleusercontent.com/lr/AGWb-e64wP9gpPXKq5b8FCFKzu9C...QTFxMLVRaLeQZBvYGZVIe7xCcRPnRhMpiXwL_RV_aU",
//       "mimeType": "image/jpeg",
//       "mediaMetadata": {
//         "creationTime": "2015-09-21T20:30:02Z",
//         "width": "59",
//         "height": "69",
//         "photo": {}
//       },
//       "filename": "chilkat_gravatar.jpg"
//     },
//     {
//       "id": "AKcbugHdYTp-S-D_EYnSBA4EhrKT86IFbmdRuiDclKka9T5b6UIbeDvhTAu1bebYOCFKH-gv1ME1z6RyMN4eW_9J5ol9_qizMg",
//       "productUrl": "https://photos.google.com/lr/photo/AKcbugHdYTp-S-D_EYnSBA4EhrKT86IFbmdRuiDclKka9T5b6UIbeDvhTAu1bebYOCFKH-gv1ME1z6RyMN4eW_9J5ol9_qizMg",
//       "baseUrl": "https://lh3.googleusercontent.com/lr/AGWb-e4e69WQpYcQX...m87rR6gDBhcB55TL__3ckBYNQ8MjbqpBtmojjYWrLG_j4VsVSA",
//       "mimeType": "image/jpeg",
//       "mediaMetadata": {
//         "creationTime": "2008-05-29T15:30:55Z",
//         "width": "120",
//         "height": "120",
//         "photo": {}
//       },
//       "filename": "starfish.jpg"
//     },
//     {
//       "id": "AKcbugGwtCih2tdl3s1-NMvZFaco3W7XnRwvwtj02J9DJyl6JmrLZDVUFcxQl4AT04LaNrPpsrojeTsDSzOVOF5IgKefD0Y-MQ",
//       "description": "Photo of Penguins",
//       "productUrl": "https://photos.google.com/lr/photo/AKcbugGwtCih2tdl3s1-NMvZFaco3W7XnRwvwtj02J9DJyl6JmrLZDVUFcxQl4AT04LaNrPpsrojeTsDSzOVOF5IgKefD0Y-MQ",
//       "baseUrl": "https://lh3.googleusercontent.com/lr/AGWb-e5Cj3EgyhscdT...X3-W562iiKtTa8lc_QPxCrpJu-m7cZyNGwGTANVpGe1XG",
//       "mimeType": "image/jpeg",
//       "mediaMetadata": {
//         "creationTime": "2008-02-18T05:07:31Z",
//         "width": "1024",
//         "height": "768",
//         "photo": {}
//       },
//       "filename": "penguins.jpg"
//     }
//   ]
// }
// 

// Use this online tool to generate parsing code from sample JSON: 
// Generate Parsing Code from JSON

i = 0
li_Count_i = loo_Json.SizeOfArray("mediaItems")
do while i < li_Count_i
    loo_Json.I = i
    ls_Id = loo_Json.StringOf("mediaItems[i].id")
    ls_ProductUrl = loo_Json.StringOf("mediaItems[i].productUrl")
    ls_BaseUrl = loo_Json.StringOf("mediaItems[i].baseUrl")
    ls_MimeType = loo_Json.StringOf("mediaItems[i].mimeType")
    ls_MediaMetadataCreationTime = loo_Json.StringOf("mediaItems[i].mediaMetadata.creationTime")
    ls_MediaMetadataWidth = loo_Json.StringOf("mediaItems[i].mediaMetadata.width")
    ls_MediaMetadataHeight = loo_Json.StringOf("mediaItems[i].mediaMetadata.height")
    ls_MediaMetadataPhotoCameraMake = loo_Json.StringOf("mediaItems[i].mediaMetadata.photo.cameraMake")
    ls_MediaMetadataPhotoCameraModel = loo_Json.StringOf("mediaItems[i].mediaMetadata.photo.cameraModel")
    ls_MediaMetadataPhotoFocalLength = loo_Json.StringOf("mediaItems[i].mediaMetadata.photo.focalLength")
    ls_MediaMetadataPhotoApertureFNumber = loo_Json.StringOf("mediaItems[i].mediaMetadata.photo.apertureFNumber")
    li_MediaMetadataPhotoIsoEquivalent = loo_Json.IntOf("mediaItems[i].mediaMetadata.photo.isoEquivalent")
    ls_Filename = loo_Json.StringOf("mediaItems[i].filename")
    ls_Description = loo_Json.StringOf("mediaItems[i].description")
    i = i + 1
loop


destroy loo_JsonToken
destroy loo_Http
destroy loo_Json