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:

Notes

The created field is used to organize Incremental streams. Filtration occurs by the date the entity was created, and it is impossible to filter by the update date, since:

  • The Stripe API allows filtering only by the created field for all streams.

  • There is no such field as updated.

    The only alternative way at the moment is to do a Full Refresh sync and filtering client side.

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

Replicate Incremental Deletes

Coming soon

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.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