ADO.NET Provider for Stripe

Build 23.0.8671


Retrieve the available Source object of a Customer.

Table Specific Information


The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as the SupportEnhancedSQL property is set to True. If SupportEnhancedSQL is set to False, you still can retrieve the Customers Sources list:

SELECT * FROM CustomerSources


Name Type References Description
Id String The Id of the Source object.
CustomerId [KEY] String The Id of the customer.
Brand String The brands of the source.
Country String Two-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you have collected.
ExpiryMonth Integer The card expiry month.
ExpiryYear Integer The card expiry year.
Funding String Card funding type.
Name String Cardholder name.
Last4 String Last 4 digits of the card.
Fingerprint String Uniquely identifies this particular card number.
AddressLine1 String The address line 1.
AddressLine2 String The address line 2.
AddressCity String The address city.
AddressState String The address state.
AddressCountry String The address country.
AddressZip Integer The address ZIP.
Wallet String The wallet details.
TokenizationMethod String If the card number is tokenized, this is the method that was used.
Metadata String Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format.


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

Name Type Description
AccountId String The Id of the connected account to get cards for.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 23.0.8671