JDBC Driver for Stripe

Build 22.0.8462

CardTokens

Create and query the available Card Tokens in Stripe.

Table Specific Information

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 supports the following operator: =.

To query CardTokens table, the Id of desired token is required:

SELECT * FROM CardTokens WHERE Id='tok_12345678'

Insert

The ExpMonth, ExpYear, and Number are required to insert a new Card Token.

INSERT INTO CardTokens (ExpMonth, ExpYear, Number) VALUES (11, 2018, 4242424242424242)

Update

Update is not supported.

Delete

Delete is not supported.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the token.

CardId String False

The Id of card (used in conjunction with a customer or recipient Id)

AddressCity String False

The city address of the card.

AddressCountry String False

The country address of the card.

AddressLine1 String False

The address line 1.

AddressLine1Check String False

If address_line1 was provided.

AddressLine2 String False

The address line 2.

AddressState String False

The address state.

AddressZip String False

The zip address.

AddressZipCheck String False

If address_zip was provided.

Brand String False

The card brand.

Country String False

Two-letter ISO code representing the country the bank account/card is located in.

Currency String False

The currency of the card.

CvcCheck String False

If a CVC was provided.

DynamicLast4 String False

The last four digits of the device account number.

ExpMonth Integer False

The card expiration month.

ExpYear Integer False

The card expiration year.

Last4 String True

Last4.

Fingerprint String False

Uniquely identifier.

Funding String False

Card funding type.

Name String False

Cardholder name.

MetadataAggregate String False

The card metadata object.

TokenizationMethod String True

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

ClientIp String False

The IP address of the client that generated the token.

Created Datetime True

The datetime of the token.

Used Boolean False

Whether or not this token has already been used.

Number String False

The card number.

LiveMode Boolean False

Has the value true if the object exists in live mode or the value false if the object exists in test mode.

Type String False

Type of token.

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
CustomerId String

The Id of the customer to create a token for.

AccountId String

The Id of the connected account to get card tokens for.

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