Create, update, delete and query the available Cards in Stripe.
Table Specific Information
Server-Side Query Support
The connector 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 connector.
- 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'
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' )
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'
To delete a Card for a Customer, specify both Id and CustomerId:
DELETE FROM Cards WHERE Id='ca_12345678' AND CustomerId='cus_123456778'
The card Id.
The customer Id this card belongs to.
The card expire month.
The card expire year.
Only applicable on accounts (not customers or recipients). The card can be used as a transfer destination for funds in this currency.
The account Id this card belongs to.
The token Id.
The city address.
Billing address country, if provided when creating card.
The address line 1.
If AddressLine1 was provided. Possible values: pass, fail, unavailable, or unchecked.
The address line 2.
The address state.
The address ZIP.
If AddressZip was provided. Possible values: pass, fail, unavailable, or unchecked.
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.
If a CVC was provided. Possible values: pass, fail, unavailable, or unchecked.
Only applicable on accounts (not customers or recipients). This indicates whether or not this card is the default external account for its currency.
The card expire year.
Uniquely identifies this particular card number.
Card funding type.
Last 4 digits of the card.
The recipient that this card belongs to.
If the card number is tokenized, this is the method that was used.
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.
The Id of the connected account to get cards for.