(Visual Basic 6.0) CardConnect Inquire

Demonstrates how to get information for an individual transaction, including its settlement status (setlstat) and the response codes from the initial authorization.

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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As New ChilkatHttp
Dim success As Long

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

Dim url As String
url = "https://<site>.cardconnect.com:<port>/cardconnect/rest/inquire/<retref>/<merchid>"
Dim responseStr As String
responseStr = http.QuickGetStr(url)
If (http.LastMethodSuccess = 0) 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 New ChilkatJsonObject
success = jsonResp.Load(responseStr)
jsonResp.EmitCompact = 0

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

' A successful response looks like this:

' {
'   "amount": "0.00",
'   "resptext": "Approval",
'   "setlstat": "Voided",
'   "capturedate": "20190422180044",
'   "acctid": "1",
'   "respcode": "00",
'   "entrymode": "ECommerce",
'   "merchid": "MERCHANT_ID",
'   "token": "9418594164541111",
'   "authcode": "PPS158",
'   "respproc": "FNOR",
'   "authdate": "20190422",
'   "bintype": "",
'   "profileid": "16618402968441604028",
'   "lastfour": "1111",
'   "name": "TOM JONES",
'   "currency": "USD",
'   "retref": "112989260941",
'   "respstat": "A",
'   "account": "9418594164541111"
' }

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

Dim amount As String
amount = jsonResp.StringOf("amount")
Dim resptext As String
resptext = jsonResp.StringOf("resptext")
Dim setlstat As String
setlstat = jsonResp.StringOf("setlstat")
Dim capturedate As String
capturedate = jsonResp.StringOf("capturedate")
Dim acctid As String
acctid = jsonResp.StringOf("acctid")
Dim respcode As String
respcode = jsonResp.StringOf("respcode")
Dim entrymode As String
entrymode = jsonResp.StringOf("entrymode")
Dim merchid As String
merchid = jsonResp.StringOf("merchid")
Dim token As String
token = jsonResp.StringOf("token")
Dim authcode As String
authcode = jsonResp.StringOf("authcode")
Dim respproc As String
respproc = jsonResp.StringOf("respproc")
Dim authdate As String
authdate = jsonResp.StringOf("authdate")
Dim bintype As String
bintype = jsonResp.StringOf("bintype")
Dim profileid As String
profileid = jsonResp.StringOf("profileid")
Dim lastfour As String
lastfour = jsonResp.StringOf("lastfour")
Dim name As String
name = jsonResp.StringOf("name")
Dim currency As String
currency = jsonResp.StringOf("currency")
Dim retref As String
retref = jsonResp.StringOf("retref")
Dim respstat As String
respstat = jsonResp.StringOf("respstat")
Dim account As String
account = jsonResp.StringOf("account")