(Excel) Isabel Connect Create First Access Token and Refresh Token

See more Ibanity Examples

Creates your first access token and refresh token. Once created, the refresh token can be used to get a new access token after it expires, or before it expires.

For more information, see https://documentation.ibanity.com/isabel-connect/api#create-refresh-token

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

' Implements the following CURL command:

' curl -X POST https://api.ibanity.com/isabel-connect/oauth2/token \
' --cert certificate.pem:qwertyuiop1 \
' --key private_key.pem  \
' -H "Content-Type: application/x-www-form-urlencoded" \
' -H "Accept: application/vnd.api+json" \
' -H "Ibanity-Idempotency-Key: af621a8f-f74b-41a2-b011-336997633df4"  \
' -d grant_type=authorization_code \
' -d code=valid_authorization_code \
' -d client_id=valid_client_id \
' -d client_secret=valid_client_secret \
' -d redirect_uri=https://fake-tpp.com 

' Ibanity provides the certificate + private key in PFX format.  This example will use the .pfx instead of the pair of PEM files.
' (It is also possible to implement using Chilkat with the PEM files, but PFX is easier.)
Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert

success = cert.LoadPfxFile("qa_data/pfx/my_ibanity_certificate.pfx","my_pfx_password")
If (success = False) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

success = http.SetSslClientCert(cert)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.Path = "/isabel-connect/oauth2/token"
req.ContentType = "application/x-www-form-urlencoded"
req.AddParam "grant_type","authorization_code"

' Note: For sandbox testing, we literally want to use the strings
' "valid_authorization_code", "valid_client_id", and "valid_client_secret".
' For the live app, you would replace these with actual values.
req.AddParam "code","valid_authorization_code"
req.AddParam "client_id","valid_client_id"
req.AddParam "client_secret","valid_client_secret"
req.AddParam "redirect_uri","https://fake-tpp.com"

req.AddHeader "Accept","application/vnd.api+json"

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2

idempotencyKey = crypt.GenerateUuid()
Debug.Print "Ibanity-Idempotency-Key: "; idempotencyKey
req.AddHeader "Ibanity-Idempotency-Key",idempotencyKey


Set resp = http.PostUrlEncoded("https://api.ibanity.com/isabel-connect/oauth2/token",req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
Dim success As Boolean
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "token_type": "Bearer",
'   "scope": "cloudconnect",
'   "refresh_token": "valid_refresh_token",
'   "expires_in": 1799,
'   "access_token": "access_token_1617371230"
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


token_type = jResp.StringOf("token_type")

scope = jResp.StringOf("scope")

refresh_token = jResp.StringOf("refresh_token")

expires_in = jResp.IntOf("expires_in")

access_token = jResp.StringOf("access_token")

' Save to a file for future use in refreshing the access token.
' The refresh token is the same each time we refresh to get a new access token.
success = jResp.WriteFile("qa_data/tokens/isabel_refresh_token.json")

' Also save to a file to be used as the current access token.
success = jResp.WriteFile("qa_data/tokens/isabel_access_token.json")