(Excel) CardConnect Signature Capture

Demonstrates how to upload a BMP image of a handwritten signature.

This signature capture service augments an existing authorization record with the provided signature data. ...

See https://developer.cardconnect.com/cardconnect-api?lang=json#signature-capture

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 http As Chilkat.Http
Set http = Chilkat.NewHttp

http.BasicAuth = True
http.Login = "API_USERNAME"
http.Password = "API_PASSWORD"

' Build and send the following JSON:

' {
'   "merchid": "MERCHANT_ID",
'   "retref": "112989260941",
'   "signature": "BASE64_GZIPPED_BMP_DATA"
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("merchid","MERCHANT_ID")
success = json.UpdateString("retref","106631225001")

' Load the .bmp containing a 200px x 100px signature.
Dim bd As Chilkat.BinData
Set bd = Chilkat.NewBinData
success = bd.LoadFile("qa_data/bmp/signature.bmp")
' Gzip compress.
Dim gzip As Chilkat.Gzip
Set gzip = Chilkat.NewGzip
success = gzip.CompressBd(bd)
' Add to the JSON in base64 format
success = json.UpdateString("signature",bd.GetEncoded("base64"))


url = "https://<site>.cardconnect.com:<port>/cardconnect/rest/sigcap"

responseStr = http.PutText(url,json.Emit(),"utf-8","application/json",False,False)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' A response status of 200 indicates potential success.  The JSON response body
' must be examined to determine if it was truly successful or an error.
Debug.Print "response status code = "; http.LastStatus

Dim jsonResp As Chilkat.JsonObject
Set jsonResp = Chilkat.NewJsonObject
success = jsonResp.Load(responseStr)
jsonResp.EmitCompact = False

Debug.Print "response JSON:"
Debug.Print jsonResp.Emit()

' A successful response looks like this:

' {
'   "resptext": "signature stored",
'   "retref": "106631225001",
'   "respcode": "02",
'   "merchid": "MERCHANT_ID"
' }