(Excel) Google OAuth2 v3 userinfo (https://www.googleapis.com/oauth2/v3/userinfo)

Demonstrates how to get the Google OAuth2 v3 userinfo.

Important: Make sure the OAuth2 access token included "profile" in the list of scopes.

Download Excel Class Modules Chilkat Excel Class Modules

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

' It is assumed we previously obtained an OAuth2 access token.
' This example loads the JSON access token file 
' originally obtained by this example: Get Google People API OAuth2 Access Token
' or refreshed by this example: Refresh Google People API OAuth2 Access Token

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

success = jsonToken.LoadFile("qa_data/tokens/googlePeople.json")
If (success <> True) Then
    Debug.Print "Failed to load googleContacts.json"
    Exit Sub
End If

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

' -------------------------------------------------------------------------------------
' Make sure the access token was obtained with "profile" included in the list of scopes.
' -------------------------------------------------------------------------------------
http.AuthToken = jsonToken.StringOf("access_token")

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = http.QuickGetSb("https://www.googleapis.com/oauth2/v3/userinfo",sbResponseBody)
If (success = False) Then
    Debug.Print http.LastErrorText
    Debug.Print sbResponseBody.GetAsString()
    Exit Sub
End If

' Sample JSON Response

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False
Dim success As Boolean
success = json.Load(sbResponseBody.GetAsString())
Debug.Print json.Emit()

' Sample response:

' {
'   "sub": "119999690625687999964",
'   "name": "Matt",
'   "given_name": "Matt",
'   "picture": "https://lh3.googleusercontent.com/-b4...eg3Zjo/AAAAAAAAAAI/AAAAAAAAAAA/AMZuu....3RpdA/s96-c/photo.jpg",
'   "locale": "en"
' }
'