List and Filter All Transactions

Retrieve a list of all transactions for the merchant account. Use query parameters to filter and sort transactions based on criteria such as date range, transaction type, status, amount, and more. Transactions flagged as suspected fraud are hidden by default.

The List and Filter All Transactions endpoint allows you to retrieve all transactions associated with the merchant account. You can apply various query parameters to sort and filter the transaction data, enabling you to find specific transactions or analyze transaction history based on different criteria.

Key Features

  • Retrieve a paginated list of transactions.
  • Filter transactions by date range, status, type, amount, customer, payment method, payment link, suspected fraud flag, and more.
  • Sort transactions based on specific fields.

Usage Notes

  • Combining Filters: You can combine multiple query parameters to narrow down the results to specific transactions.
  • Date Range Filtering: When using start_date and end_date, ensure the dates are in the correct format (YYYY-MM-DD).
  • Pagination: Use page and per_page to control the pagination of results.
  • Suspected Fraud Filtering: Use is_suspected_fraud=1 to retrieve only transactions that have been flagged as suspected fraud. These are charges that were blocked by Stax Connect on behalf of the merchant. When using this parameter, do not combine it with the success parameter.
  • User Roles: Ensure that the API key or user has the necessary permissions to access transaction data.
  • Suspected Fraud Filtering: Transactions flagged as suspected fraud are hidden by default from all transaction listings, searches, and exports. To include flagged transactions alongside all other results, pass is_suspected_fraud=1. Omitting the parameter or passing is_suspected_fraud=0 keeps flagged transactions hidden. The parameter accepts boolean values (1 or 0); invalid values will return a 422 validation error.

Response Structure

CodeResponseReason
200SuccessReturns a paginated list of transaction objects matching the filter criteria. Each transaction object includes details such as id, type, status, amount, currency, customer_id, payment_method_id, created_at, and meta
400Bad RequestInvalid query parameters.
422Unprocessable EntityValidation failed for one or more query parameters (e.g., invalid value for is_suspected_fraud).
401UnauthorizedAuthentication failed.
500Internal Server ErrorAn unexpected error occurred on the server.

Important Considerations

Data Security: Ensure that sensitive transaction data is handled securely and in compliance with data protection regulations.

Rate Limiting: Be aware of any rate limits on API calls to avoid throttling.

Data Consistency: Transactions are continually updated; consider implementing webhooks for real-time updates.

Query Params
date

Filter transactions created on or after this date (format: YYYY-MM-DD).

date

Filter transactions created on or before this date (format: YYYY-MM-DD).

string

Filter by transaction type (e.g., charge, refund, void).

string

Filter by transaction status (e.g., SUCCESS, FAILED, PENDING).

string

Filter by payment method type (e.g., card, bank).

string

Filter transactions by customer ID.

string

Filter transactions by payment method ID.

number

Filter transactions with a total greater than or equal to this value.

number

Filter transactions with a total less than or equal to this value.

integer
enum

Filter by pre-authorization status. Use 1 to show only pre-auth transactions, 0 to exclude them.

Allowed:
integer
enum

Filter by capture status. Use 1 to show only captured transactions, 0 to show uncaptured.

Allowed:
integer
enum
Defaults to 0

Controls visibility of transactions flagged as suspected fraud. Flagged transactions are hidden by default. Pass 1 to include flagged transactions alongside all other results. Omit or pass 0 to keep flagged transactions hidden.

Allowed:
integer
1 to 200

Number of results per page (min: 1, max: 200).

integer

Page number for pagination.

string

Field to sort results by (e.g., created_at, total).

string
enum

Sort order: ASC for ascending, DESC for descending.

Allowed:
string
enum

Filter by currency code.

Allowed:
string

Export transactions in the specified format (e.g., json, csv).

Responses
200

Returns a paginated list of transaction objects matching the filter criteria.

400

Invalid query parameters.

401

Authentication failed.

422

Validation failed for one or more query parameters.

500

An unexpected error occurred on the server.

Language
Credentials
Bearer
JWT
LoadingLoading…
Response
Click Try It! to start a request and see the response here!