(Excel) CardConnect Capture Level 3 Data

Demonstrates how to send a CardConnect Capture request with Lavel 3 line item data.

If available, Level 3 line item data can be sent with the capture request, particularly for any commercial or corporate payment cards. To qualify for Level 3 Interchange rates, Level 2 data must also be provided. ...

See https://developer.cardconnect.com/cardconnect-api#capture-level-3-data

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:

' The "retref" is the value returned in the JSON response for the Authorization request.

' {
'   "retref": "2880000333",
'   "shiptozip": "11111-1111",
'   "shipfromzip": "99999-9999",
'   "amount": "596.00",
'   "items": [
'     {
'       "discamnt": "0",
'       "unitcost": "900",
'       "uom": "CS",
'       "lineno": "1",
'       "description": "DESCRIPTION-1",
'       "taxamnt": "117",
'       "quantity": "1000",
'       "upc": "UPC-1",
'       "netamnt": "150",
'       "material": "MATERIAL-1"
'     },
'     {
'       "discamnt": "0",
'       "unitcost": "450",
'       "uom": "CS",
'       "lineno": "2",
'       "description": "DESCRIPTION-2",
'       "taxamnt": "117",
'       "quantity": "2000",
'       "upc": "UPC-1",
'       "netamnt": "300",
'       "material": "MATERIAL-2"
'     }
'   ],
'   "taxamount": "40.00",
'   "merchid": "123456789012",
'   "account": "4111111111111111",
'   "ponumber": "PO-0736332"
' }
' 
' Use this online tool to generate the code from sample JSON: 
' Generate Code to Create JSON

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("retref","112989260941")
success = json.UpdateString("shiptozip","11111-1111")
success = json.UpdateString("shipfromzip","99999-9999")
success = json.UpdateString("amount","596.00")
success = json.UpdateString("items[0].discamnt","0")
success = json.UpdateString("items[0].unitcost","900")
success = json.UpdateString("items[0].uom","CS")
success = json.UpdateString("items[0].lineno","1")
success = json.UpdateString("items[0].description","DESCRIPTION-1")
success = json.UpdateString("items[0].taxamnt","117")
success = json.UpdateString("items[0].quantity","1000")
success = json.UpdateString("items[0].upc","UPC-1")
success = json.UpdateString("items[0].netamnt","150")
success = json.UpdateString("items[0].material","MATERIAL-1")
success = json.UpdateString("items[1].discamnt","0")
success = json.UpdateString("items[1].unitcost","450")
success = json.UpdateString("items[1].uom","CS")
success = json.UpdateString("items[1].lineno","2")
success = json.UpdateString("items[1].description","DESCRIPTION-2")
success = json.UpdateString("items[1].taxamnt","117")
success = json.UpdateString("items[1].quantity","2000")
success = json.UpdateString("items[1].upc","UPC-1")
success = json.UpdateString("items[1].netamnt","300")
success = json.UpdateString("items[1].material","MATERIAL-2")
success = json.UpdateString("taxamount","40.00")
success = json.UpdateString("merchid","MERCHANT_ID")
success = json.UpdateString("account","4111111111111111")
success = json.UpdateString("ponumber","PO-0736332")


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

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:

' {
'   "amount": "596.00",
'   "resptext": "Approval",
'   "setlstat": "Queued for Capture",
'   "commcard": " C ",
'   "respcode": "00",
'   "batchid": "1900942291",
'   "merchid": "MERCHANT_ID",
'   "token": "9418594164541111",
'   "authcode": "PPS158",
'   "respproc": "FNOR",
'   "retref": "112989260941",
'   "respstat": "A",
'   "account": "9418594164541111"
' }

' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON


amount = jsonResp.StringOf("amount")

resptext = jsonResp.StringOf("resptext")

setlstat = jsonResp.StringOf("setlstat")

commcard = jsonResp.StringOf("commcard")

respcode = jsonResp.StringOf("respcode")

batchid = jsonResp.StringOf("batchid")

merchid = jsonResp.StringOf("merchid")

token = jsonResp.StringOf("token")

authcode = jsonResp.StringOf("authcode")

respproc = jsonResp.StringOf("respproc")

retref = jsonResp.StringOf("retref")

respstat = jsonResp.StringOf("respstat")

account = jsonResp.StringOf("account")