CData Python Connector for Stripe

Build 23.0.8839

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 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: =.
  • Created support the following operator: =.
  • Email support the following operator: =.
  • PhoneNumber support the following operator: =.
  • Status support the following operator: =.
  • Type 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 Cardholders we can try the below queries.

SELECT * from Cardholders where Id = 'ich_1OctV22eZvKYlo2C6ETSndgk'

SELECT * from Cardholders where Created = '2024-01-18 02:16:47.0'

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.

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