Skip to content

List Transactions

Request URL

POST /transfer-to/ach/list

Description

This endpoint will list transactions that match the desired search criteria. Search criteria may be a specific cFiTransaction or reference ID, a date range, a status value, or a combination of criteria. You may also specify a maximum number of records to return using the numberOfRecords property (up to 1000) and you may specify a number of records to skip using the skipRecords property. Combine the numberOfRecords property with the skipRecords property to make displaying transaction lists in batches easy. For example, if you want to list transactions in batches of 150, you can set numberOfRecords to 150 and skipRecords to 0 in the first request. Then, increase skipRecords by 150 in each subsequent request to return the next batch and so on.

When making a request, if the number of transactions matching the criteria is greater than the numberOfRecords maximum requested, the response body will indicate that there are additional transactions ("more": true).

If no properties are included, an unfiltered transaction list will be returned (up to a maximum of 1000).

Schema

Property table for transfer-to/ach/list

Property Description Required Schema
dateCreateFrom A beginning date in ISO Date format No {
  "type": "string",
  "format": "dateISO",
  "nullable": true
}
dateCreateTo An ending date in ISO Date format No {
  "type": "string",
  "format": "dateISO",
  "nullable": true
}
numberOfRecords The maximum number of desired records to return No {
  "type": "integer",
  "minimum": 1,
  "nullable": true,
  "$id": "common-numberOfRecords"
}
skipRecords The number of records to skip when returning results No {
  "type": "integer",
  "minimum": 0,
  "nullable": true,
  "$id": "common-skipRecords"
}
reference An external alphanumeric reference ID for the entity in your system No {
  "type": "string",
  "pattern": "^[0-9a-zA-Z_]+$",
  "minLength": 1,
  "maxLength": 36,
  "nullable": true,
  "$id": "common-idNullable"
}
cFiTransactionId The transaction ID in the connectFi system No {
  "type": "string",
  "pattern": "^[0-9a-zA-Z_]+$",
  "minLength": 1,
  "maxLength": 36,
  "nullable": true,
  "$id": "common-idNullable"
}
cFiTransactionIds Array of transaction IDs from the connectFi system obtained when each transaction was initialized No array of {
  "type": "string",
  "pattern": "^[0-9a-zA-Z_]+$",
  "minLength": 1,
  "maxLength": 36,
  "nullable": true,
  "$id": "common-idNullable"
}
cFiPackageId cFiPackageId No {
  "type": "string",
  "pattern": "^[0-9a-zA-Z_]+$",
  "minLength": 1,
  "maxLength": 36,
  "nullable": true,
  "$id": "common-idNullable"
}
status Status No {
  "type": "string",
  "nullable": true,
  "enum": [ "Initiated", "Sent", "Complete",
"Settled", "Returned", "Declined" ]
}
clientCode The clientCode in connectFi that corresponds to the desired ACH configurations for companyName and companyId. If not included, the default ACH solution configuration for this client will be used. Contact support to update ACH configurations. Example - If clientCode: "name1" is configured to use ACH { companyName: "COABC", companyId: "123abc456def789" } and clientCode: "name2" is configured to use ACH { companyName: "COABD", companyId: "123abc456def780" }, then including the clientCode parameter will specify which configuration to use. If not included, the default "name1" configuration would be used in this example. No {
  "type": "string",
  "pattern": "^((?![<>]).)*$",
  "minLength": 0,
  "maxLength": 100,
  "nullable": true,
  "$id": "common-commonStr100"
}

Request Body

{
    "dateCreateFrom": "2023-06-01T14:27:33.684Z",
    "dateCreateTo": "2025-07-11T18:27:33.684Z",
    "status": "Initiated",
    "numberOfRecords": 1000,
    "skipRecords": 0
}

Snippet Examples

javascript

const axios = require('axios');
const data = {
    "dateCreateFrom": "2023-06-01T14:27:33.684Z",
    "dateCreateTo": "2025-07-11T18:27:33.684Z",
    "status": "Initiated",
    "numberOfRecords": 1000,
    "skipRecords": 0
}
;
const config = {
  method: 'POST',
  url: '${CONNECTFI_BASE_URL}/transfer-to/ach/list',
  headers: {
    'Content-Type': "application/json",
    'x-connectfi-token': "A long random string token received from /auth/get-token request"
  },
  data
};

let result;
try {
  result = await axios.request(config);
  if (result.status === 200) {
    console.log(JSON.stringify(result.data));
  }
} catch (err) {
  console.log({
    errCode: err.code,
    responseStatus: err.response && err.response.status,
    data: err.response && JSON.stringify(err.response.data)
  });
}

cURL

curl --location "CONNECTFI_BASE_URL/transfer-to/ach/list" --data "{\"dateCreateFrom\":\"2023-06-01T14:27:33.684Z\",\"dateCreateTo\":\"2025-07-11T18:27:33.684Z\",   \"status\":\"Initiated\",   \"numberOfRecords\":1000,   \"skipRecords\":0}" --header "Content-Type: application/json" --header "x-connectfi-token: A long random string token received from /auth/get-token request" 

Successful Response Examples

200 TRANSFER-TO/ACH/LIST SUCCESSFUL RESPONSE USING DATE RANGE AND NUMBEROFRECORDS

HEADERS

Header Value
Content-Type application/json
x-connectfi-token A long random string token received from /auth/get-token request

REQUEST BODY

{
    "dateCreateFrom": "2023-06-01T14:27:33.684Z",
    "dateCreateTo": "2025-07-11T18:27:33.684Z",
    "numberOfRecords": 2
}

RESPONSE BODY

