(Excel) ABN AMRO Create Signed JSON Web Token

Demonstrates how to create a signed JWT to be used for authenticating requests to the ABN AMRO REST API's.

For more information, see https://developer.abnamro.com/get-started#headingFive

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.

' Create public/private key pair (RSA)
Dim rsa As Chilkat.Rsa
Set rsa = Chilkat.NewRsa

' Generate a 2048-bit key.

success = rsa.GenerateKey(2048)
If (success <> True) Then
    Debug.Print rsa.LastErrorText
    Exit Sub
End If

' Export the key to PEM files.
' Write one PEM file for the private key, and one for the public key.

Set privkey = rsa.ExportPrivateKeyObj()
success = privkey.SavePemFile("qa_data/pem/abnAmroPrivateKey.pem")


Set pubkey = rsa.ExportPublicKeyObj()
success = pubkey.SavePemFile(True,"qa_data/pem/abnAmroPublicKey.pem")
' Note: Please share your public key along with your app name and developer email id at api.support@nl.abnamro.com. 
' Token generation will not work unless public key is associated with your app.

' Create the JWT.
Dim jwt As Chilkat.Jwt
Set jwt = Chilkat.NewJwt

' Create the header:
' {
'     "typ": "JWT",
'     "alg": "RS256"
' }
Dim jsonHeader As Chilkat.JsonObject
Set jsonHeader = Chilkat.NewJsonObject
Dim success As Boolean
success = jsonHeader.UpdateString("typ","JWT")
success = jsonHeader.UpdateString("alg","RS256")

' Create the payload:
' {
'     "nbf": 1499947668,
'     "exp": 1499948668,
'     "iss": "me",
'     "sub": "anApiKey",
'     "aud": "https://auth-sandbox.abnamro.com/oauth/token"
' }
Dim jsonPayload As Chilkat.JsonObject
Set jsonPayload = Chilkat.NewJsonObject


curDateTime = jwt.GenNumericDate(0)

' Set the "not process before" timestamp to now.
success = jsonPayload.AddIntAt(-1,"nbf",curDateTime)

' Set the timestamp defining an expiration time (end time) for the token
' to be now + 1 hour (3600 seconds)
success = jsonPayload.AddIntAt(-1,"exp",curDateTime + 3600)

success = jsonPayload.UpdateString("iss","me")
success = jsonPayload.UpdateString("sub","anApiKey")
success = jsonPayload.UpdateString("aud","https://auth-sandbox.abnamro.com/oauth/token")

' Produce the smallest possible JWT:
jwt.AutoCompact = True


jwtStr = jwt.CreateJwtPk(jsonHeader.Emit(),jsonPayload.Emit(),privkey)
If (jwt.LastMethodSuccess <> True) Then
    Debug.Print jwt.LastErrorText
    Exit Sub
End If

' Here is the JWT:
Debug.Print jwtStr