JDBC Driver for Stripe

Build 24.0.9062

CardTokens

Create and query the available Card Tokens in Stripe.

Table Specific Information

Select

Server-Side Query Support

The 本製品 uses 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 本製品.

  • Id supports the following operator: =.

To query the 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)

INSERT INTO CardTokens (AddressCity, AddressCountry, AddressLine1, AddressLine2, AddressZip, Currency, ExpMonth, ExpYear, Name, Number, AddressState) values ('Mohali', 'INDIA', 'TestAddressLine1', 'TestAddressLine2', 123456, 'inr', '01', '2029', 'Tapan Sharma', '4242424242424242', 'Punjab')

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 True

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 True

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 True

If address_zip was provided.

Brand String True

The card brand.

Country String True

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

Currency String False

The currency of the card.

CvcCheck String True

If a CVC was provided.

DynamicLast4 String True

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 True

Uniquely identifier.

Funding String True

Card funding type.

Name String False

Cardholder name.

MetadataAggregate String True

The card metadata object.

TokenizationMethod String True

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

ClientIp String True

The IP address of the client that generated the token.

Created Datetime True

The datetime of the token.

Used Boolean True

Whether or not this token has already been used.

Number String False

The card number.

LiveMode Boolean True

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

Type String True

Type of token.

Pseudo-Columns

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

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