IssuingCards
Returns issued cards, including cardholder, spending control, shipping, and wallet details.
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 | = |
| CardholderId | = |
| Type | = |
| Created | =, >, >=, <, <= |
| ExpMonth | = |
| ExpYear | = |
| Last4 | = |
| Status | = |
| AccountId | = |
You can select from IssuingCards with the following queries:
SELECT * FROM IssuingCards WHERE Id = 'ic_1Mwg8K2eZvKYlo2C90clp5gj'
SELECT * FROM IssuingCards WHERE CardholderId = '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 issued card. | |
| CancellationReason | String | The reason why the card was canceled. | |
| Currency | String | The three-letter ISO currency code, in lowercase. It must be a supported currency. | |
| Created | Datetime | The time at which the object was created, measured in seconds since the Unix epoch. | |
| CardholderId | String | The unique identifier for the cardholder. | |
| CardholderObject | String | The 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 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, which 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, or languages, ordered by preference. | |
| CardholderRequirementsDisabledReason | String | The reason the cardholder is disabled. If present, all cards decline authorizations with the cardholder_verification_required reason. | |
| CardholderRequirementsPastDue | String | The array of fields that must be collected in order to verify and re-enable the cardholder. | |
| CardholderSpendingControlsAllowedCategories | String | The array of categories of authorizations to allow. All other categories are blocked. This cannot be set with blocked_categories. | |
| CardholderSpendingControlsBlockedCategories | String | The array of categories of authorizations to decline. All other categories are allowed. This cannot be set with allowed_categories. | |
| CardholderSpendingControlsSpendingLimits | String | The amount-based spending limit rules that apply across this cardholder's cards. | |
| CardholderSpendingControlsSpendingLimitsCurrency | String | The currency of the amounts within spending_limits. | |
| CardholderStatus | String | Specifies whether to permit authorizations on this cardholder's cards. | |
| CardholderType | String | The type of the cardholder, such as individual or company. See the 'Choose a cardholder type' documentation for more details. | |
| ExpMonth | Integer | The expiration month of the card. | |
| ExpYear | Integer | The expiration year of the card. | |
| Last4 | String | The last four digits of the card number. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to an object. | |
| Status | String | Indicates whether authorizations can be approved on this card. Activating cards may be blocked depending on past-due cardholder requirements. Defaults to inactive. | |
| Type | String | The type of the card. | |
| Object | String | The 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, which 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 | The shipping address for the card. | |
| ShippingCarrier | String | The delivery company that shipped a card. | |
| ShippingCustoms | String | Additional information that may be required for clearing customs. | |
| ShippingETA | String | The Unix timestamp representing a best estimate of when the card is delivered. | |
| ShippingName | String | The name of the shipment recipient. | |
| ShippingPhoneNumber | String | The phone number of the shipment recipient. | |
| ShippingRequireSignature | Boolean | Indicates whether a signature is required for card delivery. | |
| ShippingService | String | The 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 | The link to the shipping carrier's site where you can view detailed information about a card shipment. | |
| ShippingType | String | The packaging option used for the card shipment. | |
| SpendingControlsAllowedCategories | String | The array of categories of authorizations to allow on this card. All other categories are blocked. | |
| SpendingControlsBlockedCategories | String | The array of categories of authorizations to decline on this card. All other categories are allowed. | |
| SpendingControlsSpendingLimits | String | The amount-based spending limit rules that apply to this card. | |
| SpendingControlsSpendingLimitsCurrency | String | The currency of the amounts within the spending limits for this card. | |
| WalletsApplePay | String | The Apple Pay wallet details for this card. | |
| WalletsGooglePay | String | The Google Pay wallet details for this card. | |
| WalletsPrimaryAccountIdentifier | String | The unique identifier for a card mapped to a digital wallet. | |
| CardholderSpendingControlsAllowedMerchantCountries | String | The array of 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, such as US. This cannot be set with blocked_merchant_countries. Provide an empty value to unset this control. | |
| CardholderSpendingControlsBlockedMerchantCountries | String | The array of countries from which authorizations are declined. Country codes should be ISO 3166 alpha-2 country codes, such as US. This cannot be set with allowed_merchant_countries. Provide an empty value to unset this control. | |
| SpendingControlsAllowedMerchantCountries | String | The array of 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, such as US. This cannot be set with blocked_merchant_countries. Provide an empty value to unset this control. | |
| SpendingControlsBlockedMerchantCountries | String | The array of countries from which authorizations are declined. Country codes should be ISO 3166 alpha-2 country codes, such as US. This cannot be set with allowed_merchant_countries. Provide an empty value to unset this control. | |
| PersonalizationDesign | String | The personalization design object that belongs to this card. | |
| ShippingFulfillmentErrorReason | String | The reason the card shipment fulfillment failed. | |
| FleetCardholder | String | DEPRECATED. The cardholder's answers to prompts presented during transactions. | |
| FleetReportingCurrency | String | DEPRECATED. The currency in which fuel reporting data is denominated. |
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 from which to retrieve issued cards. |