List Payment Transactions

List payment transactions and filter by parameters


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

Filter Parameters

The following filter parameters are available for this query.

parameterdescription
transaction_idSearch 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_dateSearch 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_dateSearch 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.
payment_typeA case-sensitive string to return transactions by specific payment type type.
  • cc = Credit Card transactions
  • ach = ACH Transactions
You can return both cc and ach transactions by separating the values with a comma.
  • Example: "cc, ach"
By default the payment_type will return only credit card ("cc") transactions.
trxn_statusA case-sensitive string to return transactions by specific status type
  • approved = Approved transactions
  • declined = Declined transactions
By default all trxn_status types are returned.
amountSearch 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_fromSearch 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_toSearch 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.
cardholder_nameCase sensitive string search for transactions by name on credit card. Partial matches will be returned.
  • EXAMPLE: Jer will return transactions with cardholder Jerry Simms and also Brenda Jerkins
By default the cardholder_name is ignored.
card_brandCase sensitive string search for transactions by card brand. Valid values are:
  • visa
  • mastercard
  • amex
  • discover
  • jcb
  • diners
You can return multiple specific card brand combinations by separating the card brand names with a comma.
  • Example: "visa, amex"
By default the card_brand is ignored.
order_idCase 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_6Search for transactions matching the first 6 digits of credit card account numbers. You can return multiple transactions by separating the first_6 with a comma.
  • Example: "545454, 454847"
By default the first_6 is ignored.
last_4Search for transactions matching the last 4 digits of credit card account numbers. You can return multiple transactions by separating the last_4 with a comma.
  • Example: "4766, 1287"
By default the last_4 is ignored.
limitThe number of results to return when viewing a page. See PAGING below for more details.
The default is 40
skipThe 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 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 /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 /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.

Language
Click Try It! to start a request and see the response here!