Stripe

Stripe is an online payment processing platform.

Features

* Connectors created before February 1, 2022, do not have history mode.

Supported environments

Our two Stripe connectors, Stripe and Stripe Test Mode, support the following environments:

Setup guide

Follow our step-by-step Stripe setup guide to connect Stripe with your destination using Fivetran connectors.

Sync overview

We use hard deletes to remove records from the following tables:

• APPLICATION_FEE_REFUND
• CHECKOUT_SESSION_LINE_ITEM
• CHECKOUT_SESSION_LINE_ITEM_DISCOUNT
• CHECKOUT_SESSION_LINE_ITEM_TAX_RATE
• CHECKOUT_SESSION_PAYMENT_METHOD
• CHECKOUT_SESSION_SHIPPING_ADDRESS_ALLOWED_COUNTRIES
• CHECKOUT_SESSION_SHIPPING_OPTION
• CHECKOUT_SESSION_TAX_RATE
• CREDIT_NOTE_LINE_ITEM
• CUSTOMER_BALANCE_TRANSACTION
• CUSTOMER_DISCOUNT
• DISCOUNT
• DISPUTE_BALANCE_TRANSACTION
• FEE
• INVOICE_CUSTOM_FIELD
• INVOICE_DISCOUNT
• INVOICE_ITEM_TAX_RATE
• INVOICE_LINE_ITEM
• INVOICE_LINE_ITEM_TAX_RATE
• INVOICE_TAX_RATE
• ORDER_ITEM
• ORDER_RETURN_ITEM
• PHASE
• PHASE_PLAN
• SETUP_ATTEMPT
• SHIPPING_METHOD
• SUBSCRIPTION_DISCOUNT
• SUBSCRIPTION_ITEM
• SUBSCRIPTION_TAX_RATE
• TIER
• TRANSFER_REVERSAL
• USAGE_RECORD

NOTE: The shape of the resources that the Stripe API retrieves from the Events endpoint depends on the default version of the API used by your Stripe account. Make sure that your Stripe account uses an API version released after February 19, 2019.

To capture new records and updates, we re-import the PLAN table every time we perform a sync for the connector.

Schema information

This schema applies to all Stripe connections created after March 25, 2019.

Schema notes

The CARD table does not include credit card number or CVV code data. Instead, the fingerprint column contains Stripe-provided hashes that uniquely identify each card number. You can use this column to check if two customers who've signed up are using the same card number.

If you want to sync the following columns in the CARD table, contact Stripe support to enable them on your account because these columns are not available in the standard Stripe API requests:

• iin
• description
• issuer

To sync data from the CARD, BANK_ACCOUNT, and SOURCE tables, select the CHARGE, SOURCE, BANK_ACCOUNT, PAYMENT_METHOD, CARD, and ACCOUNT tables in the Schema tab.

To sync PAYMENT_METHOD and its child tables, PAYMENT_METHOD_CARD, AU_BECS_DEBIT, FPX, IDEAL, and SEPA_DEBIT, you must select the SETUP_INTENT, SETUP_ATTEMPT, PAYMENT_INTENT, CUSTOMER, and CHARGE tables in the Schema tab. This is because PAYMENT_METHOD is a child table of these tables. For example:

• If you do not select the PAYMENT_INTENT table, we cannot sync the PAYMENT_METHOD data used in the PAYMENT_INTENTtable and further cannot sync the child tables of the PAYMENT_METHOD table.
• If you do not select the SETUP_INTENT table, we cannot sync the PAYMENT_METHOD data used in SETUP_INTENTand further cannot sync the child tables for the PAYMENT_METHOD table.

To sync data from the DISPUTE, PAYOUT and BALANCE_TRANSACTION tables, select the DISPUTE, PAYOUT, and BALANCE_TRANSACTION tables in the Schema tab.

To sync data from the INVOICE, PRICE and PRODUCT tables, select the INVOICE, PRICE, PRODUCT, INVOICE_TAX_RATE, INVOICE_DISCOUNT, INVOICE_LINE_ITEM, and INVOICE_LINE_ITEM_TAX_RATE tables in the Schema tab.

Connected Accounts

Fivetran supports syncing Connected Accounts data for the following endpoints:

• Events
• Charges
• Payouts
• Balance Transaction
• Apple Pay Domain
• Refunds
• Disputes
• Payment Intent

NOTE: To sync data from connected accounts, select the ACCOUNT table in the Schema tab.

In the connector setup form, set the Sync Connected Accounts toggle to ON.

We populate the connected_account_id column for the supported tables.

NOTE: If you enable this feature during a sync, we perform a historical re-sync of these tables.

Sync overview

On a weekly basis, we re-sync pending balance transactions. During these re-syncs, we sync back to the earliest pending balance transaction that's present in the Stripe account.

NOTE: We do not initiate any action when you click Resync for USAGE_RECORD and SUBSCRIPTION_HISTORY and its child tables. This is because re-syncing these tables might result in the loss of historical data.

Syncing empty tables and columns

Fivetran can sync empty tables and columns for your Stripe connector.

We create a table in the destination even if we can't retrieve the source table data from Stripe. For more information, see our Features documentation.

UTC conversion

We don't convert source timestamps to Universal Time Coordinated (UTC) but use the Stripe account's time zone to store the data in your destination.