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 support the following operator: =.
Cardholder support the following operator: =.
Type support the following operator: =.
Created support the following operator: =.
ExpMonth support the following operator: =.
ExpYear support the following operator: =.
Last4 support the following operator: =.
Status 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 IssuingCards we can try the below queries.

SELECT * FROM IssuingCards

SELECT * from IssuingCards where id = 'ic_1Mwg8K2eZvKYlo2C90clp5gj'

SELECT * from IssuingCards where Last4 = '0921'

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.