Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Xojo Plugin) Google Sheets Refresh an Expired Access TokenDemonstrates 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.
// 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 Dim jsonToken As New Chilkat.JsonObject Dim success As Boolean success = jsonToken.LoadFile("qa_data/tokens/googleSheets.json") If (success <> True) Then System.DebugLog("Failed to load googleSheets.json") Return End If // 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" // } // Dim oauth2 As New Chilkat.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) Then System.DebugLog(oauth2.LastErrorText) Return End If // 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. success = jsonToken.UpdateString("access_token",oauth2.AccessToken) // Save the new JSON access token response to a file. Dim sbJson As New Chilkat.StringBuilder jsonToken.EmitCompact = False success = jsonToken.EmitSb(sbJson) success = sbJson.WriteFile("qa_data/tokens/googleSheets.json","utf-8",False) System.DebugLog("OAuth2 authorization granted!") System.DebugLog("New Access Token = " + oauth2.AccessToken) |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.