(Chilkat2-Python) Google Sheets Refresh an Expired Access Token

Demonstrates how to refresh an expired access token. If a Google Sheets REST API call results in a 401 "unauthorized" response, then it is likely the access token expired. An application should be able to automatically refresh the access token with no user interaction and then re-try the request with the newly obtained access token.

Chilkat2 Python Downloads install with pip pip3 install chilkat2 or download... Python Module for Windows, Linux, Alpine Linux, MacOS, Solaris

import sys
import chilkat2

# This example requires 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
# saved by this example: Get Google Sheets OAuth2 Access Token

jsonToken = chilkat2.JsonObject()
success = jsonToken.LoadFile("qa_data/tokens/googleSheets.json")
if (success != True):
    print("Failed to load googleSheets.json")
    sys.exit()

# The access token JSON looks like this:

# {
# "access_token": "abac.Ci-ZabcdF37-NUrmSzxbHxTsMbtlN-uPfabcdAQN_2ekzj0s5ofCzRabcdTDMGaa2Q",
# "token_type": "Bearer",
# "expires_in": 3600,
# "refresh_token": "1/lEe5abcdNJ77eOSDBabcdkQGVmDalkwabcdR2Hatbo"
# }
# 

oauth2 = chilkat2.OAuth2()

oauth2.TokenEndpoint = "https://www.googleapis.com/oauth2/v4/token"

# Replace these with actual values.
oauth2.ClientId = "GOOGLE-CLIENT-ID"
oauth2.ClientSecret = "GOOGLE-CLIENT-SECRET"

# Get the "refresh_token"
oauth2.RefreshToken = jsonToken.StringOf("refresh_token")

# Send the HTTP POST to refresh the access token..
success = oauth2.RefreshAccessToken()
if (success != True):
    print(oauth2.LastErrorText)
    sys.exit()

# The response contains a new access token, but we must keep
# our existing refresh token for when we need to refresh again in the future.
jsonToken.UpdateString("access_token",oauth2.AccessToken)

# Save the new JSON access token response to a file.
sbJson = chilkat2.StringBuilder()
jsonToken.EmitCompact = False
jsonToken.EmitSb(sbJson)
sbJson.WriteFile("qa_data/tokens/googleSheets.json","utf-8",False)

print("OAuth2 authorization granted!")
print("New Access Token = " + oauth2.AccessToken)