DataFlex

CardConnect Settlement Status

See more CardConnect Examples

Demonstrates how to get the status of transactions which have been submitted to the processor for settlement.

The settlement status service returns the status of transactions which have been submitted to the processor for settlement. The transaction’s setlstatus is updated appropriately when CardConnect’s receives a response from the processor. You can either specify a batchid to return a specific batch of transactions, or use a date to return all transactions settled for that date. ...

See https://developer.cardconnect.com/cardconnect-api#settlement-status

DataFlex

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Handle hoHttp
    String sUrl
    String sResponseStr
    Handle hoJsonResp
    String sSetlamount
    String sSetlstat
    String sSalesdoc
    String sRetref
    String sRespproc
    String sHostbatch
    String sRefundtotal
    String sBatchid
    String sChargetotal
    String sHoststat
    String sMerchid
    Integer i
    Integer iCount_i
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

    Move False To iSuccess

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    Set ComBasicAuth Of hoHttp To True
    Set ComLogin Of hoHttp To "API_USERNAME"
    Set ComPassword Of hoHttp To "API_PASSWORD"

    Move "https://<site>.cardconnect.com:<port>/cardconnect/rest/settlestat?merchid=<merchid>&batchid=<batchid>" To sUrl
    Get ComQuickGetStr Of hoHttp sUrl To sResponseStr
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 = False) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // 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.
    Get ComLastStatus Of hoHttp To iTemp1
    Showln "response status code = " iTemp1

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonResp
    If (Not(IsComObjectCreated(hoJsonResp))) Begin
        Send CreateComObject of hoJsonResp
    End
    Get ComLoad Of hoJsonResp sResponseStr To iSuccess
    Set ComEmitCompact Of hoJsonResp To False

    Showln "response JSON:"
    Get ComEmit Of hoJsonResp To sTemp1
    Showln sTemp1

    // A successful response looks like this:

    // {
    //   "respproc": "FNOR",
    //   "hostbatch": "",
    //   "refundtotal": "0.00",
    //   "batchid": "1900942291",
    //   "chargetotal": "0.00",
    //   "hoststat": "",
    //   "merchid": "MERCHANT_ID",
    //   "txns": [
    //     {
    //       "setlamount": "13.28",
    //       "setlstat": "R",
    //       "salesdoc": "rosedale_1555412201_392",
    //       "retref": "106631225001"
    //     },
    //     {
    //       "setlamount": "13.28",
    //       "setlstat": "R",
    //       "salesdoc": "rosedale_1555412353_392",
    //       "retref": "106731125153"
    //     },
    //     {
    //       "setlamount": "7.64",
    //       "setlstat": "R",
    //       "salesdoc": "rosedale_1555414960_393",
    //       "retref": "106008227760"
    //     }
    //   ]
    // }

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

    Get ComStringOf Of hoJsonResp "respproc" To sRespproc
    Get ComStringOf Of hoJsonResp "hostbatch" To sHostbatch
    Get ComStringOf Of hoJsonResp "refundtotal" To sRefundtotal
    Get ComStringOf Of hoJsonResp "batchid" To sBatchid
    Get ComStringOf Of hoJsonResp "chargetotal" To sChargetotal
    Get ComStringOf Of hoJsonResp "hoststat" To sHoststat
    Get ComStringOf Of hoJsonResp "merchid" To sMerchid
    Move 0 To i
    Get ComSizeOfArray Of hoJsonResp "txns" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJsonResp To i
        Get ComStringOf Of hoJsonResp "txns[i].setlamount" To sSetlamount
        Get ComStringOf Of hoJsonResp "txns[i].setlstat" To sSetlstat
        Get ComStringOf Of hoJsonResp "txns[i].salesdoc" To sSalesdoc
        Get ComStringOf Of hoJsonResp "txns[i].retref" To sRetref
        Move (i + 1) To i
    Loop



End_Procedure