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.
View-Specific Information
SELECT
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.
| Column | Supported Operators |
| Id | = |
| Created | =, >, >=, <, <= |
| = | |
| PhoneNumber | = |
| Status | = |
| Type | = |
You can select from Cardholders with the following queries:
SELECT * FROM Cardholders WHERE Id = 'ich_1OctV22eZvKYlo2C6ETSndgk'
SELECT * FROM Cardholders WHERE Created = '2024-01-18 02:16:47.0'
SELECT * FROM Cardholders WHERE PhoneNumber = '+1234567890'
SELECT * FROM Cardholders WHERE Email = '[email protected]'
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 cardholder's email address. | ||
| MetadataAggregate | String | The set of key-value pairs that you can attach to an object. | |
| Name | String | The cardholder's name. This is printed on cards issued to them. | |
| IsCompanyTaxIdProvided | Boolean | Indicates whether the company's business ID number was provided. | |
| Created | Datetime | The date and time at which the object was created, measured in seconds since the Unix epoch. | |
| Individual | String | Additional information about an individual cardholder. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. | |
| Object | String | String representing the object's type. Objects of the same type share the same value. | |
| PhoneNumber | String | The cardholder's phone number. | |
| RequirementsDisabledReason | String | If disabled_reason is present, all cards 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 cardholder's cards. | |
| SpendingControlsSpendingLimitsCurrency | String | The currency of the amounts within spending_limits. | |
| Status | String | Specifies whether to permit authorizations on this cardholder's cards. | |
| Type | String | One of individual or company. | |
| PreferredLocales | String | The cardholder's preferred locales (languages), ordered by preference. Locales can be de, en, es, fr, or it. This changes the language of the 3D Secure flow and one-time password messages sent to the cardholder. | |
| SpendingControlsAllowedMerchantCountries | String | Array of strings representing countries from which authorizations are allowed. Authorizations from merchants in all other countries are declined. Country codes should be ISO 3166 alpha-2 country codes (for example, US). Cannot be set with blocked_merchant_countries. Provide an empty value to unset this control. | |
| SpendingControlsBlockedMerchantCountries | String | Array of strings representing countries from which authorizations are declined. Country codes should be ISO 3166 alpha-2 country codes (for example, US). Cannot be set with allowed_merchant_countries. Provide an empty value to unset this control. |