(Excel) Client Certificate in REST

Demonstrates how to use a client certificate with a REST connection.

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.

' This example shows how to use the Chilkat socket object's connection.
Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest
Dim socket As Chilkat.Socket
Set socket = Chilkat.NewSocket

' Set the certificate to be used for mutual TLS authentication
' (i.e. sets the client-side certificate for two-way TLS authentication)
' Note: There are other ways to set the client certificate using Chilkat.
' For example, on Windows systems, a Chilkat certificate object could be loaded with certificate
' pre-installed (with private key) in a Windows certificate store, and then socket.SetSslClientCert could be called.

success = socket.SetSslClientCertPfx("/home/bob/pfxFiles/myClientSideCertWithPrivateKey.pfx","pfxPassword")
If (success <> True) Then
    Debug.Print socket.LastErrorText
    Exit Sub
End If

' Note: The certificate used for the client-side of TLS mutual authentication
' must have the associated private key available. (.pfx/.p12 files typically store both
' the certificate and associated private key.)

' Establish the connection using the socket object (with client certificate authentication).

bTls = True

port = 443

maxWaitMs = 5000
success = socket.Connect("www.example.com",port,bTls,maxWaitMs)
If (success <> True) Then
    Debug.Print "Connect Failure Error Code: "; socket.ConnectFailReason
    Debug.Print socket.LastErrorText
    Exit Sub
End If


bAutoReconnect = True

' Use the connection:
success = rest.UseConnection(socket,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' At this point we are connected and can make REST calls...
' For example..

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