{
    "code": "0",
    "data": {
        "total": {
            "skipRecords": 0,
            "numberOfRecords": 2,
            "more": true
        },
        "items": [
            {
                "cFiTransactionId": "CLIENTID_4SCoDGSxGb7tHYrwTadq7w",
                "reference": "extTrnAch589",
                "cFiAggregatorId": "CLIENTID",
                "status": "Sent",
                "dtsCreatedAt": "2023-11-14T21:34:44.234Z",
                "dtsSent": "2023-11-14T21:53:40.719Z",
                "effectiveEntryDate": "2023-11-16",
                "individualName": "John Smith",
                "routingNumber": "053207766",
                "amount": 3.15,
                "currency": "USD",
                "DFIAccountNumber": "123456789"
            },
            {
                "cFiTransactionId": "CLIENTID_6EcQafaOagSe3qog8OipWi",
                "reference": "extTrnAch463",
                "cFiAggregatorId": "CLIENTID",
                "status": "Sent",
                "dtsCreatedAt": "2023-11-12T20:19:59.523Z",
                "dtsSent": "2023-11-13T13:53:14.926Z",
                "effectiveEntryDate": "2023-11-13",
                "individualName": "John Smith",
                "routingNumber": "053207766",
                "amount": 3.15,
                "currency": "USD",
                "DFIAccountNumber": "123456789"
            }
        ]
    },
    "requestId": "9e8670d0950511eea89d7100487c0512"
}

200 TRANSFER-TO/ACH/LIST SUCCESSFUL RESPONSE USING REFERENCE

HEADERS

Header Value
Content-Type application/json
x-connectfi-token A long random string token received from /auth/get-token request

REQUEST BODY

{
    "reference": "extTrnAch451"
}

RESPONSE BODY

{
    "code": "0",
    "data": {
        "total": {
            "skipRecords": 0,
            "numberOfRecords": 1,
            "more": false
        },
        "items": [
            {
                "cFiTransactionId": "CLIENTID_3n1WQzCy56irtMLiNuQdrQ",
                "reference": "extTrnAch451",
                "cFiAggregatorId": "CLIENTID",
                "status": "Sent",
                "dtsCreatedAt": "2023-11-02T17:37:02.521Z",
                "dtsSent": "2023-11-02T17:53:49.930Z",
                "effectiveEntryDate": "2023-11-03",
                "individualName": "John Smith",
                "routingNumber": "053207766",
                "amount": 3.15,
                "currency": "CUR",
                "DFIAccountNumber": "123456789"
            }
        ]
    },
    "requestId": "869a7a70950511eea89d7100487c0512"
}

200 TRANSFER-TO/ACH/LIST SUCCESSFUL RESPONSE USING MULTIPLE CRITERIA

HEADERS

Header Value
Content-Type application/json
x-connectfi-token A long random string token received from /auth/get-token request

REQUEST BODY

{
    "dateCreateFrom": "2023-06-01T14:27:33.684Z",
    "dateCreateTo": "2025-07-11T18:27:33.684Z",
    "status": "Initiated",
    "numberOfRecords": 1000,
    "skipRecords": 0
}

RESPONSE BODY

{
    "code": "0",
    "data": {
        "total": {
            "skipRecords": 0,
            "numberOfRecords": 3,
            "more": false
        },
        "items": [
            {
                "cFiTransactionId": "CLIENTID_3n1WQzCy56irtMLiNuQdrQ",
                "reference": "extTrnAch451",
                "cFiAggregatorId": "CLIENTID",
                "status": "Initiated",
                "dtsCreatedAt": "2023-11-02T17:37:02.521Z",
                "effectiveEntryDate": "2023-11-03",
                "individualName": "John Smith",
                "routingNumber": "053207766",
                "amount": 3.15,
                "currency": "CUR",
                "DFIAccountNumber": "123456789"
            },
            {
                "cFiTransactionId": "CLIENTID_6CX4ofCQ1FuyXL72EFMjfk",
                "reference": "extTrnAch450",
                "cFiAggregatorId": "CLIENTID",
                "status": "Initiated",
                "dtsCreatedAt": "2023-11-02T17:32:52.563Z",
                "effectiveEntryDate": "2023-11-03",
                "individualName": "John Smith",
                "routingNumber": "053207766",
                "amount": 3.15,
                "currency": "USD",
                "DFIAccountNumber": "123456789"
            },
            {
                "cFiTransactionId": "CLIENTID_6iUY9DVZejolS5qlKhK1J8",
                "reference": "extTrnAch201",
                "cFiAggregatorId": "CLIENTID",
                "status": "Initiated",
                "dtsCreatedAt": "2023-11-02T17:25:25.325Z",
                "effectiveEntryDate": "2023-11-03",
                "individualName": "John Smith",
                "routingNumber": "053207766",
                "amount": 3.15,
                "currency": "USD",
                "DFIAccountNumber": "123456789"
            }
        ]
    },
    "requestId": "6002ce4079a711eeb5658f28ab5fe311"
}

200 TRANSFER-TO/ACH/LIST SUCCESSFUL RESPONSE - NO TRANSACTIONS MEET SEARCH CRITERIA

HEADERS

Header Value
Content-Type application/json
x-connectfi-token A long random string token received from /auth/get-token request

REQUEST BODY

{
    "dateCreateFrom": "2023-06-01T14:27:33.684Z",
    "dateCreateTo": "2025-07-11T18:27:33.684Z",
    "status": "Declined",
    "numberOfRecords": 1000,
    "skipRecords": 0
}

RESPONSE BODY

{
    "code": "0",
    "data": {
        "total": {
            "skipRecords": 0,
            "numberOfRecords": 0,
            "more": false
        },
        "items": []
    },
    "requestId": "ae7e70a0819b11ee9b7427220cc6c212"
}