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 support the following operator: =.
- SetupIntent support the following operator: =.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:
To query the SetupAttempts we can try the below queries.
SELECT * FROM SetupAttempts
SELECT * FROM SetupAttempts where setupintent = 'seti_1Ogg5h2eZvKYlo2CRdyp2Ggk'
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 |