SetupAttempts
Returns the setup attempts associated with a given setup intent, including payment method details, confirmation results, and any setup errors encountered.
View-Specific Information
SELECT
The connector uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.
| Column | Supported Operators |
| SetupIntent | = |
| Created | =, >, >=, <, <= |
You can select from SetupAttempts with the following queries:
SELECT * FROM SetupAttempts WHERE setupintent = 'seti_1Ogg5h2eZvKYlo2CRdyp2Ggk'
SELECT * FROM SetupAttempts WHERE Created >= '2024-01-01'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the setup attempt. | |
| Object | String | The string representing the object's type. Objects of the same type share the same value. | |
| Application | String | The value of the application on the setup intent at the time of this confirmation. | |
| AttachToSelf | Boolean | Indicates whether the setup intent's payment method is attached to the in-context Stripe account. If present, the payment method is attached to that account. | |
| Created | Datetime | The time at which the setup attempt was created, measured in seconds since the Unix epoch. | |
| Customer | String |
Customers.Id | The value of the customer on the setup intent at the time of this confirmation. |
| FlowDirections | String | The directions of money movement for which this payment method is intended to be used. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. Has the value true if the object exists in live mode, or the value false if the object exists in test mode. | |
| OnBehalfOf | String | The value of on_behalf_of on the setup intent at the time of this confirmation. | |
| PaymentMethod | String | The Id of the payment method used with this setup attempt. | |
| PaymentMethodDetailsAcssDebit | String | If this is a acss_debit payment method, this hash contains confirmation-specific information for the acss_debit payment method. | |
| PaymentMethodDetailsAuBecsDebit | String | If this is a au_becs_debit payment method, this hash contains confirmation-specific information for the au_becs_debit payment method. | |
| PaymentMethodDetailsBacsDebit | String | If this is a bacs_debit payment method, this hash contains confirmation-specific information for the bacs_debit payment method. | |
| PaymentMethodDetailsBanContactBankCode | String | The bank code of the bank associated with the bank account. | |
| PaymentMethodDetailsBanContactBankName | String | The name of the bank associated with the bank account. | |
| PaymentMethodDetailsBanContactBIC | String | The Bank Identifier Code of the bank associated with the bank account. | |
| PaymentMethodDetailsBanContactGeneratedSepaDebit | String | The Id of the SEPA Direct Debit payment method generated by this setup attempt. | |
| PaymentMethodDetailsBanContactGeneratedSepaDebitMandate | String | The mandate for the SEPA Direct Debit payment method generated by this setup attempt. | |
| PaymentMethodDetailsBanContactIBanLast4 | String | The last four characters of the IBAN. | |
| PaymentMethodDetailsBanContactPreferredLanguage | String | The preferred language of the Bancontact authorization page that the customer is redirected to. | |
| PaymentMethodDetailsBanContactVerifiedName | String | The owner's verified full name. | |
| PaymentMethodDetailsBoleto | String | If this is a boleto payment method, this hash contains confirmation-specific information for the boleto payment method. | |
| PaymentMethodDetailsCardBrand | String | The brand of the card. | |
| PaymentMethodDetailsCardChecks | String | The check results from the card networks on the card address and CVC at the time of authorization. | |
| PaymentMethodDetailsCardCountry | String | The two-letter ISO code representing the country of the card. | |
| PaymentMethodDetailsCardExpMonth | String | The two-digit number representing the card's expiration month. | |
| PaymentMethodDetailsCardExpYear | String | The four-digit number representing the card's expiration year. | |
| PaymentMethodDetailsCardFingerprint | String | The value that uniquely identifies this particular card number. | |
| PaymentMethodDetailsCardFunding | String | The funding type of the card. | |
| PaymentMethodDetailsCardLast4 | String | The last four digits of the card. | |
| PaymentMethodDetailsCardNetwork | String | The network on which this charge was processed. | |
| PaymentMethodDetailsCardThreeDSecure | String | The 3D Secure details, populated if this authorization used 3D Secure authentication. | |
| PaymentMethodDetailsCardWallet | String | The details of the card wallet, if this card is part of a card wallet. | |
| PaymentMethodDetailsCardPresent | String | If this is a card_present payment method, this hash contains confirmation-specific information for the card_present payment method. | |
| PaymentMethodDetailsCashApp | String | If this is a cashapp payment method, this hash contains confirmation-specific information for the cashapp payment method. | |
| PaymentMethodDetailsIdealBank | String | The customer's bank. | |
| PaymentMethodDetailsIdealBIC | String | The Bank Identifier Code of the customer's bank. | |
| PaymentMethodDetailsIdealGeneratedSepaDebit | String | The Id of the SEPA Direct Debit payment method generated by this setup attempt. | |
| PaymentMethodDetailsIdealGeneratedSepaDebitMandate | String | The mandate for the SEPA Direct Debit payment method generated by this setup attempt. | |
| PaymentMethodDetailsIdealIBanLast4 | String | The last four characters of the IBAN. | |
| PaymentMethodDetailsIdealVerifiedName | String | The owner's verified full name. | |
| PaymentMethodDetailsKlarna | String | If this is a klarna payment method, this hash contains confirmation-specific information for the klarna payment method. | |
| PaymentMethodDetailsLink | String | If this is a link payment method, this hash contains confirmation-specific information for the link payment method. | |
| PaymentMethodDetailsPaypal | String | If this is a paypal payment method, this hash contains confirmation-specific information for the paypal payment method. | |
| PaymentMethodDetailsSepaDebit | String | If this is a sepa_debit payment method, this hash contains confirmation-specific information for the sepa_debit payment method. | |
| PaymentMethodDetailsSoFortBankCode | String | The bank code of the bank associated with the bank account. | |
| PaymentMethodDetailsSoFortBankName | String | The name of the bank associated with the bank account. | |
| PaymentMethodDetailsSoFortBIC | String | The Bank Identifier Code of the bank associated with the bank account. | |
| PaymentMethodDetailsSoFortGeneratedSepaDebit | String | The Id of the SEPA Direct Debit payment method generated by this setup attempt. | |
| PaymentMethodDetailsSoFortGeneratedSepaDebitMandate | String | The mandate for the SEPA Direct Debit payment method generated by this setup attempt. | |
| PaymentMethodDetailsSoFortIBanLast4 | String | The last four characters of the IBAN. | |
| PaymentMethodDetailsSoFortPreferredLanguage | String | The preferred language of the Sofort authorization page that the customer is redirected to. | |
| PaymentMethodDetailsSoFortVerifiedName | String | The owner's verified full name. | |
| PaymentMethodDetailsType | String | The type of the payment method used in the setup intent. | |
| PaymentMethodDetailsUsBankAccount | String | If this is a us_bank_account payment method, this hash contains confirmation-specific information for the us_bank_account payment method. | |
| SetupErrorCode | String | A short string indicating the error code reported, for errors that can be handled programmatically. | |
| SetupErrorDeclineCode | String | A short string indicating the card issuer's reason for the decline, for card errors resulting from a card issuer decline, if the issuer provides one. | |
| SetupErrorDocURL | String | A URL to more information about the error code reported. | |
| SetupErrorMessage | String | A human-readable message providing more details about the error. | |
| SetupErrorParam | String | If the error is parameter-specific, the parameter related to the error. | |
| SetupErrorPaymentMethod | String | The payment method object for errors returned on a request involving a payment method. | |
| SetupErrorPaymentMethodType | String | If the error is specific to the type of payment method, the payment method type that had a problem. | |
| SetupErrorType | String | The type of error returned. | |
| SetupIntent | String | The Id of the setup intent that this attempt belongs to. | |
| Status | String | The status of this setup attempt. | |
| Usage | String | The value of usage on the setup intent at the time of this confirmation. | |
| PaymentMethodDetailsKakaoPay | String | If this is a kakao_pay payment method, this hash contains confirmation-specific information for the kakao_pay payment method. | |
| PaymentMethodDetailsKrCard | String | If this is a kr_card payment method, this hash contains confirmation-specific information for the kr_card payment method. | |
| PaymentMethodDetailsNaverPay | String | If this is a naver_pay payment method, this hash contains confirmation-specific information for the naver_pay payment method. | |
| PaymentMethodDetailsAmazonPay | String | If this is an amazon_pay payment method, this hash contains confirmation-specific information for the amazon_pay payment method. | |
| PaymentMethodDetailsCardMoto | Boolean | Indicates whether this payment was marked as MOTO and accepted without 3D Secure authentication. |