ADO.NET Provider for Stripe

Build 21.0.7930

Cards

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

Table Specific Information

Select

Server-Side Query Support

The provider will use 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 provider.

  • Id, CustomerId support the following operators:=.

To query Cards table, CustomerId is required:

SELECT * FROM Cards WHERE CustomerId='cus_12345678'

In addition to CustomerId, provider supports all columns to be used as criteria in the Where clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retreive 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' )

Update

To update a Card, specify both 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 for a Customer, specify both Id and CustomerId:

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

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The card Id.

CustomerId [KEY] String False

The customer Id this card belongs to.

ExpMonth Integer False

The card expire month.

ExpYear Integer False

The card expire 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 False

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 False

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 False

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

Brand String False

Card brand.

Country String False

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 False

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

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 expire year.

Fingerprint String False

Uniquely identifies this particular card number.

Funding String False

Card funding type.

Last4 String True

Last 4 digits of the card.

Name String False

Cardholder name.

Recipient String False

The recipient that this card belongs to.

TokenizationMethod String False

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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
AccountId String

The Id of the connected account to get cards for.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930