CustomerSources
Retrieve the available Source object of a Customer.
Table Specific Information
Select
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
Columns
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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
AccountId | String | The Id of the connected account to get cards for. |