(Excel) List Google Photos Albums

Demonstrates how to get a list of Google Photos albums.

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")


Set resp = http.QuickRequest("GET","https://photoslibrary.googleapis.com/v1/albums")
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()

' {
'   "albums": [
'     {
'       "id": "AKcbugFJDPVIW3w4JMTV9hWpjnvK-iHkZwS_FRuIm_jtqektmP7bTpvx27eETfLHOZrSznkt0bR3",
'       "title": "April 23, 2016",
'       "productUrl": "https://photos.google.com/lr/album/AKcbugFJDPVIW3w4JMTV9hWpjnvK-iHkZwS_FRuIm_jtqektmP7bTpvx27eETfLHOZrSznkt0bR3",
'       "mediaItemsCount": "1",
'       "coverPhotoBaseUrl": "https://lh3.googleusercontent.com/lr/AGWb-e6L7ecrCQmp ... uXVvAoTeMwJg",
'       "coverPhotoMediaItemId": "AKcbugHEVyTFgIYb7GzhRFP5KvhBRIIsRcb6Cd4-2ByHzad2oqZnWF2aMPoXY-vfrXmefdTlyF3yZ22Odz6IFLs8pnJlOoVBUg"
'     },
'     {
'       "id": "AKcbugHJ4Zip9WHj_rpS9it133uu753VFffiNg9s0aapPSFAEzEwFxOuCG84OXYgJGclgnt1WqG1",
'       "title": "April 23, 2016",
'       "productUrl": "https://photos.google.com/lr/album/AKcbugHJ4Zip9WHj_rpS9it133uu753VFffiNg9s0aapPSFAEzEwFxOuCG84OXYgJGclgnt1WqG1",
'       "mediaItemsCount": "1",
'       "coverPhotoBaseUrl": "https://lh3.googleusercontent.com/lr/AGWb-e5h7xK6G_baGN6KuuBHG5veLD49Xiaiix0GuTjii ... 7rkIexZj3AAdCA",
'       "coverPhotoMediaItemId": "AKcbugHEVyTFgIYb7GzhRFP5KvhBRIIsRcb6Cd4-2ByHzad2oqZnWF2aMPoXY-vfrXmefdTlyF3yZ22Odz6IFLs8pnJlOoVBUg"
'     },
'     {
'       "id": "AKcbugHaQTvUKSi3M2RQxOhxhdEaLc5mfUcqFoIU_kpQaROyUD70BcFt7_mnz5PcwwsjPKeKnLHN",
'       "title": "animals",
'       "productUrl": "https://photos.google.com/lr/album/AKcbugHaQTvUKSi3M2RQxOhxhdEaLc5mfUcqFoIU_kpQaROyUD70BcFt7_mnz5PcwwsjPKeKnLHN",
'       "isWriteable": true,
'       "coverPhotoBaseUrl": "https://lh3.googleusercontent.com/mL8RRbd0pjFIhHc0A4En4y7ZftwyjZTSp5YWX5j1EyPxX5GepHML"
'     }
'   ]
' }

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

i = 0
count_i = json.SizeOfArray("albums")
Do While i < count_i
    json.I = i
    id = json.StringOf("albums[i].id")
    title = json.StringOf("albums[i].title")
    productUrl = json.StringOf("albums[i].productUrl")
    mediaItemsCount = json.StringOf("albums[i].mediaItemsCount")
    coverPhotoBaseUrl = json.StringOf("albums[i].coverPhotoBaseUrl")
    coverPhotoMediaItemId = json.StringOf("albums[i].coverPhotoMediaItemId")
    isWriteable = json.BoolOf("albums[i].isWriteable")
    i = i + 1
Loop