(Visual Basic 6.0) 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

' 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 New ChilkatJsonObject
Dim success As Long
success = jsonToken.LoadFile("qa_data/tokens/googlePhotos.json")
If (success = 0) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

Dim http As New ChilkatHttp

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

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

Dim resp As ChilkatHttpResponse
Set resp = http.QuickRequest("GET","https://photoslibrary.googleapis.com/v1/mediaItems?pageSize=100")
If (http.LastMethodSuccess = 0) 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 New ChilkatJsonObject
success = json.Load(resp.BodyStr)

' Sample response:
json.EmitCompact = 0
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

Dim i As Long
Dim count_i As Long
Dim id As String
Dim productUrl As String
Dim baseUrl As String
Dim mimeType As String
Dim mediaMetadataCreationTime As String
Dim mediaMetadataWidth As String
Dim mediaMetadataHeight As String
Dim mediaMetadataPhotoCameraMake As String
Dim mediaMetadataPhotoCameraModel As String
Dim mediaMetadataPhotoFocalLength As String
Dim mediaMetadataPhotoApertureFNumber As String
Dim mediaMetadataPhotoIsoEquivalent As Long
Dim filename As String
Dim description As String

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