ADO.NET Provider for Stripe

Build 24.0.9062

Cardholders

Returns a list of Issuing Cardholder objects. The objects are sorted in descending order by creation date, with the most recently created object appearing first.

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: =.
  • Created supports the following operator: =.
  • Email supports the following operator: =.
  • PhoneNumber supports the following operator: =.
  • Status supports the following operator: =.
  • Type supports the following operator: =.

You can select from BalanceTransactions with the following queries:

    SELECT * FROM Cardholders WHERE Id = 'ich_1OctV22eZvKYlo2C6ETSndgk'
    SELECT * FROM Cardholders WHERE Created = '2024-01-18 02:16:47.0'
    SELECT * FROM Cardholders WHERE PhoneNumber = '+1234567890'
    SELECT * FROM Cardholders WHERE Email = '[email protected]'

Columns

Name Type References Description
Id [KEY] String Unique identifier for the object.
BillingAddressCity String City, district, suburb, town, or village.
BillingAddressCountry String Two-letter country code
BillingAddressLine1 String Address line 1
BillingAddressLine2 String Address line 2
BillingAddressPostalCode String ZIP or postal code.
BillingAddressState String State, county, province, or region.
Email String The cardholders email address.
MetadataAggregate String The set of key/value pairs that you can attach to a an object.
Name String The cardholders name. This will be printed on cards issued to them.
IsCompanyTaxIdProvided Boolean The cardholders phone number.
Created Datetime Time at which the object was created. Measured in seconds since the Unix epoch.
Individual String Additional information about an individual cardholder.
Livemode Boolean Has the value true if the object exists in live mode or the value false if the object exists in test mode.
Object String String representing the objects type. Objects of the same type share the same value.
PhoneNumber String The cardholders phone number.
RequirementsDisabledReason String If disabled_reason is present, all cards will decline authorizations with cardholder_verification_required reason.
RequirementsPastDue String Array of fields that need to be collected in order to verify and re-enable the cardholder.
SpendingControlsAllowedCategories String Array of strings containing categories of authorizations to allow.
SpendingControlsBlockedCategories String Array of strings containing categories of authorizations to decline.
SpendingControlsSpendingLimits String Limit spending with amount-based rules that apply across this cardholders cards.
SpendingControlsSpendingLimitsCurrency String Currency of the amounts within spending_limits.
Status String Specifies whether to permit authorizations on this cardholders cards.
Type String One of individual or company.
PreferredLocales String The cardholder's preferred locales (languages), ordered by preference. Locales can be de, en, es, fr, or it. This changes the language of the 3D Secure flow and one-time password messages sent to the cardholder.
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062