Stripe

Overview

The Stripe source supports both Full Refresh and Incremental syncs. You can choose if this connector will copy only the new or updated data, or all rows in the tables and columns you set up for replication, every time a sync is run.

Output schema

This Source is capable of syncing the following core Streams:

Note on Incremental Syncs

The Stripe API does not allow querying objects which were updated since the last sync. Therefore, this connector uses the created field to query for new data in your Stripe account.
If your data is updated after creation, you can use the Loockback Window option when configuring the connector to always reload data from the past N days. This will allow you to pick up updates to the data.

Data type mapping

The Stripe API uses the same JSONSchema types that Airbyte uses internally (string, date-time, object, array, boolean, integer, and number), so no type conversions happen as part of this source.

Features

Feature
Supported?
Full Refresh Sync
Yes
Incremental - Append Sync
Yes
Incremental - Dedupe Sync
Yes
SSL connection
Yes
Namespaces
No

Performance considerations

The Stripe connector should not run into Stripe API limitations under normal usage. Please create an issue if you see any rate limit issues that are not automatically retried successfully.

Getting started

Requirements

  • Stripe Account
  • Stripe API Secret Key

Setup guide

Visit the Stripe API Keys page in the Stripe dashboard to access the secret key for your account. Secret keys for the live Stripe environment will be prefixed with sk_live_or rk_live.
We recommend creating a restricted key specifically for Airbyte access. This will allow you to control which resources Airbyte should be able to access. For ease of use, we recommend using read permissions for all resources and configuring which resource to replicate in the Airbyte UI.
If you would like to test Airbyte using test data on Stripe, sk_test_ and rk_test_ API keys are also supported.

Changelog

Version
Date
Pull Request
Subject
0.1.27
2021-12-28
9148
Fix date, arrival\_date fields
0.1.26
2021-12-21
8992
Fix type events.request in schema
0.1.25
2021-11-25
8250
Rearrange setup fields
0.1.24
2021-11-08
7729
Include tax data in checkout_sessions_line_items stream
0.1.23
2021-11-08
7729
Correct payment_intents schema
0.1.22
2021-11-05
7345
Add 3 new streams
0.1.21
2021-10-07
6841
Fix missing start_date argument + update json files for SAT
0.1.20
2021-09-30
6017
Add lookback_window_days parameter
0.1.19
2021-09-27
6466
Use start_date parameter in incremental streams
0.1.18
2021-09-14
6004
Fix coupons and subscriptions stream schemas by removing incorrect timestamp formatting
0.1.17
2021-09-14
6004
Add PaymentIntents stream
0.1.16
2021-07-28
4980
Remove Updated field from schemas
0.1.15
2021-07-21
4878
Fix incorrect percent_off and discounts data filed types
0.1.14
2021-07-09
4669
Subscriptions Stream now returns all kinds of subscriptions (including expired and canceled)
0.1.13
2021-07-03
4528
Remove regex for acc validation
0.1.12
2021-06-08
3973
Add AIRBYTE_ENTRYPOINT for Kubernetes support
0.1.11
2021-05-30
3744
Fix types in schema
0.1.10
2021-05-28
3728
Update data types to be number instead of int
0.1.9
2021-05-13
3367
Add acceptance tests for connected accounts
0.1.8
2021-05-11
3566
Bump CDK connectors
Last modified 25d ago