(Excel) Google Photos List Media Items

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

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.

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

Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/googlePhotos.json")
If (success = False) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

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

http.AuthToken = jsonToken.StringOf("access_token")

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


Set resp = http.QuickRequest("GET","https://photoslibrary.googleapis.com/v1/mediaItems?pageSize=100")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Examine the response status code.  Success is indicated by a status code of 200.
Debug.Print "response status code: "; resp.StatusCode

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(resp.BodyStr)

' Sample response:
json.EmitCompact = False
Debug.Print 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
count_i = json.SizeOfArray("mediaItems")
Do While i < count_i
    json.I = i
    id = json.StringOf("mediaItems[i].id")
    productUrl = json.StringOf("mediaItems[i].productUrl")
    baseUrl = json.StringOf("mediaItems[i].baseUrl")
    mimeType = json.StringOf("mediaItems[i].mimeType")
    mediaMetadataCreationTime = json.StringOf("mediaItems[i].mediaMetadata.creationTime")
    mediaMetadataWidth = json.StringOf("mediaItems[i].mediaMetadata.width")
    mediaMetadataHeight = json.StringOf("mediaItems[i].mediaMetadata.height")
    mediaMetadataPhotoCameraMake = json.StringOf("mediaItems[i].mediaMetadata.photo.cameraMake")
    mediaMetadataPhotoCameraModel = json.StringOf("mediaItems[i].mediaMetadata.photo.cameraModel")
    mediaMetadataPhotoFocalLength = json.StringOf("mediaItems[i].mediaMetadata.photo.focalLength")
    mediaMetadataPhotoApertureFNumber = json.StringOf("mediaItems[i].mediaMetadata.photo.apertureFNumber")
    mediaMetadataPhotoIsoEquivalent = json.IntOf("mediaItems[i].mediaMetadata.photo.isoEquivalent")
    filename = json.StringOf("mediaItems[i].filename")
    description = json.StringOf("mediaItems[i].description")
    i = i + 1
Loop