(Excel) Create JWS with Multiple Signatures using the General JSON Serialization Format

Creates a JSON Web Signature (JWS) containing 3 signatures and output using the general JSON serialization format.

Chilkat supports all of the following JWS algorithms:

   +--------------+-------------------------------+--------------------+
   | "alg" Param  | Digital Signature or MAC      | Implementation     |
   | Value        | Algorithm                     | Requirements       |
   +--------------+-------------------------------+--------------------+
   | HS256        | HMAC using SHA-256            | Required           |
   | HS384        | HMAC using SHA-384            | Optional           |
   | HS512        | HMAC using SHA-512            | Optional           |
   | RS256        | RSASSA-PKCS1-v1_5 using       | Recommended        |
   |              | SHA-256                       |                    |
   | RS384        | RSASSA-PKCS1-v1_5 using       | Optional           |
   |              | SHA-384                       |                    |
   | RS512        | RSASSA-PKCS1-v1_5 using       | Optional           |
   |              | SHA-512                       |                    |
   | ES256        | ECDSA using P-256 and SHA-256 | Recommended+       |
   | ES384        | ECDSA using P-384 and SHA-384 | Optional           |
   | ES512        | ECDSA using P-521 and SHA-512 | Optional           |
   | PS256        | RSASSA-PSS using SHA-256 and  | Optional           |
   |              | MGF1 with SHA-256             |                    |
   | PS384        | RSASSA-PSS using SHA-384 and  | Optional           |
   |              | MGF1 with SHA-384             |                    |
   | PS512        | RSASSA-PSS using SHA-512 and  | Optional           |
   |              | MGF1 with SHA-512             |                    |
   +--------------+-------------------------------+--------------------+

Note: This example requires Chilkat v9.5.0.66 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

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

' Note: This example requires Chilkat v9.5.0.66 or greater.

' The JWS to be created will contain three signatures.
' The 1st will use an ECC key, the 2nd an RSA key, and the 3rd an HMAC key.

' Prepare each key..

