Tables
The connector models the data in Stripe as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Stripe Tables
| Name | Description |
| Accounts | Returns the connected accounts that you manage in Stripe, including business profile, company, individual, and account settings details. |
| BankAccounts | Returns the bank accounts attached to a customer in Stripe, including account holder, routing, and payout details. |
| BankAccountTokens | Returns the bank account tokens in Stripe, which represent a bank account in a way that can be securely shared and used to create payment sources. |
| BillingAlerts | Returns the billing alerts in Stripe, including the alert type, status, and usage threshold details. |
| Cards | Returns the cards attached to a customer in Stripe, including the card brand, expiration, billing address, and funding details. |
| CardTokens | Returns the card tokens in Stripe, which represent a card in a way that can be securely shared and used to create payment sources. |
| Charges | Returns the charges in Stripe, including the amount, currency, customer, payment method, and status of each charge. |
| CheckoutSession | Represents a customer's session as they pay for one-time purchases or subscriptions through Checkout or Payment Links, including session status, payment, and customer details. |
| ClimateOrders | Represents Climate orders for carbon removal, including order amounts, delivery details, and beneficiary information. |
| Coupons | Represents coupons that apply discounts to customers, including discount amount, duration, redemption limits, and applicability details. |
| CreditGrants | Represents billing credit grants applied to customers, including credit amount, category, applicability scope, and effective and expiration details. |
| CreditNotes | Creates, updates, and queries a credit note to adjust an invoice's amount after the invoice is finalized. |
| CryptoOnrampSessions | DEPRECATED. Represents Crypto Onramp Sessions that let customers convert fiat to crypto, including session status, transaction details, and wallet addresses. |
| Customers | Represents the customers in a Stripe account, including contact, address, billing, tax, and discount details. |
| Disputes | Returns payment disputes, including evidence, dispute reason, and resolution status details. |
| EventDestinations | Returns event destinations, including their type, enabled events, and delivery configuration details. |
| InvoiceItems | Returns invoice items, including their amount, customer, billing period, and pricing details. |
| Invoices | Returns invoices, including their amounts, status, billing, payment, and rendering details. |
| Meters | Represents billing meters used to track and aggregate customer usage, including aggregation settings, event mapping, and status details. |
| PaymentIntent | A PaymentIntent guides you through the process of collecting a payment from your customer. |
| PaymentLinks | Represents shareable payment links, including completion behavior, payment configuration, and checkout settings. |
| PaymentMethodConfigurations | Represents payment method configurations that control which payment methods are offered at checkout and their display preferences. |
| PaymentMethods | Represents payment methods used to collect payments, including billing details and method-specific information such as card, bank account, and wallet data. |
| Payouts | Represents payouts of funds to a bank account or debit card, including amount, status, destination, and reconciliation details. |
| Persons | Represents persons associated with a connected account, including identity, address, relationship, and verification details. |
| Plans | [DEPRECATED endpoint, use Prices instead.] Represents subscription plans that define recurring pricing, including billing interval, amount, and associated product details. |
| Prices | Represents prices that define the cost and billing behavior for products, including unit amounts, currency, and recurring details. |
| Products | Represents products available for sale, including pricing, descriptive, and shipping details. |
| PromotionCodes | Creates, updates, and retrieves a promotion code that represents a customer-redeemable code for a coupon. |
| Quotes | Creates, updates, and queries the quotes available. |
| Refunds | Represents refunds issued against charges or payment intents, including amount, status, and destination details. |
| ShippingRates | Returns the available shipping rates, including delivery estimates, fixed amounts, and tax behavior details. |
| SubscriptionItems | Represents the items on a subscription, including the associated plan, price, quantity, tax rates, and billing period details. |
| Subscriptions | Represents customer subscriptions, including the associated plan, billing cycle and collection settings, trial periods, and applied discounts. |
| TaxIds | Represents tax Ids, including the owner reference, tax Id type and value, and verification status details. |
| TaxRates | Represents the tax rates applied to invoices, subscriptions, and Checkout sessions to collect tax, including the percentage, jurisdiction, and tax type details. |
| TestClocks | Represents test clocks used to simulate the passage of time in test mode, including the frozen time and current status details. |
| TopUps | Represents top-ups of the Stripe balance, including the amount, currency, source, and status details. |
| TransferReversals | Represents the reversals belonging to a specific transfer, including the reversed amount, linked refunds, and balance transaction details. |
| Transfers | Represents transfers of funds to connected accounts or bank accounts, including the amount, destination, source transaction, and reversal details. |
| UsageRecords | [DEPRECATED] Creates and returns customer usage records and summaries for metered billing of subscription prices, including usage quantities and billing periods. |
| ValueListItems | Represents the items within a radar value list, including the item value and creator details. |
| ValueLists | Represents radar value lists used in rules, including the list name, alias, item type, and creator details. |