Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

Excel Examples

Web API Categories

ASN.1
Amazon EC2
Amazon Glacier
Amazon S3
Amazon S3 (new)
Amazon SES
Amazon SNS
Amazon SQS
Azure Cloud Storage
Azure Service Bus
Azure Table Service
Base64
Bounced Email
Box
CAdES
CSR
CSV
Certificates
Compression
DKIM / DomainKey
DSA
Diffie-Hellman
Digital Signatures
Dropbox
Dynamics CRM
EBICS
ECC
Ed25519
Email Object
Encryption
FTP
FileAccess
Firebase
GMail REST API
GMail SMTP/IMAP/POP
Geolocation
Google APIs
Google Calendar
Google Cloud SQL
Google Cloud Storage
Google Drive
Google Photos
Google Sheets
Google Tasks
Gzip
HTML-to-XML/Text
HTTP

HTTP Misc
IMAP
JSON
JSON Web Encryption (JWE)
JSON Web Signatures (JWS)
JSON Web Token (JWT)
Java KeyStore (JKS)
MHT / HTML Email
MIME
MS Storage Providers
Microsoft Graph
NTLM
OAuth1
OAuth2
OIDC
Office365
OneDrive
OpenSSL
Outlook
Outlook Calendar
Outlook Contact
PDF Signatures
PEM
PFX/P12
PKCS11
POP3
PRNG
REST
REST Misc
RSA
SCP
SCard
SFTP
SMTP
SSH
SSH Key
SSH Tunnel
ScMinidriver
SharePoint
Socket/SSL/TLS
Spider
Stream
Tar Archive
Upload
WebSocket
XAdES
XML
XML Digital Signatures
XMP
Zip
curl

 

 

 

(Excel) Get XOAUTH2 Access Token from Google OAuth 2.0 Authorization Server

Obtains an OAUTH2 access token from the Google OAuth 2.0 Authorization Server. This is for Server to server applications using Google API's that need an access token. See https://developers.google.com/accounts/docs/OAuth2ServiceAccount

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.

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

' When a service account (Client ID) is created at https://code.google.com/apis/console/
' Google will generate a P12 key.  This is a PKCS12 (PFX) file that you will download
' and save.  The password to access the contents of this file is "notasecret".
' NOTE: The Chilkat Pfx API provides the ability to load a PFX/P12 and re-save
' with a different password.

' Begin by loading the downloaded .p12 into a Chilkat certificate object:
Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert

success = cert.LoadPfxFile("/myDir/API Project-1c43a291e2a1-notasecret.p12","notasecret")
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' The next (and final) step is to request the access token.  Chilkat internally
' does all the work of forming the JWT header and JWT claim set, encoding and
' signing the JWT, and sending the access token request.
' The application need only provide the inputs: The iss, scope(s), sub, and the
' desired duration with a max of 3600 seconds (1 hour).
' 
' Each of these inputs is defined as follows 
' (see https://developers.google.com/accounts/docs/OAuth2ServiceAccount
' 
' iss: The email address of the service account.
' 
' scope: A space-delimited list of the permissions that the application requests.
' 
' sub: required if there is an email address, such as for a
'   Google Apps domain—if you use Google Apps for Work, where the administrator of the Google Apps domain 
'   can authorize an application to access user data on behalf of users in the Google Apps domain.
' 
' numSec: The number of seconds for which the access token will be valid (max 3600).


iss = "761326798069-r5mljlln1rd4lrbhg75efgigp36m78j5@developer.gserviceaccount.com"

scope = "https://mail.google.com/"
' Leave "sub" empty if there is no Google Apps email.

sub = ""

numSec = 3600


accessToken = http.G_SvcOauthAccessToken(iss,scope,sub,numSec,cert)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
Else
    Debug.Print "access token: "; accessToken
End If


 

© 2000-2022 Chilkat Software, Inc. All Rights Reserved.