> ## Documentation Index
> Fetch the complete documentation index at: https://developers.portao3.com.br/llms.txt
> Use this file to discover all available pages before exploring further.

# Export card transactions

> Exports a card's transactions as a CSV or Excel file.

The file has one row per `DEBIT` or `CREDIT` transaction of the period, newest first, with the columns `Data da transação` (Brasília time), `Razão social` and `Nome fantasia` (the account's company), `Tipo`, `Valor` (in reais, `1.234,56`), `Descrição` and `Cartão` (the masked card number). Narrow it with `startDate` and `endDate` (both, or neither), `merchantName` and `financialImpactType`, like the transaction list; up to 10,000 transactions fit in one file. `type=csv` returns the text, `type=xlsx` the workbook encoded in base64 — decode it before saving. Use `default` as `walletId` for the organization's main wallet, and send `x-environment: LIVE` for a production card.

Any member of the organization can export a card's transactions.


## OpenAPI

````yaml /api-reference/banking.openapi.json get /realms/{realmId}/organizations/{organizationId}/accounts/{accountId}/wallets/{walletId}/cards/{cardId}/transactions/export
openapi: 3.0.3
info:
  title: Banking
  version: 1.0.0
  description: >-
    Portão 3 banking API. Every endpoint requires a bearer token in the
    Authorization header (Authorization: Bearer <token>) unless its page states
    otherwise; see the Authentication guide. That requirement is not repeated
    per endpoint. Generated by tools/openapi from code (routes + security) and
    the hand-written spec (request/response bodies). Banking attaches a zod
    validationSchema at the route; request bodies are resolved from it (object +
    array roots). Responses have no presenter layer, so they stay tier=unknown.
    Confidence tiers: generated:typed=215 copied:manual=4 unknown=52.
servers:
  - url: https://api.banking.v2.portao3.com.br/
    description: production
  - url: https://api.banking.dev.3pers.com.br/
    description: development
security: []
tags:
  - name: Accounts
  - name: Account Limits
  - name: Wallets
  - name: Cards
  - name: Card Limits
  - name: Cards 3DS
  - name: PIX
  - name: PIX Keys (DICT)
  - name: PIX Charges
  - name: PIX Automatic
  - name: PIX Initiation (Open Finance)
  - name: PIX Infractions (MED)
  - name: Boleto
  - name: Boleto Charges
  - name: TED
  - name: Transfers
  - name: Transactions
  - name: Cashback
  - name: Currency Codes
  - name: Reversals
paths:
  /realms/{realmId}/organizations/{organizationId}/accounts/{accountId}/wallets/{walletId}/cards/{cardId}/transactions/export:
    get:
      tags:
        - Cards
      summary: Export card transactions
      description: Exports a card's transactions as a CSV or Excel file.
      operationId: >-
        getRealmsByRealmIdOrganizationsByOrganizationIdAccountsByAccountIdWalletsByWalletIdCardsByCardIdTransactionsExport
      parameters:
        - name: realmId
          in: path
          required: true
          description: |-
            ID of your realm.

            Format: `UUID`
          schema:
            type: string
            format: uuid
          example: f495ff0c-ab54-4f99-8e92-ca8682e4de9b
        - name: organizationId
          in: path
          required: true
          description: |-
            ID of the organization the card belongs to.

            Format: `UUID`
          schema:
            type: string
            format: uuid
          example: c4bd3f21-dfbd-44e8-8055-68ba15bed410
        - name: accountId
          in: path
          required: true
          description: ID of the organization's account (24 hexadecimal characters).
          schema:
            type: string
            pattern: ^[0-9a-fA-F]{24}$
          example: 66f2a1c7b4d3e80012c9a0b4
        - name: walletId
          in: path
          required: true
          description: >-
            ID of the card's wallet (24 hexadecimal characters), or `default`
            for the organization's main wallet.
          schema:
            type: string
            pattern: ^([0-9a-fA-F]{24}|default)$
          example: 66f2a3d1b4d3e80012c9a0d2
        - name: cardId
          in: path
          required: true
          description: ID of the card (24 hexadecimal characters).
          schema:
            type: string
            pattern: ^[0-9a-fA-F]{24}$
          example: 66f2a4b8b4d3e80012c9a0e1
        - name: x-environment
          in: header
          required: false
          description: >-
            Environment of the card: `LIVE` (production) or `TEST` (sandbox).
            When you omit it, the request runs in `TEST`; any other value is
            rejected.
          schema:
            type: string
            enum:
              - LIVE
              - TEST
          example: LIVE
        - name: type
          in: query
          required: true
          description: >-
            File format: `csv` (comma-separated text) or `xlsx` (an Excel
            workbook, returned base64-encoded).
          schema:
            type: string
            enum:
              - csv
              - xlsx
          example: csv
        - name: startDate
          in: query
          required: false
          description: >-
            Start of the period, inclusive: an ISO 8601 date-time
            (`2026-11-01T03:00:00.000Z`) or date (`2026-11-01`, read as midnight
            UTC). The period applies only when you send both `startDate` and
            `endDate`.
          schema:
            type: string
          example: '2026-11-01T03:00:00.000Z'
        - name: endDate
          in: query
          required: false
          description: End of the period, inclusive, in the same format as `startDate`.
          schema:
            type: string
          example: '2026-12-01T02:59:59.999Z'
        - name: merchantName
          in: query
          required: false
          description: >-
            Only transactions whose merchant name contains this text
            (case-insensitive).
          schema:
            type: string
            maxLength: 256
          example: AIRLINES
        - name: financialImpactType
          in: query
          required: false
          description: >-
            Only transactions with these effects on the balance
            (case-insensitive): `DEBIT` (money out), `CREDIT` (money in) or
            `NONE` (no effect, such as a declined authorization). Other values
            match no transaction.


            ---


            Example (comma-separated list): `?financialImpactType=DEBIT,CREDIT`
          schema:
            type: array
            items:
              type: string
              maxLength: 64
          style: form
          explode: false
      responses:
        '200':
          description: >-
            `application/csv` — CSV text, UTF-8 with a byte-order mark, one
            header row.


            `application/vnd.openxmlformats-officedocument.spreadsheetml.sheet`
            — The Excel workbook, base64-encoded.
          content:
            application/csv:
              schema:
                type: string
                description: CSV text, UTF-8 with a byte-order mark, one header row.
            application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:
              schema:
                type: string
                format: byte
                description: The Excel workbook, base64-encoded.
        '404':
          description: >-
            `ACCOUNT_NOT_FOUND` — No account with this ID exists in the
            organization.


            `WALLET_NOT_FOUND` — No wallet with this ID exists in the account
            and environment.


            `CARD_NOT_FOUND` — No card with this ID exists in the wallet and
            environment.
          content:
            application/json:
              schema:
                type: object
                properties:
                  traceId:
                    type: string
                    description: >-
                      Identifier of the request that failed. Quote it when
                      contacting support.
                    example: 1-68ee2a1b-3c4d5e6f7a8b9c0d1e2f3a4b
                  code:
                    type: string
                    enum:
                      - ACCOUNT_NOT_FOUND
                      - WALLET_NOT_FOUND
                      - CARD_NOT_FOUND
                    description: >-
                      Stable, machine-readable error code. Branch on this, never
                      on `message`.
                  origin:
                    type: string
                    enum:
                      - BANKING
                    description: Service that produced the error.
                  message:
                    type: string
                    description: >-
                      Human-readable explanation. Its wording may change without
                      notice.
                required:
                  - traceId
                  - code
                  - origin
                  - message
              example:
                traceId: 1-68ee2a1b-3c4d5e6f7a8b9c0d1e2f3a4b
                code: ACCOUNT_NOT_FOUND
                origin: BANKING
                message: Account not found
        '422':
          description: >-
            `BAD_REQUEST` — A path or query parameter is invalid — `type` must
            be `csv` or `xlsx`; `fields` lists each one.


            `CARD_TRANSACTIONS_EXPORT_TOO_LARGE` — The period holds more than
            10,000 transactions.
          content:
            application/json:
              schema:
                type: object
                properties:
                  traceId:
                    type: string
                    description: >-
                      Identifier of the request that failed. Quote it when
                      contacting support.
                    example: 1-68ee2a1b-3c4d5e6f7a8b9c0d1e2f3a4b
                  code:
                    type: string
                    enum:
                      - BAD_REQUEST
                      - CARD_TRANSACTIONS_EXPORT_TOO_LARGE
                    description: >-
                      Stable, machine-readable error code. Branch on this, never
                      on `message`.
                  origin:
                    type: string
                    enum:
                      - BANKING
                    description: Service that produced the error.
                  message:
                    type: string
                    description: >-
                      Human-readable explanation. Its wording may change without
                      notice.
                  fields:
                    type: array
                    description: >-
                      One entry per invalid request field (validation errors
                      only).
                    items:
                      type: object
                      properties:
                        field:
                          type: string
                          description: >-
                            Path of the invalid field, e.g. `label` or
                            `values[0].value`.
                          example: label
                        message:
                          type: string
                          description: Why the field was rejected.
                          example: label is required
                        code:
                          type: string
                          description: >-
                            `<FIELD>_<REASON>` — e.g. `LABEL_REQUIRED`,
                            `TYPE_ONE_OF`, `VALUES_VALUE_TYPE_ERROR`.
                          example: LABEL_REQUIRED
                        values:
                          type: array
                          items:
                            type: string
                          description: >-
                            The accepted values, when the field is an
                            enumeration.
                      required:
                        - field
                        - message
                        - code
                required:
                  - traceId
                  - code
                  - origin
                  - message
              example:
                traceId: 1-68ee2a1b-3c4d5e6f7a8b9c0d1e2f3a4b
                code: BAD_REQUEST
                origin: BANKING
                message: >-
                  Bad Request: Your request is invalid or incomplete. Please
                  make sure you are requesting with the right fields.
                fields:
                  - field: type
                    message: 'Invalid option: expected one of "csv"|"xlsx"'
                    code: TYPE_ONE_OF
                    values:
                      - csv
                      - xlsx
        '503':
          description: '`QUERY_TIMEOUT` — The period took too long to read. Narrow it.'
          content:
            application/json:
              schema:
                type: object
                properties:
                  traceId:
                    type: string
                    description: >-
                      Identifier of the request that failed. Quote it when
                      contacting support.
                    example: 1-68ee2a1b-3c4d5e6f7a8b9c0d1e2f3a4b
                  code:
                    type: string
                    enum:
                      - QUERY_TIMEOUT
                    description: >-
                      Stable, machine-readable error code. Branch on this, never
                      on `message`.
                  origin:
                    type: string
                    enum:
                      - BANKING
                    description: Service that produced the error.
                  message:
                    type: string
                    description: >-
                      Human-readable explanation. Its wording may change without
                      notice.
                required:
                  - traceId
                  - code
                  - origin
                  - message
              example:
                traceId: 1-68ee2a1b-3c4d5e6f7a8b9c0d1e2f3a4b
                code: QUERY_TIMEOUT
                origin: BANKING
                message: The period took too long to read. Narrow it.

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.