IssuingCards
Returns a list of Issuing Card objects.
Table Specific Information
Select
Server-Side Query Support
The 本製品 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 本製品.
- 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 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
AccountId | String | The Id of the connected account to get files for. |