SetupAttempts
Returns a list of SetupAttempts that associate with a provided SetupIntent.
Table Specific Information
Select
Server-Side Query Support
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.
- Id supports the following operator: =.
- SetupIntent supports the following operator: =.
You can select from SetupAttempts with the following queries:
SELECT * FROM SetupAttempts WHERE Id = 'setupatt_1GhPzLJXTn'
SELECT * FROM SetupAttempts WHERE setupintent = 'seti_1Ogg5h2eZvKYlo2CRdyp2Ggk'
SELECT * FROM SetupAttempts WHERE Status = 'succeeded'
SELECT * FROM SetupAttempts WHERE Created >= '2024-01-01'
SELECT * FROM SetupAttempts WHERE Livemode = true
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the object. | |
| Object | String | String representing the objects type. Objects of the same type share the same value. | |
| Application | String | The value of application on the SetupIntent at the time of this confirmation. | |
| AttachToSelf | Boolean | If present, the SetupIntents payment method will be attached to the in-context Stripe Account. | |
| Created | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
| Customer | String | The value of customer on the SetupIntent at the time of this confirmation. | |
| FlowDirections | String | Indicates the directions of money movement for which this payment method is intended to be used. | |
| Livemode | Boolean | 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 SetupIntent at the time of this confirmation. | |
| PaymentMethod | String | ID of the payment method used with this SetupAttempt. | |
| 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 | Bank code of bank associated with the bank account. | |
| PaymentMethodDetailsBanContactBankName | String | Name of the bank associated with the bank account. | |
| PaymentMethodDetailsBanContactBIC | String | Bank Identifier Code of the bank associated with the bank account. | |
| PaymentMethodDetailsBanContactGeneratedSepaDebit | String | The ID of the SEPA Direct Debit PaymentMethod which was generated by this SetupAttempt. | |
| PaymentMethodDetailsBanContactGeneratedSepaDebitMandate | String | The mandate for the SEPA Direct Debit PaymentMethod which was generated by this SetupAttempt. | |
| PaymentMethodDetailsBanContactIBanLast4 | String | Last four characters of the IBAN. | |
| PaymentMethodDetailsBanContactPreferredLanguage | String | Preferred language of the Bancontact authorization page that the customer is redirected to | |
| PaymentMethodDetailsBanContactVerifiedName | String | Owners 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 | Card brand. | |
| PaymentMethodDetailsCardChecks | String | Check results by Card networks on Card address and CVC at the time of authorization | |
| PaymentMethodDetailsCardCountry | String | Two-letter ISO code representing the country of the card. | |
| PaymentMethodDetailsCardExpMonth | String | Two-digit number representing the cards expiration month. | |
| PaymentMethodDetailsCardExpYear | String | Four-digit number representing the cards expiration year. | |
| PaymentMethodDetailsCardFingerprint | String | Uniquely identifies this particular card number. | |
| PaymentMethodDetailsCardFunding | String | Card funding type. | |
| PaymentMethodDetailsCardLast4 | String | The last four digits of the card. | |
| PaymentMethodDetailsCardNetwork | String | Identifies which network this charge was processed on. | |
| PaymentMethodDetailsCardThreeDSecure | String | Populated if this authorization used 3D Secure authentication. | |
| PaymentMethodDetailsCardWallet | String | If this Card is part of a card wallet, this contains the details of the 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 customers bank. | |
| PaymentMethodDetailsIdealBIC | String | The Bank Identifier Code of the customers bank. | |
| PaymentMethodDetailsIdealGeneratedSepaDebit | String | The ID of the SEPA Direct Debit PaymentMethod which was generated by this SetupAttempt. | |
| PaymentMethodDetailsIdealGeneratedSepaDebitMandate | String | The mandate for the SEPA Direct Debit PaymentMethod which was generated by this SetupAttempt. | |
| PaymentMethodDetailsIdealIBanLast4 | String | Last four characters of the IBAN. | |
| PaymentMethodDetailsIdealVerifiedName | String | Owners 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 | Bank code of bank associated with the bank account. | |
| PaymentMethodDetailsSoFortBankName | String | Name of the bank associated with the bank account. | |
| PaymentMethodDetailsSoFortBIC | String | Bank Identifier Code of the bank associated with the bank account. | |
| PaymentMethodDetailsSoFortGeneratedSepaDebit | String | The ID of the SEPA Direct Debit PaymentMethod which was generated by this SetupAttempt. | |
| PaymentMethodDetailsSoFortGeneratedSepaDebitMandate | String | The mandate for the SEPA Direct Debit PaymentMethod which was generated by this SetupAttempt. | |
| PaymentMethodDetailsSoFortIBanLast4 | String | Last four characters of the IBAN. | |
| PaymentMethodDetailsSoFortPreferredLanguage | String | Preferred language of the Sofort authorization page that the customer is redirected to. | |
| PaymentMethodDetailsSoFortVerifiedName | String | Owners verified full name. | |
| PaymentMethodDetailsType | String | The type of the payment method used in the SetupIntent | |
| 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 | For some errors that could be handled programmatically, a short string indicating the error code reported. | |
| SetupErrorDeclineCode | String | For card errors resulting from a card issuer decline, a short string indicating the card issuers reason for the decline if they provide 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 PaymentMethod object for errors returned on a request involving a PaymentMethod. | |
| 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 | ID of the SetupIntent that this attempt belongs to. | |
| Status | String | Status of this SetupAttempt | |
| Usage | String | The value of usage on the SetupIntent at the time of this confirmation |