(Excel) Check PayPal Access Token Expiration

Checks to see if the PayPal access token expired.

Download Excel Class Modules Chilkat Excel Class Modules

' Note: Requires Chilkat v9.5.0.64 or greater.

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

' In the example linked here: PayPal OAuth2 Token,
' we fetched a PayPal access token and saved it to a JSON file.
' We also recorded the current date/time.
' Load this JSON file and compare the current date/time with the fetch date/time
' and the "expires_in" value to see if the token is expired.

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

success = json.LoadFile("qa_data/tokens/paypal.json")
If (success <> True) Then
    Debug.Print "Failed to load access key json file."
    Exit Sub
End If

' Get the current date/time.
Dim dateTime As Chilkat.CkDateTime
Set dateTime = Chilkat.NewCkDateTime

bLocalTime = False

dtNow = dateTime.GetAsUnixTime(bLocalTime)

' Get the access token create date/time

dtCreate = json.IntOf("tokenCreateTimeUtc")

' Find out how many seconds have elapsed.

numSeconds = dtNow - dtCreate

' Get the expires_in value from the JSON.

expires_in = json.IntOf("expires_in")

Debug.Print "token age (in seconds) = "; numSeconds
Debug.Print "expires_in = "; expires_in

' If the token expired, or if it will expire in 5 minutes or less,
' get another token.
If (numSeconds < (expires_in - 300)) Then
    Debug.Print "The token is not yet expired.  No need to fetch another."
    Exit Sub
End If

Debug.Print "Time to fetch a new access token..."

' Get another token..
' See the example at Get PayPal OAuth2 Token
' to get another token..