(Excel) Okta: Refresh Access Token with the Auth Code Flow

Demonstrates how to refresh a token that was obtained using the authorization code flow.

For more information, see https://developer.okta.com/docs/guides/implement-auth-code-pkce/use-flow/

Download Excel Class Modules Chilkat Excel Class Modules

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

' See Get Okta Access Token using Authorization Code Flow with PKCE 
' for sample code showing how to obtain an Okta access token using the authorization code flow for native apps (with PKCE).

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

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

Dim oauth2 As Chilkat.OAuth2
Set oauth2 = Chilkat.NewOAuth2

oauth2.TokenEndpoint = "https://{yourOktaDomain}/oauth2/default/v1/token"

' Replace these with actual values.
oauth2.ClientId = "OKTA_CLIENT_ID"
oauth2.ClientSecret = "OKTA_CLIENT_SECRET"

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

' Send the HTTP POST to refresh the access token..
oauth2.VerboseLogging = True
success = oauth2.RefreshAccessToken()
If (success <> True) Then
    Debug.Print oauth2.LastErrorText
    Exit Sub
End If

' Load the access token response into the json object 
success = jsonToken.Load(oauth2.AccessTokenResponse)

' Save the new JSON access token response to a file.
' The access + refresh tokens contained in this JSON will be needed for the next refresh.
Dim sbJson As Chilkat.StringBuilder
Set sbJson = Chilkat.NewStringBuilder
jsonToken.EmitCompact = False
success = jsonToken.EmitSb(sbJson)
success = sbJson.WriteFile("qa_data/tokens/okta.json","utf-8",False)

Debug.Print "OAuth2 authorization granted!"
Debug.Print "New Access Token = "; oauth2.AccessToken