Stripe

Overview

This page contains the setup guide and reference information for the Stripe source connector.

Output schema

The Stripe source maintains the existing schema of your source database without introducing any changes. Depending on the destination configured in Y42, the destination schema can be altered. See the destination's documentation for more details.

Features

FeatureSupportedNotes
Full Refresh SyncYes
Incremental SyncYes

Supported streams

The Stripe source connector supports the following streams:

StreamTypeNotes
Application Fees (opens in a new tab)Incremental
Application Fee Refunds (opens in a new tab)
Balance Transactions (opens in a new tab)Incremental
Bank accounts (opens in a new tab)
Charges (opens in a new tab)IncrementalThe amount column defaults to the smallest currency unit. (See charge object (opens in a new tab) for more details)
Checkout Sessions (opens in a new tab)
Checkout Sessions Line Items (opens in a new tab)
Coupons (opens in a new tab)Incremental
Customer Balance Transactions (opens in a new tab)
Customers (opens in a new tab)IncrementalThis endpoint does not include deleted customers
Disputes (opens in a new tab)Incremental
Early Fraud Warnings (opens in a new tab)Incremental
Events (opens in a new tab)IncrementalThe Stripe API does not guarantee access to events older than 30 days, so this stream will only pull events created from the 30 days prior to the initial sync and not from the Replication start date.
Invoice Items (opens in a new tab)Incremental
Invoice Line Items (opens in a new tab)
Invoices (opens in a new tab)Incremental
PaymentIntents (opens in a new tab)Incremental
Payouts (opens in a new tab)Incremental
Promotion Code (opens in a new tab)Incremental
Plans (opens in a new tab)Incremental
Products (opens in a new tab)Incremental
Refunds (opens in a new tab)Incremental
SetupIntents (opens in a new tab)Incremental
Subscription Items (opens in a new tab)
Subscription Schedule (opens in a new tab)Incremental
Subscriptions (opens in a new tab)Incremental
Transfers (opens in a new tab)Incremental
Accounts (opens in a new tab)Incremental

Data type mapping

The Stripe API (opens in a new tab) uses the same JSONSchema (opens in a new tab) types as the connector (string, date-time, object, array, boolean, integer, and number), so the Stripe connector doesn't perform any type conversions.

Getting started

Requirements

For utilizing the Stripe source, ensure you have the following:

See the setup guide for more information about how to create the required resources.

Setting up the Stripe source

  1. For Account ID, enter your Stripe Account ID (opens in a new tab).

  2. For Secret Key, enter your Stripe Secret Key (opens in a new tab)

  1. For Replication start date, enter the date in YYYY-MM-DDTHH:mm:ssZ format. Data added on and after this date will be replicated.

  2. For Lookback Window in days (Optional), select the number of days the value in days prior to the start date that you to sync your data with. If your data is updated after setting up this connector, use the this option to reload data from the past N days. For instance, if the Replication start date is set to 2021-01-01T00:00:00Z, then:

    • If you leave the Lookback Window in days parameter to its the default value of 0, data is synced from the Replication start date 2021-01-01T00:00:00Z
    • If the Lookback Window in days value is set to 1, the Replication start date is 2020-12-31T00:00:00Z
    • If the Lookback Window in days value is set to 7, data is synced from 2020-12-25T00:00:00Z

Performance considerations

The Stripe connector should not encounter Stripe API limitations under normal use. If you observe any rate limit issues that are not automatically retried successfully, please contact customer support.

Limitations