SSIS Components for Stripe

Build 24.0.9062

SetupAttempts

Returns a list of SetupAttempts that associate with a provided SetupIntent.

Table Specific Information

Select

Server-Side Query Support

The 本製品 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 本製品.

  • 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062