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
(Chilkat2-Python) Get a Google Sheets OAuth2 Access TokenDemonstrates how to get a Google Sheets OAuth2 access token from a desktop application or script.
import sys import chilkat2 # This example requires the Chilkat API to have been previously unlocked. # See Global Unlock Sample for sample code. oauth2 = chilkat2.OAuth2() # For Google OAuth2, set the listen port equal to the port used # in the Authorized Redirect URL for the Client ID. # For example, in this case the Authorized Redirect URL would be http://localhost:55568/ # Your app should choose a port not likely not used by any other application. oauth2.ListenPort = 55568 oauth2.AuthorizationEndpoint = "https://accounts.google.com/o/oauth2/v2/auth" oauth2.TokenEndpoint = "https://www.googleapis.com/oauth2/v4/token" # Replace these with actual values. oauth2.ClientId = "GOOGLE-CLIENT-ID" oauth2.ClientSecret = "GOOGLE-CLIENT-SECRET" oauth2.CodeChallenge = True oauth2.CodeChallengeMethod = "S256" # These are the scopes for Google Sheets: # https://www.googleapis.com/auth/spreadsheets read/write access to spreadsheets # https://www.googleapis.com/auth/spreadsheets.readonly read-only access to spreadsheets oauth2.Scope = "https://www.googleapis.com/auth/spreadsheets" # Begin the OAuth2 three-legged flow. This returns a URL that should be loaded in a browser. url = oauth2.StartAuth() if (oauth2.LastMethodSuccess != True): print(oauth2.LastErrorText) sys.exit() # At this point, your application should load the URL in a browser. # For example, # in C#: System.Diagnostics.Process.Start(url); # in Java: Desktop.getDesktop().browse(new URI(url)); # in VBScript: Set wsh=WScript.CreateObject("WScript.Shell") # wsh.Run url # in Xojo: ShowURL(url) (see http://docs.xojo.com/index.php/ShowURL) # in Dataflex: Runprogram Background "c:\Program Files\Internet Explorer\iexplore.exe" sUrl # The QuickBooks account owner would interactively accept or deny the authorization request. # Add the code to load the url in a web browser here... # Add the code to load the url in a web browser here... # Add the code to load the url in a web browser here... # Now wait for the authorization. # We'll wait for a max of 30 seconds. numMsWaited = 0 while (numMsWaited < 30000) and (oauth2.AuthFlowState < 3) : oauth2.SleepMs(100) numMsWaited = numMsWaited + 100 # If there was no response from the browser within 30 seconds, then # the AuthFlowState will be equal to 1 or 2. # 1: Waiting for Redirect. The OAuth2 background thread is waiting to receive the redirect HTTP request from the browser. # 2: Waiting for Final Response. The OAuth2 background thread is waiting for the final access token response. # In that case, cancel the background task started in the call to StartAuth. if (oauth2.AuthFlowState < 3): oauth2.Cancel() print("No response from the browser!") sys.exit() # Check the AuthFlowState to see if authorization was granted, denied, or if some error occurred # The possible AuthFlowState values are: # 3: Completed with Success. The OAuth2 flow has completed, the background thread exited, and the successful JSON response is available in AccessTokenResponse property. # 4: Completed with Access Denied. The OAuth2 flow has completed, the background thread exited, and the error JSON is available in AccessTokenResponse property. # 5: Failed Prior to Completion. The OAuth2 flow failed to complete, the background thread exited, and the error information is available in the FailureInfo property. if (oauth2.AuthFlowState == 5): print("OAuth2 failed to complete.") print(oauth2.FailureInfo) sys.exit() if (oauth2.AuthFlowState == 4): print("OAuth2 authorization was denied.") print(oauth2.AccessTokenResponse) sys.exit() if (oauth2.AuthFlowState != 3): print("Unexpected AuthFlowState:" + str(oauth2.AuthFlowState)) sys.exit() # Save the full JSON access token response to a file. sbJson = chilkat2.StringBuilder() sbJson.Append(oauth2.AccessTokenResponse) sbJson.WriteFile("qa_data/tokens/googleSheets.json","utf-8",False) # The saved JSON response looks like this: # { # "access_token": "ya39.Ci-XA_C5bGgRDC3UaD-h0_NeL-DVIQnI2gHtBBBHkZzrwlARkwX6R3O0PCDEzRlfaQ", # "token_type": "Bearer", # "expires_in": 3600, # "refresh_token": "1/r_2c_7jddspcdfesrrfKqfXtqo08D6Q-gUU0DsdfVMsx0c" # } # print("OAuth2 authorization granted!") print("Access Token = " + oauth2.AccessToken) |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.