IssuingCards
Returns a list of Issuing Card objects.
View-Specific Information
SELECT
The provider 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 provider.
| Column | Supported Operators |
| Id | = |
| Cardholder | = |
| Type | = |
| Created | =, >, >=, <, <= |
| ExpMonth | = |
| ExpYear | = |
| Last4 | = |
| Status | = |
You can select from IssuingCards with the following queries:
SELECT * FROM IssuingCards WHERE Id = 'ic_1Mwg8K2eZvKYlo2C90clp5gj'
SELECT * FROM IssuingCards WHERE Cardholder = 'cardholder_12345'
SELECT * FROM IssuingCards WHERE Last4 = '0921'
SELECT * FROM IssuingCards WHERE ExpMonth = 12
SELECT * FROM IssuingCards WHERE ExpYear = 2025
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the card. | |
| CancellationReason | String | The reason why the card was canceled. | |
| Currency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| Created | Datetime | The date and time at which the object was created, measured in seconds since the Unix epoch. | |
| CardholderId | String | Unique identifier for the object. | |
| CardholderObject | String | String representing the object's type. Objects of the same type share the same value. | |
| CardholderBillingAddress | String | The cardholder's billing address. | |
| CardholderIsCompanyTaxIdProvided | Boolean | Indicates whether the company's business Id number was provided. | |
| CardholderCreated | Datetime | The date and time at which the object was created, measured in seconds since the Unix epoch. | |
| CardholderEmail | String | The cardholder's email address. | |
| CardholderIndividual | String | Additional information about an individual cardholder. | |
| CardholderName | String | The cardholder's name. This is printed on cards issued to them. | |
| CardholderPhoneNumber | String | The cardholder's phone number. This is required for all cardholders who are creating EU cards. See the 3D Secure documentation for more details. | |
| CardholderPreferredLocales | String | The cardholder's preferred locales (languages), ordered by preference. | |
| CardholderRequirementsDisabledReason | String | If disabled_reason is present, all cards decline authorizations with cardholder_verification_required reason. | |
| CardholderRequirementsPastDue | String | Array of fields that need to be collected in order to verify and re-enable the cardholder. | |
| CardholderSpendingControlsAllowedCategories | String | Array of strings containing categories of authorizations to allow. All other categories are blocked. Cannot be set with blocked_categories. | |
| CardholderSpendingControlsBlockedCategories | String | Array of strings containing categories of authorizations to decline. All other categories are allowed. Cannot be set with allowed_categories. | |
| CardholderSpendingControlsSpendingLimits | String | Limit spending with amount-based rules that apply across this cardholder's cards. | |
| CardholderSpendingControlsSpendingLimitsCurrency | String | Currency of the amounts within spending_limits. | |
| CardholderStatus | String | Specifies whether to permit authorizations on this cardholder's cards. | |
| CardholderType | String | One of individual or company. See Choose a cardholder type for more details. | |
| ExpMonth | Integer | The expiration month of the card. | |
| ExpYear | Integer | The expiration year of the card. | |
| Last4 | String | The last 4 digits of the card number. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to an object. | |
| Status | String | Whether authorizations can be approved on this card. May be blocked from activating cards depending on past-due Cardholder requirements. Defaults to inactive. | |
| Type | String | The type of the card. | |
| Object | String | String representing the object's type. Objects of the same type share the same value. | |
| Brand | String | The brand of the card. | |
| CVC | String | The card's CVC. For security reasons, this is only available for virtual cards. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. | |
| Number | String | The full unredacted card number. | |
| ReplacedBy | String | The latest card that replaces this card, if any. | |
| ReplacementFor | String | The card this card replaces, if any. | |
| ReplacementReason | String | The reason why the previous card needed to be replaced. | |
| ShippingAddress | String | Shipping address. | |
| ShippingCarrier | String | The delivery company that shipped a card. | |
| ShippingCustoms | String | Additional information that may be required for clearing customs. | |
| ShippingETA | String | A unix timestamp representing a best estimate of when the card will be delivered. | |
| ShippingName | String | Recipient name. | |
| ShippingPhoneNumber | String | The phone number of the receiver of the shipment. | |
| ShippingRequireSignature | Boolean | Indicates whether a signature is required for card delivery. | |
| ShippingService | String | Shipment service, such as standard or express. | |
| ShippingStatus | String | The delivery status of the card. | |
| ShippingTrackingNumber | String | A tracking number for a card shipment. | |
| ShippingTrackingURL | String | A link to the shipping carrier's site where you can view detailed information about a card shipment. | |
| ShippingType | String | Packaging options. | |
| SpendingControlsAllowedCategories | String | ||
| SpendingControlsBlockedCategories | String | ||
| SpendingControlsSpendingLimits | String | ||
| SpendingControlsSpendingLimitsCurrency | String | ||
| WalletsApplePay | String | ||
| WalletsGooglePay | String | ||
| WalletsPrimaryAccountIdentifier | String | ||
| CardholderSpendingControlsAllowedMerchantCountries | 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. | |
| CardholderSpendingControlsBlockedMerchantCountries | 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. | |
| 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. | |
| PersonalizationDesign | String | The personalization design object belonging to this card. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get cards for. |