Already have an account? Sign in

Stripe (v27-02-2015)

Last updated: 9/15/2026

Stripe (v27-02-2015) end of life

This version of Stripe reached end of life on April 15, 2019 and is no longer functioning.

Upgrade to the latest version (v3) to continue replicating data.

Stripe feature snapshot

A high-level look at Stitch's Stripe (v27-02-2015) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Sunset on April 15, 2019	Supported by	Stitch
Stitch plan	Standard	API availability	Not available
Singer GitHub repository	Not applicable
REPLICATION SETTINGS
Anchor Scheduling	Unsupported	Advanced Scheduling	Unsupported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Unsupported	Column selection	Unsupported
Select all	Unsupported
TRANSPARENCY
Extraction Logs	Unsupported	Loading Reports	Supported

Stripe table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 27-02-2015 of this integration.

Charge Dispute Support

Due to the current structure of our Stripe integration and how updates work in the Stripe API, records in this table will not be updated if a related dispute is updated.

You can, however, find this info in the stripe_events table.

stripe_charges Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Charge ID (id)
received_at
amount
amount_refunded
balance_transaction
captured
created
currency
customer_id
description
dispute_id
failure_code
failure_message
fraud_details_stripe_report
fraud_details_user_report
invoice_id
paid
receipt_email
receipt_number
refunded
statement_descriptor
status

stripe_coupons

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: No

The stripe_coupons table contains info about percent or amount-off discounts that may be applied to a customer. Note that coupons only apply to invoices; they don't apply to one-off charges.

Table Info & Attributes

stripe_coupons Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Coupon ID (id)
received_at
created
duration
duration_in_months
metadata__quota_calls
metadata__quota_level
metadata__service
percent_off
times_redeemed
valid

stripe_customers

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: Yes

The stripe_customers table contains info about your Stripe customers. This table allows you to track multiple charges associated with a single customer.

Table Info & Attributes

stripe_customers & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

stripe_customers Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Customer ID (id)
received_at
account_balance
created
currency
delinquent
description
discount_id
email
metadata__id
metadata__extra
metadata__name
metadata__settings
workspace

stripe_events

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: Yes

The stripe_events table contains info about events. When an interesting event occurs, a new event object is created. For example, when a charge succeeds a charge.succeeded event is created; or, when an invoice can't be paid, an invoice.payment_failed event is created.

Table Info & Attributes

stripe_events & Nested Structures

Event Replication

The stripe_events table is sort of a “grab bag” of all events across all endpoints, or tables. For every event that takes place on a parent object, a row will be added to the table.

For example: If a customer account is updated, you’ll see the latest state of the customer’s account info in the stripe_customers table. You’ll also see a row in this table for the actual update event itself.

stripe_events Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Event ID (id)
created
data__object__business_url
data__object__charges_enabled
data__object__country
data__object__default_currency
data__object__default_source
data__object__delinquent
data__object__description
data__object__details_submitted
data__object__discount
data__object__display_name
data__object__email
data__object__id
data__object__managed
data__object__object
data__object__shipping
data__object__sources__data*
data__object__statement_descriptor
data__object__subscriptions__data*
data__object__support_phone
data__object__timezone
data__object__transfers_enabled
livemode
object
pending_webhooks
request
type

stripe_invoice_items

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: No

The stripe_invoice_items table contains info about items contained in customer invoices.

Table Info & Attributes

stripe_invoice_items Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Invoice Item ID (id)
received_at
amount
currency
customer_id
date
description
discountable
invoice_id
period_end
period_start
plan_id
proration
quantity
bigint
subscription_id

stripe_invoices

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: Yes

The stripe_invoices table contains info about customer invoices. Note that this does not include upcoming invoices - see the Table Info section for details.

Table Info & Attributes

stripe_invoices & Nested Structures

Upcoming Invoices

Stitch’s Stripe integration doesn’t currently replicate upcoming invoices, which Stripe defines as “the next upcoming invoice.”

This is due to the way Stripe generates and assigns IDs to invoices. Existing invoices have IDs while upcoming invoices do not. As Stitch uses the id column to identify new data for replication, if an invoice doesn’t have an ID, Stitch will be unable to replicate it.

stripe_invoices Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Invoice ID (id)
received_at
amount_due
attempt_count
attempted
charge_id
closed
currency
customer_id
date
discount_id
ending_balance
forgiven
lines*
next_payment_attempt
paid
period_end
period_start
receipt_number
starting_balance
subscription_id
subtotal
total
webhooks_delivered_at

stripe_plans

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: No

The stripe_plans table contains pricing information for different products and feature levels on your site. For example, you may have a $10/month plan for basic features and a $20/month plan for premium features.

Table Info & Attributes

stripe_plans Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Plan ID (id)
received_at
amount
created
currency
interval
interval_count
metadata__available
metadata__grandfathered
metadata__overage_rows_fee
metadata__overage_rows_per
metadata__quota_calls
metadata__quota_level
metadata__quota_rows
metadata__service
metadata__tier
name
statement_descriptor
trial_period_days

stripe_subscriptions

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: No

The stripe_subscriptions table contains the details of subscription plans your customers belong to.

Table Info & Attributes

stripe_subscriptions Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Subscription ID (id)
received_at
cancel_at_period_end
current_period_end
current_period_start
customer_id
discount_id
metadata__quota_calls
metadata__quota_rows
plan_id
quantity
start
status
trial_end
trial_start
canceled_at

stripe_transfers

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: Yes

The stripe_transfers table contains info about your transfers. A transfer is created any time Stripe sends you money or you initiiate a transfer to a connected account, including bank accounts and debit cards.

Table Info & Attributes

stripe_transfers & Nested Structures

stripe_transfers Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Transfer ID (id)
amount
amount_reversed
application_fee
balance_transaction
created
currency
date
description
destination
destination_payment
failure_code
failure_message
livemode
medata__method
metadata__recipient
metadata__reversals*
reversed
source_transaction
source_type
statement_descriptor
status
type

stripe_transfer_transactions

Replication Method: Key-based Incremental

Primary Key: transfer_id:transaction_id
Contains Nested Structures?: No

The stripe_transfer_transactions table contains transfer and transaction IDs, which will allow you to join transfers with the transactions in the stripe_balance_history table.

Table Info & Attributes

stripe_transfer_transactions Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

transfer_id
transaction_id

stripe_balance_history

Replication Method: Key-based Incremental

Primary Key: id
Contains Nested Structures?: Yes

The stripe_balance_history table contains info about transactions have have contributed to your Stripe account balance, including charges, transfers, etc.

Table Info & Attributes

stripe_balance_history & Nested Structures

stripe_balance_history Attributes

While we try to include everything Stripe has here, this may not be a full list of attributes. Refer to Stripe's documentation for a full list and description of each attribute.

Balance History ID (id)
amount
available_on
created
currency
description
fee
fee_details*
net
source__sourced_transfers__data*
status
type

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here