JDBC Driver for Stripe

Build 22.0.8462

Cards

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

Table Specific Information

This is a deprecated object. Use PaymentMethods table instead of Cards table.

Select

Server-Side Query Support

The driver 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 driver.

  • Id and CustomerId support the following operator: =.

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 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' )

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.

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

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462