List transactions

GET

/api-v1/transactions

Transactions

Retrieve a paginated list of transactions with optional filters.

Results are sorted by transaction_date in descending order by default.

Filtering

You can combine multiple filters to narrow down results:

Date range: date_from and date_to

Amount range: amount_min and amount_max

Status, category, bank account, etc.

Search

Use the search parameter to perform a text search across:

Transaction description

Original description

Merchant name

Request

Authorization

API Key

Add parameter in header

X-API-Key

Example:

X-API-Key: ********************

JWT Bearer

Add the parameter

Authorization

to Headers

Example:

Authorization: ********************

Query Params

Responses

🟢200

application/json

Paginated list of transactions

Body

🟠401Unauthorized

Request Example

Shell

JavaScript

Java

Swift

curl --location --request GET 'https://gvazyknvkqdeuzmrnuwu.supabase.co/functions/v1/api-v1/transactions?page&limit&bank_account_id=550e8400-e29b-41d4-a716-446655440000&statement_id&status&category=Office Supplies&accounting_category&cash_flow_category&date_from=2025-01-01&date_to=2025-01-31&amount_min=-1000&amount_max=5000&search=amazon&is_reconciled&internal_transaction&sort&order' \
--header 'X-API-Key: <api-key>'

Response Example

200 - Success

{
    "success": true,
    "data": [
        {
            "id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
            "transaction_date": "2025-01-15",
            "posted_date": "2025-01-16",
            "description": "SPEI STRIPE PAYMENTS",
            "original_description": "SPEI STRIPE PAYMENTS SA DE CV REF123456",
            "amount": 15420.5,
            "currency_code": "MXN",
            "exchange_rate": 1,
            "category": "Payment Processing",
            "sub_category": null,
            "accounting_category": "Net Sales",
            "cash_flow_category": "operations",
            "merchant_name": "Stripe",
            "status": "approved",
            "is_reconciled": true,
            "ai_confidence_score": 0.95,
            "tags": [
                "stripe",
                "sales"
            ],
            "bank_account_id": "550e8400-e29b-41d4-a716-446655440000",
            "bank_statement_id": null,
            "created_at": "2025-01-16T08:00:00Z",
            "updated_at": "2025-01-16T10:30:00Z"
        },
        {
            "id": "4fb96g75-6828-5673-c4gd-3d074g77bgb7",
            "transaction_date": "2025-01-14",
            "posted_date": "2025-01-14",
            "description": "Office Supplies - Amazon",
            "original_description": "AMAZON.COM.MX AMZN.COM/BILL",
            "amount": -1250,
            "currency_code": "MXN",
            "exchange_rate": 1,
            "category": "Office Supplies",
            "sub_category": "General",
            "accounting_category": "Administrative Expenses",
            "cash_flow_category": "operations",
            "merchant_name": "Amazon",
            "status": "pending",
            "is_reconciled": false,
            "ai_confidence_score": 0.88,
            "tags": [
                "supplies",
                "office"
            ],
            "bank_account_id": "550e8400-e29b-41d4-a716-446655440000",
            "bank_statement_id": "660f9500-f30c-52e5-b827-557766551111",
            "created_at": "2025-01-14T12:00:00Z",
            "updated_at": "2025-01-14T12:00:00Z"
        }
    ],
    "pagination": {
        "page": 1,
        "limit": 50,
        "total": 234,
        "total_pages": 5,
        "has_more": true
    },
    "meta": {
        "total_income": 125000,
        "total_expenses": -45000,
        "net": 80000
    }
}

Modified at 2025-12-30 00:32:01

Revoke an API key

Create transaction

List transactions

Filtering#

Search#

Request

Responses

Filtering

Search