SetupIntents
Returns a list of SetupIntents.
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.
- 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. |