(Excel) ChartURL - Create a Signed URL

Demonstrates how to create a signed URL for ChartURL.

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 crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2

' Example key: "dek-d7a46236eda961a6c3c18ffcc6b077ba87d27e9ae85f7842c6d427c265dd5f69d5131308d93332353d4a55a4b1160fcf516515a4a9f0aa50fbf2d7a2e7d0f1c5"

key = "charturl-sign-encrypt-key"
' Example token: "dt-RwYN"

token = "charturl-token"


slug = "weekly-activity"

data = "{ ""options"": {""data"": {""columns"": [[""This Week"",10,13],[""Last Week"",9,5]]}}}"

crypt.HashAlgorithm = "SHA256"
crypt.MacAlgorithm = "HMAC"
Dim success As Boolean
success = crypt.SetMacKeyString(key)
crypt.EncodingMode = "base64"

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(data)
Debug.Print "json = "; json.Emit()


sig = crypt.MacStringENC(json.Emit())

Dim sbUrl As Chilkat.StringBuilder
Set sbUrl = Chilkat.NewStringBuilder
success = sbUrl.Append("https://charturl.com/i/")
success = sbUrl.Append(token)
success = sbUrl.Append("/")
success = sbUrl.Append(slug)
success = sbUrl.Append("?d=")
success = sbUrl.Append(crypt.EncodeString(json.Emit(),"utf-8","url"))
success = sbUrl.Append("&s=")
success = sbUrl.Append(crypt.EncodeString(sig,"utf-8","url"))

Debug.Print "Signed URL: "; sbUrl.GetAsString()