---
title: "Get transactions by user"
method: GET
path: "/data/transactions"
---

# Get transactions by user

`GET /data/transactions`

## Query parameters

- `nextPage` string
- `limit` number
- `dateFrom` string
- `dateTo` string
- `includeDuplicates` 0 | 1
- `sort` 1 | -1
- `accountId` string
- `connectionId` string
- `type` 'BANK' | 'CARD'
- `providerId` 'yahav-sandbox' | 'yahav' | 'undefined' | 'ubank-sandbox' | 'ubank' | 'pepper' | 'pagi-sandbox' | 'pagi' | 'otsarHahayal-sandbox' | 'otsarHahayal' | 'open-finance-sandbox' | 'open-finance-card-sandbox' | 'mizrahi-sandbox' | 'mizrahi' | 'mercantile-sandbox' | 'mercantile' | 'menora-sandbox' | 'max-sandbox' | 'max' | 'masad-sandbox' | 'masad' | 'leumi-sandbox' | 'leumi' | 'isracard-sandbox' | 'isracard' | 'hapoalim-sandbox' | 'hapoalim' | 'discount-sandbox' | 'discount' | 'cal-sandbox' | 'cal' | 'beinleumi-sandbox' | 'beinleumi' | 'americanExpress'

## Response `200`

Response

- object
  - `nextPage` string, nullable — Represents the total number of items that exists after full pagination. The max transactions per request is 500
  - `items` Transaction[]
    - `id` string — The unique identifier of the transaction
    - `SK` string — Sort key of the transaction
    - `userId` string — The ID of the user associated with the transaction
    - `fileId` string — The ID of the file associated with the transaction
    - `connectionId` string — The ID of the connection associated with the transaction
    - `accountId` string — The ID of the account associated with the transaction
    - `providerId` string — The ID of the provider associated with the transaction
    - `transactionProviderIdentifier` string — Provider-specific identifier for the transaction
    - `accountNumber` string — Account number associated with the transaction
    - `status` string — Status of the transaction
    - `categoryCode` string — Category code of the transaction
    - `amount` object
      - `originalAmount` object
        - `amount` string — Original amount of the transaction
        - `currency` string — Currency of the original amount
      - `chargedAmount` object
        - `amount` string — Charged amount of the transaction
        - `currency` string — Currency of the charged amount
    - `balancePerTransaction` string — Balance per transaction
    - `description` string — Description of the transaction
    - `category` string — Category of the transaction
    - `changedCategory` string — Updated category of the transaction
    - `installments` string — Installment information for the transaction
    - `type` string — Type of the transaction
    - `date` object
      - `valueDate` string — Value date of the transaction
      - `bookingDate` string — Booking date of the transaction
      - `transactionDate` string — Date when the transaction occurred
    - `markupFee` string — Markup fee associated with the transaction
    - `merchantName` string — Name of the merchant associated with the transaction
    - `details` string — Details of the transaction
    - `isInvoiced` boolean — Indicates if the transaction is invoiced
    - `code` string — Transaction code
    - `merchantAddress` string — Address of the merchant
    - `createdAt` string — Date when the transaction was created
    - `updatedAt` string — Date when the transaction was last updated
    - `classification` string — Classification of the transaction
    - `changedClassification` string — Updated classification of the transaction
    - `labels` string[] — Labels associated with the transaction
    - `transactionType` string — The type of the transaction
    - `advisorId` string — The ID of the advisor associated with the transaction

## Other responses

- `400` — userId is not allowed in query for non-admin users
- `401` — Unauthorized access - Invalid access token
- `403` — Forbidden - Access token missing the required permissions to preform this action
- `404` — Route or entity not found
- `500` — Internal server error

---

[API](https://skmtc.net/open-finance/apis/auth.md) · [All operations](https://skmtc.net/open-finance/apis/auth/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/open-finance/auth/versions/b4d401b65c3d/schema)