ADO.NET Provider for Stripe

Build 23.0.8771

Cards

Create, update, delete and query the available Cards in Stripe.

Table Specific Information

This table is deprecated. Use the PaymentMethods table instead.

Select

Server-Side Query Support

The 本製品 uses the Stripe API to filter the results by Id, CustomerId and AccountId. They support equals (=) operator.

The rest of the filter is executed client-side within the 本製品.

To query the Cards table, you must specify a CustomerId:

SELECT * FROM Cards WHERE CustomerId = 'cus_12345678'

In addition to the CustomerId, Stripe supports the use of all columns in the WHERE clause of a SELECT statement, if SupportEnhancedSQL is set to True. If you set the SupportEnhancedSQL property to False, you can still retrieve a Card by specifying its Id:

SELECT * FROM Cards WHERE CustomerId = 'cus_12345678' AND Id = 'ca_12345678'

Insert

You can insert a Card Token and then insert the Token Id to Cards:

INSERT INTO CardTokens (ExpMonth, ExpYear, Number) VALUES (11, 2018, 4242424242424242 )
INSERT INTO Cards (CustomerId, Token) VALUES ('cus_123456778', 'tok_1234345565' )
INSERT INTO Cards (CustomerId,ExpMonth,ExpYear,Number,Object,Country) VALUES ('cus_PARXAI77xUsWw1',6,'2025','4242424242424242','card','russia')

Update

To update a Card, specify both the Id and CustomerId:

UPDATE Cards SET ExpMonth = '06', ExpYear = '2018', AddressCity = 'Houghton Street London' WHERE Id = 'ca_12345678' AND CustomerId = 'cus_123456778'

Delete

To delete a Card, specify both the Id and CustomerId:

DELETE FROM Cards WHERE Id = 'ca_12345678' AND CustomerId = 'cus_123456778'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The card Id.

CustomerId [KEY] String False

The customer Id this card belongs to.

ExpMonth Integer False

The card expiry month.

ExpYear Integer False

The card expiry year.

Currency String False

Only applicable on accounts (not customers or recipients). The card can be used as a transfer destination for funds in this currency.

Account String True

The account Id this card belongs to.

Token String False

The token Id.

AddressCity String False

The city address.

AddressCountry String False

Billing address country, if provided when creating card.

AddressLine1 String False

The address line 1.

AddressLine1Check String True

If AddressLine1 was provided. Possible values: pass, fail, unavailable, or unchecked.

AddressLine2 String False

The address line 2.

AddressState String False

The address state.

AddressZip String False

The address ZIP.

AddressZipCheck String True

If AddressZip was provided. Possible values: pass, fail, unavailable, or unchecked.

Brand String True

Card brand.

Country String True

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.

CvcCheck String True

If a CVC was provided. Possible values: pass, fail, unavailable, or unchecked.

Cvc String False

Card security code. Highly recommended to always include this value, but it’s required only for accounts based in European countries.

DefaultForCurrency Boolean False

Only applicable on accounts (not customers or recipients). This indicates whether or not this card is the default external account for its currency.

Number String False

The card number.

Fingerprint String True

Uniquely identifies this particular card number.

Funding String True

Card funding type.

Last4 String True

Last 4 digits of the card.

Name String False

Cardholder name.

Recipient String True

The recipient that this card belongs to.

TokenizationMethod String True

If the card number is tokenized, this is the method that was used.

Metadata String False

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.

Object String False

String representing the object's type. Objects of the same type share the same value.

AvailablePayoutMethods String True

A set of available payout methods for this card. Only values from this set should be passed as the method when creating a payout.

DynamicLast4 String True

(For tokenized numbers only.) The last four digits of the device account number.

Pseudo-Columns

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

Name Type Description
AccountId String

The Id of the connected account to get cards for.

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