Cardholders
Returns a list of Issuing Cardholder objects. The objects are sorted in descending order by creation date, with the most recently created object appearing first.
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: =.
- Created support the following operator: =.
- Email support the following operator: =.
- PhoneNumber support the following operator: =.
- Status support the following operator: =.
- Type 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 Cardholders we can try the below queries.
SELECT * from Cardholders where Id = 'ich_1OctV22eZvKYlo2C6ETSndgk'
SELECT * from Cardholders where Created = '2024-01-18 02:16:47.0'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the object. | |
| BillingAddressCity | String | City, district, suburb, town, or village. | |
| BillingAddressCountry | String | Two-letter country code | |
| BillingAddressLine1 | String | Address line 1 | |
| BillingAddressLine2 | String | Address line 2 | |
| BillingAddressPostalCode | String | ZIP or postal code. | |
| BillingAddressState | String | State, county, province, or region. | |
| String | The cardholders email address. | ||
| MetadataAggregate | String | The set of key/value pairs that you can attach to a an object. | |
| Name | String | The cardholders name. This will be printed on cards issued to them. | |
| IsCompanyTaxIdProvided | Boolean | The cardholders phone number. | |
| Created | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
| Individual | String | Additional information about an individual cardholder. | |
| Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
| Object | String | String representing the objects type. Objects of the same type share the same value. | |
| PhoneNumber | String | The cardholders phone number. | |
| RequirementsDisabledReason | String | If disabled_reason is present, all cards will decline authorizations with cardholder_verification_required reason. | |
| RequirementsPastDue | String | Array of fields that need to be collected in order to verify and re-enable the cardholder. | |
| SpendingControlsAllowedCategories | String | Array of strings containing categories of authorizations to allow. | |
| SpendingControlsBlockedCategories | String | Array of strings containing categories of authorizations to decline. | |
| SpendingControlsSpendingLimits | String | Limit spending with amount-based rules that apply across this cardholders cards. | |
| SpendingControlsSpendingLimitsCurrency | String | Currency of the amounts within spending_limits. | |
| Status | String | Specifies whether to permit authorizations on this cardholders cards. | |
| Type | String | One of individual or company. |