ODBC Driver for Stripe

Build 23.0.8839

SetupIntents

Returns a list of SetupIntents.

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

  • Customer support the following operator: =.
  • PaymentMethod support the following operator: =.
  • AttachToSelf support the following operator: =.
  • Created 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 SetupIntents we can try the below queries.

SELECT * FROM SetupIntents

SELECT * FROM SetupIntents where Customer = 'cus_PEW7WrieLzCMkW'

Columns

Name Type References Description
Id [KEY] String Unique identifier for the object.
AutomaticPaymentMethodsAllowRedirects String Controls whether this SetupIntent will accept redirect-based payment methods.
AutomaticPaymentMethodsEnabled Boolean Automatically calculates compatible payment methods
Application String ID of the Connect application that created the SetupIntent.
AttachToSelf Boolean If present, the SetupIntent’s payment method will be attached to the in-context Stripe Account.
CancellationReason String Reason for cancellation of this SetupIntent
ClientSecret String The client secret of this SetupIntent. Used for client-side retrieval using a publishable key.
Created Integer Time at which the object was created. Measured in seconds since the Unix epoch.
Customer String ID of the Customer this SetupIntent belongs to
Description String An arbitrary string attached to the object. Often useful for displaying to users.
FlowDirections String Indicates the directions of money movement for which this payment method is intended to be used.
LastSetupErrorCode String For some errors that could be handled programmatically, a short string indicating the error code reported.
LastSetupErrorDeclineCode String For card errors resulting from a card issuer decline, a short string indicating the card issuer’s reason for the decline if they provide one.
LastSetupErrorDocURL String A URL to more information about the error code reported.
LastSetupErrorMessage String A human-readable message providing more details about the error. For card errors, these messages can be shown to your users.
LastSetupErrorParam String If the error is parameter-specific, the parameter related to the error.
LastSetupErrorPaymentMethod String The PaymentMethod object for errors returned on a request involving a PaymentMethod.
LastSetupErrorPaymentMethodType String If the error is specific to the type of payment method, the payment method type that had a problem.
LastSetupErrorType String The type of error returned.
MetadataAggregate String The set of key/value pairs that you can attach to a an object.
LatestAttempt String The most recent SetupAttempt for this SetupIntent.
Livemode Boolean Has the value true if the object exists in live mode or the value false if the object exists in test mode.
Mandate String ID of the multi use Mandate generated by the SetupIntent.
NextAction String If present, this property tells you what actions you need to take in order for your customer to continue payment setup.
PaymentMethod String ID of the payment method used with this SetupIntent.
Status String Status of this SetupIntent
Usage String Indicates how the payment method is intended to be used in the future.
Object String String representing the objects type. Objects of the same type share the same value.
OnBehalfOf String The account (if any) for which the setup is intended.
PaymentMethodConfigurationDetailsId String ID of the payment method configuration used.
PaymentMethodConfigurationDetailsParent String ID of the parent payment method configuration used.
PaymentmethodOptions String Payment method-specific configuration for this SetupIntent.
PaymentMethodTypes String The list of payment method types (e.g. card) that this SetupIntent is allowed to set up.
SingleUseMandate String ID of the single_use Mandate generated by the SetupIntent.

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