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.
This Source is capable of syncing the following core Streams:
- Balance Transactions (Incremental)
- Bank accounts
- Charges (Incremental)
- Coupons (Incremental)
- Customer Balance Transactions
- Customers (Incremental)
- Disputes (Incremental)
- Events (Incremental)
- Invoice Items (Incremental)
- Invoice Line Items
- Invoices (Incremental)
- PaymentIntents (Incremental)
- Payouts (Incremental)
- Plans (Incremental)
- Products (Incremental)
- Refunds (Incremental)
- Subscription Items
- Subscriptions (Incremental)
- Transfers (Incremental)
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.
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.
| Feature | Supported? |
|---|---|
| Full Refresh Sync | Yes |
| Incremental - Append Sync | Yes |
| Incremental - Dedupe Sync | Yes |
| SSL connection | Yes |
| Namespaces | No |
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.
- Stripe Account
- Stripe API Secret Key
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.
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 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 |