# Query payments > Query Payment records by payment intent, transaction identifiers, or time range. ```yaml openapi: 3.1.0 info: title: Query payments version: 1.0.0 description: Query Payment records by payment intent, transaction identifiers, or time range. paths: /v1/txn/queryPayments: post: summary: Query payments description: Query Payment records by payment intent, transaction identifiers, or time range. requestBody: required: true content: application/json: schema: type: object properties: merchantNo: type: string description: Merchant number assigned by Onerway. See [Setup](/payments/get-started/setup#retrieve-your-credentials) for how to obtain it. merchantTxnIds: type: string description: Comma-separated merchant transaction numbers used to query Payment records in batch. x-onerway-required: conditional x-onerway-condition: - Provide this field as one query condition. At least one of `merchantTxnIds`, `transactionIds`, `startTime` + `endTime`, or `paymentId` is required. x-onerway-constraints: - kind: range max: 10 unit: IDs text: A single request can include up to 10 comma-separated IDs. transactionIds: type: string description: Comma-separated Onerway transaction numbers used to query Payment records in batch. x-onerway-required: conditional x-onerway-condition: - Provide this field as one query condition. At least one of `merchantTxnIds`, `transactionIds`, `startTime` + `endTime`, or `paymentId` is required. x-onerway-constraints: - kind: range max: 10 unit: IDs text: A single request can include up to 10 comma-separated IDs. paymentId: type: string description: Payment intent ID, transmitted as a JSON string. Use it to retrieve associated transactions and refund records at the Payment level. x-onerway-required: conditional x-onerway-condition: - Provide this field as one query condition. At least one of `merchantTxnIds`, `transactionIds`, `startTime` + `endTime`, or `paymentId` is required. txnTypes: type: string description: Comma-separated transaction types used to filter associated transactions under the Payment. This endpoint supports `SALE` and `REFUND`. enum: - SALE - REFUND x-enum-descriptions: SALE: Payment transaction. REFUND: Refund transaction. x-onerway-constraints: - kind: values text: This endpoint supports only the `SALE` and `REFUND` subset of the shared `TxnTypeEnum`. startTime: type: string description: Start of the query time range, in `yyyy-MM-dd HH:mm:ss` format. x-onerway-required: conditional x-onerway-condition: - Required together with `endTime` when querying by time range. At least one of `merchantTxnIds`, `transactionIds`, `startTime` + `endTime`, or `paymentId` is required. x-onerway-constraints: - kind: rule text: The maximum range between `startTime` and `endTime` is 90 days. endTime: type: string description: End of the query time range, in `yyyy-MM-dd HH:mm:ss` format. x-onerway-required: conditional x-onerway-condition: - Required together with `startTime` when querying by time range. x-onerway-constraints: - kind: consistency text: "`endTime` must be later than `startTime`." - kind: rule text: The maximum range between `startTime` and `endTime` is 90 days. current: type: string description: Payment query page number. `0` and `1` both mean the first page; the response `current` value is always returned as a 1-based page number. size: type: string description: Page size. A single paginated query returns up to `10` records. sign: type: string description: Request signature string. See [Request signing](/payments/get-started/request-signing) for how to generate it. required: - merchantNo - current - sign examples: american-express-cardholder-name-check-failed: summary: American Express cardholder name mismatch value: merchantNo: replace_with_merchant_no paymentId: replace_with_payment_id current: "0" size: "10" sign: "{{SIGN}}" query-payments-by-payment-id: summary: Query payments by payment ID value: current: "1" merchantNo: replace_with_merchant_no paymentId: "2031908578000000000" sign: "{{SIGN}}" size: "10" responses: "200": description: American Express cardholder name mismatch content: application/json: schema: type: object properties: respCode: type: string description: "`20000` means the query request was processed successfully. This is request acceptance, not the business result of each transaction. Other values are error codes. See [Response codes](/payments/api-reference/response-codes)." respMsg: type: string description: Human-readable message for the response code. data: type: object properties: content: type: array description: Payment records matching the query conditions. Each record summarizes related transaction attempts at the payment-intent level. items: type: object properties: paymentId: type: string description: Payment intent ID, transmitted as a JSON string. One `paymentId` can be associated with multiple `transactionId` values. paymentStatus: type: string description: Payment-intent-level status reflecting the lifecycle across multiple attempts under the same `paymentId`. enum: - I - U - P - R - A - O - S - N x-enum-descriptions: I: Initialized payment intent. The payment intent has been created and is waiting for the first payment attempt. U: Pending payment intent. Waiting for the customer to start or complete payment. P: Processing payment intent. A payment attempt is being processed. R: Redirected payment intent. The customer has been redirected to complete an additional step such as 3DS or a local payment page. A: Authorized payment intent. Funds are authorized and waiting for a follow-up action such as capture. O: Open payment intent. The payment intent remains open and can continue to accept new attempts. S: Succeeded payment intent. N: Closed payment intent. The payment intent was closed because it timed out — either no attempt was made or repeated attempts failed. lastTransactionId: type: - string - "null" description: Onerway transaction number for the last transaction attempt under this payment intent. x-onerway-value: nullable: true when: en: Has a value when the payment intent already has a last transaction attempt. Records without a formed transaction attempt can return `null`. zh: 支付意图已有最后一笔交易尝试时有值；未形成交易尝试的记录可为 `null`。 lastPaymentAttempt: type: - object - "null" properties: {} description: Result summary of the last payment attempt. x-onerway-value: nullable: true when: en: Returns `null` when no last payment-attempt summary is available. zh: 没有最后一次支付尝试摘要时返回 `null`。 x-onerway-lifecycle: status: new since: 2026-06-15 description: en: New field for the result summary of the last payment attempt. zh: 最后一次支付尝试结果摘要的新字段。 merchantTxnId: type: string description: Merchant transaction number generated by the merchant for this transaction. merchantTxnOriginalId: type: - string - "null" description: Merchant transaction number for the merchant master order or original transaction. x-onerway-value: nullable: true when: en: Has a value when the payment record is associated with a merchant master order or original transaction. Ordinary single-attempt samples can return `null`. zh: Payment 记录关联商户主订单或原始交易时才有值；普通单笔尝试样例可为 `null`。 txnTime: type: string description: Transaction time for the last attempt, in `yyyy-MM-dd HH:mm:ss` format. txnCompletionTime: type: - string - "null" description: Completion time for the last attempt, in `yyyy-MM-dd HH:mm:ss` format. x-onerway-value: nullable: true when: en: Has a value when the last attempt is completed and a completion time is returned. It can be `null` when no attempt is formed, no completion state has been reached, or the channel is still processing. zh: 最后一次尝试已完成并返回完成时间时有值；未形成交易尝试、未进入完成态或渠道仍在处理时可为 `null`。 productType: type: string description: Payment product scope used by the transaction associated with this payment record. enum: - ALL - CARD - LPMS - PAYMENT_CODE - ORDER_CODE x-enum-descriptions: ALL: Aggregated checkout. Used only for checkout scenarios to open the hosted checkout page. CARD: Card payment. LPMS: Local payment method. PAYMENT_CODE: Payment code. The merchant scans the customer payment code. ORDER_CODE: Order code. The customer scans the merchant order code. x-onerway-constraints: - kind: consistency text: The shared enum is a value dictionary. Endpoint-specific availability can still depend on the query context and documented endpoint behavior. subProductType: type: string description: Transaction processing mode within the payment product scope. enum: - DIRECT - SUBSCRIBE - INSTALLMENT - TOKEN - AUTO_DEBIT x-enum-descriptions: DIRECT: Direct payment. SUBSCRIBE: Subscription payment. INSTALLMENT: Installment payment. TOKEN: Token payment. AUTO_DEBIT: Auto debit. x-onerway-constraints: - kind: consistency text: The shared enum is a value dictionary. Endpoint-specific availability can still depend on the query context and documented endpoint behavior. cardType: type: - string - "null" description: Payment method type or card brand. Card transactions commonly return card-network values; local payment methods can return the payment method name. x-onerway-value: nullable: true when: en: Has a value when the payment method or card type has been selected. It is `null` when no method has been selected or no transaction attempt has been formed. zh: 已选定支付方式 / 卡类型时有值；未选定或未形成交易尝试时为 `null`。 orderAmount: type: string description: Original order amount. Decimal amounts keep two decimal places when applicable. orderCurrency: type: string description: Order currency as a three-letter [ISO 4217](https://en.wikipedia.org/wiki/ISO_4217) currency code. txnAmount: type: - string - "null" description: Transaction amount for the last transaction attempt. x-onerway-value: nullable: true when: en: Has a value when the last transaction attempt produced a transaction amount. It is `null` when no attempt is formed or no transaction amount is produced. zh: 最后一次交易尝试产生交易金额时有值；未形成交易尝试或未产生交易金额时为 `null`。 txnCurrency: type: - string - "null" description: Transaction currency for the last transaction attempt, as a three-letter [ISO 4217](https://en.wikipedia.org/wiki/ISO_4217) currency code. x-onerway-value: nullable: true when: en: Has a value when the last transaction attempt produced a transaction currency. It is `null` when no attempt is formed or no transaction currency is produced. zh: 最后一次交易尝试产生交易币种时有值；未形成交易尝试或未产生交易币种时为 `null`。 arn: type: - string - "null" description: Acquirer Reference Number (ARN), used for reconciliation and dispute handling. x-onerway-value: nullable: true when: en: Has a value only after an ARN is generated and returned for the transaction. zh: 交易生成 ARN 后才有值；未生成或未返回时为 `null`。 appId: type: - string - "null" description: Merchant application ID created by Onerway when the merchant registers a website. x-onerway-value: nullable: true when: en: Has a value when the transaction is associated with a merchant application. zh: 交易关联到商户应用时有值。 website: type: - string - "null" description: Website domain that initiated the transaction. x-onerway-value: nullable: true when: en: Has a value when the transaction source website is recorded. zh: 记录交易来源站点时有值。 cardNumber: type: - string - "null" description: Masked card number, keeping only the first 6 and last 4 digits. x-onerway-value: nullable: true when: en: Has a value when this is a card transaction and masked card information is returned. Even `CARD` records can return `null`. zh: 卡交易且返回卡信息时有值；即使 `CARD` 记录也可能为 `null`。 holderName: type: - string - "null" description: Cardholder name. x-onerway-value: nullable: true when: en: Has a value when this is a card transaction and cardholder information is returned. Even `CARD` records can return `null`. zh: 卡交易且返回持卡人信息时有值；即使 `CARD` 记录也可能为 `null`。 eci: type: - string - "null" description: Electronic Commerce Indicator (ECI), identifying the transaction security level and liability shift. x-onerway-value: nullable: true when: en: Has a value when card transaction or 3DS results return an ECI. zh: 卡交易或 3DS 结果返回 ECI 时有值。 email: type: - string - "null" description: Customer email address. x-onerway-value: nullable: true when: en: Has a value when the customer provides an email address. zh: 客户提供邮箱时有值。 channelRequestId: type: - string - "null" description: Request identifier on the payment-channel or processor side, used for channel-side reconciliation. x-onerway-value: nullable: true when: en: Has a value only after the transaction enters payment-channel processing and the channel generates a request identifier. It is `null` before a channel request is formed. zh: 交易进入支付渠道处理并生成渠道请求标识后才有值；未形成渠道请求时为 `null`。 paymentMethodDetails: type: - object - "null" properties: card: type: - object - "null" properties: holderName: type: string description: Cardholder name. year: type: string description: Card expiration year, using four digits. month: type: string description: Card expiration month, using two digits from `01` to `12`. cardType: type: string description: Card brand or card network. productCategory: type: - string - "null" description: Card product category. enum: - D - P - C - H - R - N - null x-enum-descriptions: D: Debit P: Prepaid C: Credit H: Charge Card R: Deferred Debit N: Unknown x-onerway-value: nullable: true when: en: Has a value when the card network returns a card product category. zh: 卡组织返回卡产品类别时有值。 issuer: type: - string - "null" description: Name of the issuing financial institution. x-onerway-value: nullable: true when: en: Has a value when the issuer can be identified. zh: 可识别发卡行时有值。 cardBinCountry: type: - string - "null" description: Country or region for the card BIN (Bank Identification Number). x-onerway-value: nullable: true when: en: Has a value when the card BIN country or region can be identified. zh: 可识别卡 BIN 所属国家 / 地区时有值。 authorizationCode: type: - string - "null" description: Authorization code returned by the acquirer or issuer. x-onerway-value: nullable: true when: en: Has a value after card transaction authorization succeeds. zh: 卡交易授权成功后才有值。 cardNumber: type: string description: Masked card number, keeping only the first 6 and last 4 digits. checks: type: - object - "null" properties: addressCheck: type: - string - "null" description: AVS street-address verification result. enum: - pass - fail - unavailable - unchecked - notProvided - unsupported - null x-enum-descriptions: pass: The information submitted for verification matches issuer records. fail: The information submitted for verification does not match issuer records. unavailable: The issuer does not support this verification. unchecked: Verification was not performed. notProvided: The information required for this verification was not provided. unsupported: AVS is not supported for this transaction. x-onerway-value: nullable: true when: en: Has a value when AVS street-address verification is performed. zh: 执行 AVS 街道地址校验时有值。 postalCodeCheck: type: - string - "null" description: AVS postal-code verification result. enum: - pass - fail - unavailable - unchecked - notProvided - unsupported - null x-enum-descriptions: pass: The information submitted for verification matches issuer records. fail: The information submitted for verification does not match issuer records. unavailable: The issuer does not support this verification. unchecked: Verification was not performed. notProvided: The information required for this verification was not provided. unsupported: AVS is not supported for this transaction. x-onerway-value: nullable: true when: en: Has a value when AVS postal-code verification is performed. zh: 执行 AVS 邮编校验时有值。 cardholderNameCheck: type: - string - "null" description: American Express AVS result indicating whether the cardholder name matches issuer records. enum: - pass - fail - unavailable - unchecked - notProvided - unsupported - null x-enum-descriptions: pass: The information submitted for verification matches issuer records. fail: The information submitted for verification does not match issuer records. unavailable: The issuer does not support this verification. unchecked: Verification was not performed. notProvided: The information required for this verification was not provided. unsupported: AVS is not supported for this transaction. x-onerway-value: nullable: true when: en: Returns the result when American Express cardholder name verification is performed, or `null` if it is not performed. zh: 执行 American Express 持卡人姓名验证时返回验证结果；未执行时返回 `null`。 avsResultRawCode: type: - string - "null" description: Raw AVS result code returned by the card network. enum: - N - S - U - R - W - Z - X - Y - M - F - D - A - B - P - G - I - C - FD - NP - null x-enum-descriptions: N: Postal code and street address both do not match. S: AVS is not supported. U: Verification service is unavailable. R: The system cannot perform verification. W: Nine-digit postal code matches and address does not match. Z: Five-digit postal code matches and address does not match. X: Nine-digit postal code and address both match. Y: Five-digit postal code and address both match. M: Address and postal code match for an international transaction. F: Address and postal code match for the United Kingdom. D: Address and postal code match for an international transaction. A: Address matches and postal code does not match. B: Address matches and postal code was not verified. P: Postal code matches and address was not verified. G: Non-AVS participant outside the United States. I: International transaction address was not verified. C: Address and postal code were not verified for a non-US Visa card. FD: AVS verification is unavailable. Onerway system code. NP: Address and postal code were not provided. Onerway system code. x-onerway-value: nullable: true when: en: Has a value when the card network or Onerway returns a raw AVS result code. zh: 卡组织或 Onerway 返回原始 AVS 结果码时有值。 threeDSecureResult: type: - object - "null" properties: version: type: string description: 3D Secure protocol version or `UNKNOWN`. authenticationFlow: type: - string - "null" description: 3DS authentication flow type, distinguishing frictionless authentication from challenge authentication. x-onerway-value: nullable: true when: en: Has a value when the 3DS authentication flow can be identified. zh: 可识别 3DS 认证流程时有值。 chargebackLiability: type: string description: 3DS chargeback-liability party or `UNKNOWN`. transStatus: type: - string - "null" description: 3DS ACS authentication result. enum: - Y - N - A - U - R - null x-enum-descriptions: Y: Authentication succeeded. N: Authentication failed. A: Authentication was attempted. U: Authentication could not be completed. R: Authentication was rejected. x-onerway-value: nullable: true when: en: Has a value when the ACS returns an authentication status. zh: ACS 返回认证状态时有值。 transStatusReason: type: - string - "null" description: Detailed reason for the 3DS authentication status. x-onerway-value: nullable: true when: en: Has a value when the 3DS authentication status needs an additional reason. zh: 需要补充说明 3DS 认证状态时有值。 veresEnrolled: type: - string - "null" description: 3DS enrollment result. x-onerway-value: nullable: true when: en: Has a value when the 3DS enrollment result is returned. zh: 3DS enrollment 结果返回时有值。 eci: type: - string - "null" description: Electronic Commerce Indicator (ECI). x-onerway-value: nullable: true when: en: Has a value when 3DS or the card transaction returns an ECI. zh: 3DS 或卡交易返回 ECI 时有值。 cvvResult: type: - string - "null" description: CVV security-code check result. enum: - M - N - P - S - U - I - null x-enum-descriptions: M: CVV matched the issuer record. N: CVV did not match the issuer record. P: CVV processing error. The processor could not verify it because of a technical issue. S: CVV was missing from the card data. U: Verification service unavailable or unknown. I: CVV format is invalid. x-onerway-value: nullable: true when: en: Has a value when the CVV check result is returned. zh: CVV 校验结果返回时有值。 avsFullResult: type: - string - "null" description: Aggregated AVS address verification result. enum: - Y - N - A - Z - U - null x-enum-descriptions: Y: Postal code and street address both match. N: Postal code and street address both do not match. A: Street address matches and postal code does not match. Z: Postal code matches and street address does not match. U: Address verification system is unavailable; this is not a decline reason. x-onerway-value: nullable: true when: en: Has a value when the aggregated AVS result is returned. zh: AVS 综合校验结果返回时有值。 cavvResult: type: - string - "null" description: Cardholder Authentication Verification Value (CAVV) returned by 3DS authentication. It is required for liability shift. x-onerway-value: nullable: true when: en: Has a value when 3DS authentication returns a CAVV. zh: 3DS 认证返回 CAVV 时有值。 description: 3D Secure verification result. x-onerway-value: nullable: true when: en: Has a value when 3DS verification results are returned. zh: 返回 3DS 验证结果时有值。 description: Verification check results, including AVS and 3DS results. x-onerway-value: nullable: true when: en: Has a value when the payment channel returns AVS, 3DS, or CVV verification results. The 2026-06-15 successful-card sample had `card` populated while `checks` was `null`. zh: 支付渠道返回 AVS / 3DS / CVV 验证结果时有值；2026-06-15 成功卡交易样例中 `card` 有值但 `checks` 为 `null`。 description: Card payment method details. x-onerway-value: nullable: true when: en: Has a value when parent `paymentMethodDetails` is present and contains card payment method details. zh: 父级 `paymentMethodDetails` 有值且包含卡支付方式详情时有值。 description: Payment method details. Card information is carried in the `card` child object, including card details and verification check results. x-onerway-value: nullable: true when: en: Has a value when payment method details are returned. Even `CARD` records can return `null`. When non-null, card information is carried in the `card` child object. zh: 返回支付方式详情时有值；即使 `CARD` 记录也可能为 `null`。非 `null` 时卡信息位于 `card` 子对象。 current: type: string description: Returned page number, using 1-based numbering. size: type: number description: Returned page size. A single paginated query returns up to `10` records. totalPages: type: number description: Total number of pages calculated with the current page size. totalElements: type: number description: Total number of Payment records matching the query conditions. description: Business data object containing the Payment record list and pagination information. examples: american-express-cardholder-name-check-failed: summary: American Express cardholder name mismatch value: respCode: "20000" respMsg: Success data: content: - paymentId: replace_with_payment_id paymentStatus: S lastTransactionId: replace_with_transaction_id lastPaymentAttempt: null merchantTxnId: example_merchant_transaction_id merchantTxnOriginalId: null txnTime: 2026-01-15 10:30:00 txnCompletionTime: 2026-01-15 10:30:30 productType: CARD subProductType: DIRECT cardType: AE orderAmount: "100.00" orderCurrency: USD txnAmount: "100.00" txnCurrency: USD arn: null appId: replace_with_app_id website: https://merchant.example.com cardNumber: 370000******0002 holderName: Example Cardholder eci: null email: customer@example.com channelRequestId: replace_with_channel_request_id paymentMethodDetails: card: checks: addressCheck: fail postalCodeCheck: fail cardholderNameCheck: fail avsResultRawCode: W threeDSecureResult: null holderName: Example Cardholder year: "2029" month: "11" cardType: AE productCategory: null issuer: Example American Express Issuer cardBinCountry: US authorizationCode: replace_with_authorization_code cardNumber: 370000******0002 current: "1" size: 10 totalPages: 1 totalElements: 1 ```