IssuingCards

Returns a list of Issuing Card objects.

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 supports the following operator: =.
Cardholder supports the following operator: =.
Type supports the following operator: =.
Created supports the following operator: =.
ExpMonth supports the following operator: =.
ExpYear supports the following operator: =.
Last4 supports the following operator: =.
Status supports the following operator: =.

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 files.
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		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 objects type. Objects of the same type share the same value.
CardholderBillingAddress	String		The cardholders billing address.
CardholderIsCompanyTaxIdProvided	Boolean		Whether the companys business ID number was provided.
CardholderCreated	Datetime		Time at which the object was created. Measured in seconds since the Unix epoch.
CardholderEmail	String		The cardholders email address.
CardholderIndividual	String		Additional information about an individual cardholder.
CardholderName	String		The cardholders name. This will be printed on cards issued to them.
CardholderPhoneNumber	String		The cardholders phone number. This is required for all cardholders who will be creating EU cards. See the 3D Secure documentation for more details.
CardholderPreferredLocales	String		The cardholders preferred locales (languages), ordered by preference.
CardholderRequirementsDisabledReason	String		If disabled_reason is present, all cards will 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 will be blocked. Cannot be set with blocked_categories.
CardholderSpendingControlsBlockedCategories	String		Array of strings containing categories of authorizations to decline. All other categories will be allowed. Cannot be set with allowed_categories.
CardholderSpendingControlsSpendingLimits	String		Limit spending with amount-based rules that apply across this cardholders cards.
CardholderSpendingControlsSpendingLimitsCurrency	String		Currency of the amounts within spending_limits.
CardholderStatus	String		Specifies whether to permit authorizations on this cardholders 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 a 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 objects type. Objects of the same type share the same value.
Brand	String		The brand of the card.
CVC	String		The cards CVC. For security reasons, this is only available for virtual cards.
Livemode	Boolean		Has the value true if the object exists in live mode or the value false if the object exists 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		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 carriers 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 containing representing countries from which authorizations will be allowed. Authorizations from merchants in all other countries will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. US). Cannot be set with blocked_merchant_countries. Provide an empty value to unset this control.
CardholderSpendingControlsBlockedMerchantCountries	String		Array of strings containing representing countries from which authorizations will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. US). Cannot be set with allowed_merchant_countries. Provide an empty value to unset this control.
SpendingControlsAllowedMerchantCountries	String		Array of strings containing representing countries from which authorizations will be allowed. Authorizations from merchants in all other countries will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. US). Cannot be set with blocked_merchant_countries. Provide an empty value to unset this control.
SpendingControlsBlockedMerchantCountries	String		Array of strings containing representing countries from which authorizations will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. 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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。