Return a list of ACH transactions or filter the query using Query parameter values

Filter Parameters

The following filter parameters are available for this query.

parameter	description
transaction_id	Search by `transaction_id`. String or integer value allowed. Seperate multiple transaction_id's with a comma. Example: `"8766546353263, 865756353537"` By default `transaction_id` is ignored.
start_date	Search for transactions beginning on a particular date. Format date as a mm/dd/yy string. Example: "01/01/18" Default is the date for the first transaction in DB. By default the `start_date` is ignored
end_date	Search for transactions ending on a particular date. Format date as a mm/dd/yy string. Example: "04/01/18" Default is the date for the most recent transaction in DB. By default the `end_date` is ignored.
trxn_status	A case-sensitive string to return transactions by specific status type `approved` = Approved transactions `declined` = Declined transactions By default all `trxn_status` types are returned.
amount	Search for a specific amount. Format as a string with whole numbers and up to two decimals as necessary. Example: $12.00 = `"12"` or `"12.0"` or `"12.00"` Example: $18.40 = `"18.4"` or `"18.40"` Example: $48.98 = `"48.98"` By default the `amount` is ignored.
amount_from	Search for a "from amount" to return all transactions equal to or greater than value entered. Format as a string with whole numbers and up to two decimals as necessary. Example: $12.00 = `"12"` or `"12.0"` or `"12.00"` Example: $18.40 = `"18.4"` or `"18.40"` Example: $48.98 = `"48.98"` By default the `amount_from` is ignored. If value provided here, any value in the `amount` query parameter will be ignored.
amount_to	Search for a "to amount" to return all transactions equal to or less than the value entered. Format as a string with whole numbers and up to two decimals as necessary. Example: $12.00 = `"12"` or `"12.0"` or `"12.00"` Example: $18.40 = `"18.4"` or `"18.40"` Example: $48.98 = `"48.98"` By default the `amount_to` is ignored. If value provided here, any value in the `amount` query parameter will be ignored.
name_on_account	Case sensitive string search for transactions by name on account. Partial matches will be returned. EXAMPLE: `Jer` will return transactions with name on account Jerry Simms and also Brenda Jerkins By default the 'name_on_account` is ignored.
order_id	Case sensitive string search for transactions by order_id. You can return multiple transactions by separating the `order_id` with a comma. Example: `"abc-1277645, abc-1387665"` By default the `order_id` is ignored.
first_6	Search for transactions matching the first 6 digits of the account number. You can return multiple transactions by separating the `first_6` with a comma. Example: `"545454, 454847"` By default the `first_6` is ignored.
last_4	Search for transactions matching the last 4 digits of bank account number. You can return multiple transactions by separating the `last_4` with a comma. Example: `"4766, 1287"` By default the `last_4` is ignored.
limit	The number of results to return when viewing a page. See PAGING below for more details. The default is 40
skip	The number of results to skip before returning results. See PAGING below for more details. The default `is 0

Paging

This endpoint provides query filter parameters allowing you to limit the number of results returned when fetching the ACH transaction list.

limit - The number of results to return when viewing a page. For example, setting limit to 20 means that, at most, 20 results will be returned in the request.
skip - The number of results to skip before returning results. For example, setting skip to 20 means that the API will discard the first 20 results.

By using these two parameters you can efficiently “page” through results, only returning items that are within the requested bounds.

To demonstrate, let’s use the parameters to display the first page of our transaction results:

GET /ach/transactions?limit=20&skip=0

Since the offset is set to 0, the API will not discard any results. Paired with a limit of 20, we will only see the first 20 results (1 through 20).

GET /ach/transactions?limit=20&skip=20

By setting an offset of 20, the API will discard the first 20 results. Paired again with a limit of 20, we will see the second page of results (21 through 40).

🚧
Note:
The Maximum number of transactions returned per API call is 250. If you require more than 250 then you should use the limit and offset parameters above.