# Query transaction records

> Query card transaction records with pagination and optional filters.

```yaml
openapi: 3.1.0
info:
  title: Query transaction records
  version: 1.0.0
  description: Query card transaction records with pagination and optional filters.
paths:
  /api/v1/merchant/queryTxnList:
    post:
      summary: Query transaction records
      description: Query card transaction records with pagination and optional filters.
      parameters:
        - name: ApiKey
          in: header
          required: true
          description: Issuing API key request header assigned by Onerway.
          schema:
            type: string
            description: Issuing API key request header assigned by Onerway.
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                txnType:
                  type: string
                  description: Transaction type filter.
                  enum:
                    - AUTHORIZATION
                    - REVERSAL
                    - CLEARING
                    - REFUND
                    - VERIFICATION
                  x-enum-descriptions:
                    AUTHORIZATION: Authorization transaction.
                    REVERSAL: Reversal transaction.
                    CLEARING: Clearing transaction.
                    REFUND: Refund transaction.
                    VERIFICATION: Verification transaction.
                txnStatus:
                  type: string
                  description: Transaction status filter.
                  enum:
                    - S
                    - F
                    - P
                  x-enum-descriptions:
                    S: Succeeded.
                    F: Failed.
                    P: Processing.
                cardId:
                  type: string
                  description: Card ID filter.
                startTime:
                  type: integer
                  description: Query start time, as a UTC timestamp in seconds.
                endTime:
                  type: integer
                  description: Query end time, as a UTC timestamp in seconds.
                pageNum:
                  type: integer
                  description: Page number.
                  x-onerway-constraints:
                    - kind: range
                      min: 1
                pageSize:
                  type: integer
                  description: Page size.
                  x-onerway-constraints:
                    - kind: range
                      min: 1
                      max: 100
              required:
                - pageNum
                - pageSize
            examples:
              default:
                summary: Query transaction records
                value:
                  cardId: "100001"
                  pageNum: 1
                  pageSize: 10
                  txnType: AUTHORIZATION
      responses:
        "200":
          description: Success
          content:
            application/json:
              schema:
                type: object
                properties:
                  respCode:
                    type: string
                    description: Business response code. `20000` means success.
                  respMsg:
                    type: string
                    description: Response message.
                  data:
                    type:
                      - object
                      - "null"
                    properties:
                      totalRecords:
                        type: integer
                        description: Total record count.
                      pageSize:
                        type: integer
                        description: Page size.
                      current:
                        type: integer
                        description: Current page number.
                      pageNum:
                        type: integer
                        description: Current page number.
                      totalPages:
                        type: integer
                        description: Total page count.
                      records:
                        type: array
                        description: Transaction records on the current page.
                        items:
                          type: object
                          properties:
                            txnType:
                              type: string
                              description: Transaction type.
                              enum:
                                - AUTHORIZATION
                                - REVERSAL
                                - CLEARING
                                - REFUND
                                - VERIFICATION
                              x-enum-descriptions:
                                AUTHORIZATION: Authorization transaction.
                                REVERSAL: Reversal transaction.
                                CLEARING: Clearing transaction.
                                REFUND: Refund transaction.
                                VERIFICATION: Verification transaction.
                            txnStatus:
                              type: string
                              description: Transaction status.
                              enum:
                                - S
                                - F
                                - P
                              x-enum-descriptions:
                                S: Succeeded.
                                F: Failed.
                                P: Processing.
                            txnOrderNo:
                              type: string
                              description: Transaction order number.
                            originTxnOrderNo:
                              type:
                                - string
                                - "null"
                              description: Original transaction order number.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No original transaction applies.
                                  zh: 无原交易时返回 `null`。
                            originTxnOrderNoForRefund:
                              type:
                                - string
                                - "null"
                              description: Original payment order number for refund.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No original payment order applies for refund.
                                  zh: 无退款原支付订单时返回 `null`。
                            cardId:
                              type: string
                              description: Card ID or masked card identifier returned by the transaction
                                record.
                            authTime:
                              type:
                                - integer
                                - "null"
                              description: Authorization time, as a UTC timestamp in milliseconds.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No authorization time applies.
                                  zh: 无授权时间时返回 `null`。
                            authorizationCode:
                              type:
                                - string
                                - "null"
                              description: Authorization code.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No authorization code applies.
                                  zh: 无授权码时返回 `null`。
                            authMessageDesc:
                              type:
                                - string
                                - "null"
                              description: Authorization description.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No authorization description applies.
                                  zh: 无授权说明时返回 `null`。
                            transactionAmount:
                              type: number
                              description: Transaction amount.
                            transactionCurrency:
                              type: string
                              description: Transaction currency.
                            transactionTime:
                              type: integer
                              description: Transaction time, as a UTC timestamp in milliseconds.
                            cardAmount:
                              type: number
                              description: Card amount.
                            cardCurrency:
                              type: string
                              description: Card currency.
                            settleAmount:
                              type:
                                - number
                                - "null"
                              description: Settlement amount.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No settlement amount applies.
                                  zh: 无清算金额时返回 `null`。
                            settleCurrency:
                              type:
                                - string
                                - "null"
                              description: Settlement currency.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No settlement currency applies.
                                  zh: 无清算币种时返回 `null`。
                            settleTime:
                              type:
                                - integer
                                - "null"
                              description: Settlement time, as a UTC timestamp in milliseconds.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No settlement time applies.
                                  zh: 无清算时间时返回 `null`。
                            transactionFee:
                              type:
                                - number
                                - "null"
                              description: Transaction fee.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No transaction fee applies.
                                  zh: 无交易手续费时返回 `null`。
                            transactionFeeCurrency:
                              type:
                                - string
                                - "null"
                              description: Transaction fee currency.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No transaction fee applies.
                                  zh: 无交易手续费时返回 `null`。
                            crossBorderFee:
                              type:
                                - number
                                - "null"
                              description: Cross-border fee.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No cross-border fee applies.
                                  zh: 无跨境手续费时返回 `null`。
                            crossBorderFeeCurrency:
                              type:
                                - string
                                - "null"
                              description: Cross-border fee currency.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No cross-border fee applies.
                                  zh: 无跨境手续费时返回 `null`。
                            exchangeFee:
                              type:
                                - number
                                - "null"
                              description: Exchange fee.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No exchange fee applies.
                                  zh: 无换汇手续费时返回 `null`。
                            exchangeFeeCurrency:
                              type:
                                - string
                                - "null"
                              description: Exchange fee currency.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No exchange fee applies.
                                  zh: 无换汇手续费时返回 `null`。
                            merchantId:
                              type:
                                - string
                                - "null"
                              description: Merchant ID from the card transaction.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant descriptor is available.
                                  zh: 无商户描述信息时返回 `null`。
                            merchantName:
                              type:
                                - string
                                - "null"
                              description: Merchant name.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant descriptor is available.
                                  zh: 无商户描述信息时返回 `null`。
                            merchantCountry:
                              type:
                                - string
                                - "null"
                              description: Merchant country.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant country is available.
                                  zh: 无商户国家信息时返回 `null`。
                            merchantCountryCode:
                              type:
                                - string
                                - "null"
                              description: Merchant country code.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant country code is available.
                                  zh: 无商户国家代码时返回 `null`。
                            merchantStateProvince:
                              type:
                                - string
                                - "null"
                              description: Merchant state or province.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant state or province is available.
                                  zh: 无商户州 / 省信息时返回 `null`。
                            merchantCity:
                              type:
                                - string
                                - "null"
                              description: Merchant city.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant city is available.
                                  zh: 无商户城市信息时返回 `null`。
                            merchantPostalCode:
                              type:
                                - string
                                - "null"
                              description: Merchant postal code.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant postal code is available.
                                  zh: 无商户邮编时返回 `null`。
                            merchantMccCode:
                              type:
                                - string
                                - "null"
                              description: Merchant MCC code.
                              x-onerway-value:
                                nullable: true
                                when:
                                  en: No merchant MCC is available.
                                  zh: 无商户 MCC 时返回 `null`。
                        x-onerway-value:
                          empty: true
                          when:
                            en: Returned as an empty array when no transaction matches.
                            zh: 无匹配交易时返回空数组。
                    description: Paginated transaction records.
                    x-onerway-value:
                      nullable: true
                      when:
                        en: Returned as `null` when the query fails.
                        zh: 查询失败时返回 `null`。
              examples:
                success:
                  summary: Success
                  value:
                    respCode: "20000"
                    respMsg: success
                    data:
                      totalRecords: 1
                      pageSize: 10
                      current: 1
                      pageNum: 1
                      totalPages: 1
                      records:
                        - txnType: AUTHORIZATION
                          txnStatus: S
                          txnOrderNo: TXN20260101001
                          originTxnOrderNo: null
                          originTxnOrderNoForRefund: null
                          cardId: "100001"
                          authTime: 1735689600000
                          authorizationCode: AUTH001
                          authMessageDesc: Approved
                          transactionAmount: 50
                          transactionCurrency: USD
                          transactionTime: 1735689600000
                          cardAmount: 50
                          cardCurrency: USD
                          settleAmount: 50
                          settleCurrency: USD
                          settleTime: 1735776000000
                          transactionFee: 0.5
                          transactionFeeCurrency: USD
                          crossBorderFee: null
                          crossBorderFeeCurrency: null
                          exchangeFee: null
                          exchangeFeeCurrency: null
                          merchantId: example_merchant_id
                          merchantName: Example Merchant
                          merchantCountry: United States
                          merchantCountryCode: US
                          merchantStateProvince: WA
                          merchantCity: Seattle
                          merchantPostalCode: "98101"
                          merchantMccCode: "5411"
```