' ---------------------------------------------------
' Use the following RSA key loaded from JWK format.
Dim sbRsaJwk As Chilkat.StringBuilder
Set sbRsaJwk = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbRsaJwk.Append("{""kty"":""RSA"",")
success = sbRsaJwk.Append("""n"":""ofgWCuLjybRlzo0tZWJjNiuSfb4p4fAkd_wWJcyQoTbji9k0l8W26mPddx")
success = sbRsaJwk.Append("HmfHQp-Vaw-4qPCJrcS2mJPMEzP1Pt0Bm4d4QlL-yRT-SFd2lZS-pCgNMs")
success = sbRsaJwk.Append("D1W_YpRPEwOWvG6b32690r2jZ47soMZo9wGzjb_7OMg0LOL-bSf63kpaSH")
success = sbRsaJwk.Append("SXndS5z5rexMdbBYUsLA9e-KXBdQOS-UTo7WTBEMa2R2CapHg665xsmtdV")
success = sbRsaJwk.Append("MTBQY4uDZlxvb3qCo5ZwKh9kG4LT6_I5IhlJH7aGhyxXFvUK-DWNmoudF8")
success = sbRsaJwk.Append("NAco9_h9iaGNj8q2ethFkMLs91kzk2PAcDTW9gb54h4FRWyuXpoQ"",")
success = sbRsaJwk.Append("""e"":""AQAB"",")
success = sbRsaJwk.Append("""d"":""Eq5xpGnNCivDflJsRQBXHx1hdR1k6Ulwe2JZD50LpXyWPEAeP88vLNO97I")
success = sbRsaJwk.Append("jlA7_GQ5sLKMgvfTeXZx9SE-7YwVol2NXOoAJe46sui395IW_GO-pWJ1O0")
success = sbRsaJwk.Append("BkTGoVEn2bKVRUCgu-GjBVaYLU6f3l9kJfFNS3E0QbVdxzubSu3Mkqzjkn")
success = sbRsaJwk.Append("439X0M_V51gfpRLI9JYanrC4D4qAdGcopV_0ZHHzQlBjudU2QvXt4ehNYT")
success = sbRsaJwk.Append("CBr6XCLQUShb1juUO1ZdiYoFaFQT5Tw8bGUl_x_jTj3ccPDVZFD9pIuhLh")
success = sbRsaJwk.Append("BOneufuBiB4cS98l2SR_RQyGWSeWjnczT0QU91p1DhOVRuOopznQ"",")
success = sbRsaJwk.Append("""p"":""4BzEEOtIpmVdVEZNCqS7baC4crd0pqnRH_5IB3jw3bcxGn6QLvnEtfdUdi")
success = sbRsaJwk.Append("YrqBdss1l58BQ3KhooKeQTa9AB0Hw_Py5PJdTJNPY8cQn7ouZ2KKDcmnPG")
success = sbRsaJwk.Append("BY5t7yLc1QlQ5xHdwW1VhvKn-nXqhJTBgIPgtldC-KDV5z-y2XDwGUc"",")
success = sbRsaJwk.Append("""q"":""uQPEfgmVtjL0Uyyx88GZFF1fOunH3-7cepKmtH4pxhtCoHqpWmT8YAmZxa")
success = sbRsaJwk.Append("ewHgHAjLYsp1ZSe7zFYHj7C6ul7TjeLQeZD_YwD66t62wDmpe_HlB-TnBA")
success = sbRsaJwk.Append("-njbglfIsRLtXlnDzQkv5dTltRJ11BKBBypeeF6689rjcJIDEz9RWdc"",")
success = sbRsaJwk.Append("""dp"":""BwKfV3Akq5_MFZDFZCnW-wzl-CCo83WoZvnLQwCTeDv8uzluRSnm71I3Q")
success = sbRsaJwk.Append("CLdhrqE2e9YkxvuxdBfpT_PI7Yz-FOKnu1R6HsJeDCjn12Sk3vmAktV2zb")
success = sbRsaJwk.Append("34MCdy7cpdTh_YVr7tss2u6vneTwrA86rZtu5Mbr1C1XsmvkxHQAdYo0"",")
success = sbRsaJwk.Append("""dq"":""h_96-mK1R_7glhsum81dZxjTnYynPbZpHziZjeeHcXYsXaaMwkOlODsWa")
success = sbRsaJwk.Append("7I9xXDoRwbKgB719rrmI2oKr6N3Do9U0ajaHF-NKJnwgjMd2w9cjz3_-ky")
success = sbRsaJwk.Append("NlxAr2v4IKhGNpmM5iIgOS1VZnOZ68m6_pbLBSp3nssTdlqvd0tIiTHU"",")
success = sbRsaJwk.Append("""qi"":""IYd7DHOhrWvxkwPQsRM2tOgrjbcrfvtQJipd-DlcxyVuuM9sQLdgjVk2o")
success = sbRsaJwk.Append("y26F0EmpScGLq2MowX7fhd_QJQ3ydy5cY7YIBi87w93IKLEdfnbJtoOPLU")
success = sbRsaJwk.Append("W0ITrJReOgo1cq9SbsxYawBgfp_gh6A5603k2-ZQwVK0JKSHuLFkuQ3U""")
success = sbRsaJwk.Append("}")

Dim rsaKey As Chilkat.PrivateKey
Set rsaKey = Chilkat.NewPrivateKey
' Note: This example loads the RSA key from JWK format.  Any format can be loaded
' into the private key object. (See the online reference documentation..)

success = rsaKey.LoadJwk(sbRsaJwk.GetAsString())
If (success <> True) Then
    Debug.Print rsaKey.LastErrorText
    Exit Sub
End If

' ---------------------------------------------------
' Use the following ECC key loaded from JWK format.
Dim sbEccJwk As Chilkat.StringBuilder
Set sbEccJwk = Chilkat.NewStringBuilder
success = sbEccJwk.Append("{""kty"":""EC"",")
success = sbEccJwk.Append("""crv"":""P-256"",")
success = sbEccJwk.Append("""x"":""f83OJ3D2xF1Bg8vub9tLe1gHMzV76e8Tus9uPHvRVEU"",")
success = sbEccJwk.Append("""y"":""x_FEzRu9m36HLN_tue659LNpXW6pCyStikYjKIWI5a0"",")
success = sbEccJwk.Append("""d"":""jpsQnnGQmL-YBIffH1136cspYG6-0iY7X1fCE9-E9LI""")
success = sbEccJwk.Append("}")

Dim eccKey As Chilkat.PrivateKey
Set eccKey = Chilkat.NewPrivateKey
' Note: This example loads the ECDSA key from JWK format.  Any format can be loaded
' into the private key object. (See the online reference documentation..)
success = eccKey.LoadJwk(sbEccJwk.GetAsString())
If (success <> True) Then
    Debug.Print eccKey.LastErrorText
    Exit Sub
End If

' ---------------------------------------------------
' The HMAC key (in base64url format)

hmacKey = "AyM1SysPpbyDfgZld3umj1qzKObwVMkoqQ-EstJQLr_T-1qS0gZH75aKtMN3Yj0iPS4hcgUuTwjAzZr1Z9CAow"

' ---------------------------------------------------
' Prepare the headers..
' RSASSA-PKCS1-v1_5 SHA-256
Dim jwsProtHdr0 As Chilkat.JsonObject
Set jwsProtHdr0 = Chilkat.NewJsonObject
success = jwsProtHdr0.AppendString("alg","RS256")
Dim jwsUnprotHdr0 As Chilkat.JsonObject
Set jwsUnprotHdr0 = Chilkat.NewJsonObject
success = jwsUnprotHdr0.AppendString("kid","myRsaKey")

' ECDSA using P-256 and SHA-256
Dim jwsProtHdr1 As Chilkat.JsonObject
Set jwsProtHdr1 = Chilkat.NewJsonObject
success = jwsProtHdr1.AppendString("alg","ES256")
Dim jwsUnprotHdr1 As Chilkat.JsonObject
Set jwsUnprotHdr1 = Chilkat.NewJsonObject
success = jwsUnprotHdr1.AppendString("kid","myEcKey")

' HMAC using SHA-256
Dim jwsProtHdr2 As Chilkat.JsonObject
Set jwsProtHdr2 = Chilkat.NewJsonObject
success = jwsProtHdr2.AppendString("alg","HS256")
Dim jwsUnprotHdr2 As Chilkat.JsonObject
Set jwsUnprotHdr2 = Chilkat.NewJsonObject
success = jwsUnprotHdr2.AppendString("kid","myMacKey")

' ---------------------------------------------------
' First set the JWS headers, keys, and payload, then we'll create the JWS...
Dim jws As Chilkat.Jws
Set jws = Chilkat.NewJws

success = jws.SetProtectedHeader(0,jwsProtHdr0)
success = jws.SetUnprotectedHeader(0,jwsUnprotHdr0)
success = jws.SetProtectedHeader(1,jwsProtHdr1)
success = jws.SetUnprotectedHeader(1,jwsUnprotHdr1)
success = jws.SetProtectedHeader(2,jwsProtHdr2)
success = jws.SetUnprotectedHeader(2,jwsUnprotHdr2)

success = jws.SetPrivateKey(0,rsaKey)
success = jws.SetPrivateKey(1,eccKey)
success = jws.SetMacKey(2,hmacKey,"base64url")


bIncludeBom = False

payloadStr = "In our village, folks say God crumbles up the old moon into stars."
success = jws.SetPayload(payloadStr,"utf-8",bIncludeBom)

' ---------------------------------------------------
' Create the JWS.
' Givent that multiple signatures will exist, only the general JSON serialization 
' format is possible, and that is what will be produced.

jwsStr = jws.CreateJws()
If (jws.LastMethodSuccess <> True) Then
    Debug.Print jws.LastErrorText
    Exit Sub
End If

' The jwsStr is contains JSON in the smallest possible size, which is a single line.
' To get in human-readable format, load into a Chilkat JSON object and emit..
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(jwsStr)
json.EmitCompact = False
Debug.Print json.Emit()

' Sample output:

' { 
'   "payload": "SW4gb3VyIHZpbGxhZ2UsIGZvbGtzIHNheSBHb2QgY3J1bWJsZXMgdXAgdGhlIG9sZCBtb29uIGludG8gc3RhcnMu",
'   "signatures": [
'     { 
'       "protected": "eyJhbGciOiJSUzI1NiJ9",
'       "header": { 
'         "kid": "myRsaKey"
'       },
'       "signature": "B04c24gSnpVm1Z-_bemfyNMCpZm6Knj1yB-yzaIOvijsWfDgoF_mSJccTIbzapNgwJudnobr5iDOfZWiRR9iqCyDJLe5M1S40vFF7MFEI3JecYRgrRc6n1lTkYLMRyVq48BwbQlmKgPqmK9drun3agklsr0FmgNx65pfmcnlYdXsgwxf8WbgppefrlrMImp-98-dNtBcUL8ce1aOjbcyVFjGMCzpm3JerQqIzWQvEwBstnMEQle73KHcyx_nsTmlzY70CaydbRTsciOATL7WfiMwuX1q9Y2NIpTg3CbOTWKdwjh7iyfiAKQxNBaF2mApnqj9hjpf8GwR-CfxAzJtPg"
'     },
'     { 
'       "protected": "eyJhbGciOiJFUzI1NiJ9",
'       "header": { 
'         "kid": "myEcKey"
'       },
'       "signature": "2cbugKq0ERaQMh01n2B-86EZFYleeMf8bsccaQMxzOxAg14PxfjR3IImvodTJYqkmfBJYW203etz2-7ZtJUOGw"
'     },
'     { 
'       "protected": "eyJhbGciOiJIUzI1NiJ9",
'       "header": { 
'         "kid": "myMacKey"
'       },
'       "signature": "e7R9gjx0RsUNa3c7qd8k9mQGEhtcG8vsN1W7jbLb2MA"
'     }
'   ]
' }