(Excel) REST Basic Auth with Secure Strings

Demonstrates how to do REST Basic authentication using secure strings.

This example requires Chilkat v9.5.0.71 or greater.

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.

' Imagine we've previously saved our encrypted login and password within a JSON config file
' that contains this:

' {
'   "http_login": "mCrOmA7mBA7Au9RuJGb9hw==",
'   "http_password": "jJtiI9TgErTTpqBz9JtHBw=="
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.LoadFile("qa_data/passwords/http.json")

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

' These are the encryption settings we previously used to encrypt the credentials within the JSON config file.
crypt.CryptAlgorithm = "aes"
crypt.CipherMode = "cbc"
crypt.KeyLength = 128
crypt.SetEncodedKey "000102030405060708090A0B0C0D0E0F","hex"
crypt.SetEncodedIV "000102030405060708090A0B0C0D0E0F","hex"
crypt.EncodingMode = "base64"

Dim ssLogin As Chilkat.SecureString
Set ssLogin = Chilkat.NewSecureString
Dim ssPassword As Chilkat.SecureString
Set ssPassword = Chilkat.NewSecureString

' Decrypt to the secure string.  (the strings will still held in memory encrypted, but are now encrypted using
' a randomly generated session key.)
success = crypt.DecryptSecureENC(json.StringOf("http_login"),ssLogin)
success = crypt.DecryptSecureENC(json.StringOf("http_password"),ssPassword)

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect to a REST server.

bTls = True

port = 443

bAutoReconnect = True
success = rest.Connect("chilkatsoft.com",port,bTls,bAutoReconnect)

' Cause the "Authorization: Basic ..." header to be added to HTTP requests
success = rest.SetAuthBasicSecure(ssLogin,ssPassword)


responseJson = rest.FullRequestNoBody("GET","/helloWorld.html")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Show the LastRequestHeader that was sent.
Debug.Print rest.LastRequestHeader

' The LastRequestHeader looks like this:

' Host: chilkatsoft.com
' Authorization: Basic bXlIdHRwTG9naW46bXlIdHRwUGFzc3dvcmQ=