Stripe

Stripe ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Stripe email Stripe password
Replication Type	Full Replication Key Based Replication
Replication Key	NA
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Invoices	Customers
Subscriptions	TaxRates
Products	Coupons

Refunds

Integrate Stripe with Daton

1. Signin to Daton

2. Select Stripe from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your stripe account email and password to authorize Daton to periodically extract data from stripe.

5. Post successful authentication you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

STRIPE Data

Invoices

Purpose: Invoices are statements of amounts owed by a customer, and are either generated one-off, or generated periodically from a subscription.

Source API Documentation https://stripe.com/docs/api/invoices/list

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
object	STRING
account_country	STRING
account_name	STRING
amount_due	NUMERIC
amount_paid	NUMERIC
amount_remaining	NUMERIC
application_fee_amount	STRING
attempt_count	NUMERIC
attempted	BOOLEAN
auto_advance	BOOLEAN
billing	STRING
billing_reason	STRING
charge	STRING
collection_method	STRING
created	TIMESTAMP
currency	STRING
custom_fields	STRING
customer	STRING
customer_address	STRING
customer_email	STRING
customer_name	STRING
customer_phone	STRING
customer_shipping	STRING
customer_tax_exempt	STRING
customer_tax_ids	STRING
default_payment_method	STRING
default_source	STRING
default_tax-rates	STRING
description	STRING
discount	STRING
due_date	TIMESTAMP
ending_balance	NUMERIC
footer	STRING
hosted_invoice_url	STRING
invoice_pdf	STRING
lines	RECORD
livemode	BOOLEAN
next_payment_attempt	STRING
number	STRING
paid	BOOLEAN
payment_intent	STRING
period_end	TIMESTAMP
period_start	TIMESTAMP
post_payment_credit_notes_amount	NUMERIC
pre_payment_credit_notes_amount	NUMERIC
receipt_number	STRING
starting_balance	NUMERIC
statement_descriptor	STRING
status	STRING
status_transactions	RECORD
subscriptions	STRING
subtotal	NUMERIC
tax	STRING
tax_percent	STRING
total	NUMERIC
total_tax_amounts	RECORD
webhooks_delivered_at	TIMESTAMP

Customers

Purpose: Returns a list of the customers. The customers are returned sorted by creation date, with the most recent customers appearing first.

Source API Documentation https://stripe.com/docs/api/customers/list

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
object	STRING
account_balance	NUMERIC
address	STRING
balance	NUMERIC
created	TIMESTAMP
currency	STRING
default_source	STRING
delinquent	BOOLEAN
description	STRING
discount	STRING
email	STRING
invoice_prefix	STRING
invoice_settings	RECORD
livemode	BOOLEAN
name	STRING
phone	STRING
preferred_locales	STRING
shipping	RECORD
sources	RECORD
subscriptions	RECORD
tax_exempt	STRING
tax_ids	RECORD
tax_info	STRING
tax-info_verification	STRING

Subscriptions

Purpose: By default, returns a list of all subscriptions that have not been canceled. In order to list canceled subscriptions, specify status=canceled

Source API Documentation https://stripe.com/docs/api/subscriptions/list

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
object	STRING
application_fee_percent	STRING
billing	STRING
billing_cycle_anchor	TIMESTAMP
billing_thresholds	STRING
cancel_at	TIMESTAMP
cancel_at_period_end	BOOLEAN
canceled_at	TIMESTAMP
collection_method	STRING
created	TIMESTAMP
current_period_end	TIMESTAMP
current_period_start	TIMESTAMP
customer	STRING
days_until_due	INTEGER
default_payment_method	STRING
default_source	STRING
default_tax_rates	STRING
discount	STRING
ended_at	TIMESTAMP
items	RECORDtaxr
latest_invoice	STRING
livemode	BOOLEAN
pending_setup_intent	STRING
plan	RECORD
quantity	NUMERIC
schedule	STRING
start	TIMESTAMP
start_date	TIMESTAMP
status	STRING
tax_percent	STRING
trial_end	STRING
trial_start	STRING

Taxrates

Purpose:Returns a list of your tax rates. Tax rates are returned sorted by creation date, with the most recently created tax rates appearing first.

Source API Documentation https://stripe.com/docs/api/taxrates/list

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
object	STRING
active	BOOLEAN
created	TIMESTAMP
description	STRING
display_name	STRING
inclusive	BOOLEAN
jurisdiction	STRING
livemode	BOOLEAN
percentage	NUMERIC

Products

Purpose: Store representations of products you sell in Product objects, used in conjunction with SKUs. Products may be physical goods, to be shipped, or digital

Source API Documentation https://stripe.com/docs/api/products

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
object	STRING
active	BOOLEAN
created	TIMESTAMP
deactivate_on	STRING
description	STRING
images	STRING
livemode	BOOLEAN
name	STRING
package_dimensions	STRING
statement_descriptor	STRING
type	STRING
unit_label	STRING
updated	TIMESTAMP

Coupons

Purpose: A coupon contains information about a percent-off or amount-off discount you might want to apply to a customer. Coupons may be applied to invoices or orders. Coupons do not work with conventional one-off charges, but you can implement a custom coupon system in your application.

Source API Documentation https://stripe.com/docs/api/coupons

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
object	STRING
amount_off	NUMERIC
created	TIMESTAMP
currency	STRING
duration	STRING
duration_in_months	STRING
livemode	BOOLEAN
max_redemptions	STRING
name	STRING
percent_off	STRING
redeem_by	TIMESTAMP
times_redeemed	NUMERIC
valid	BOOLEAN

Refunds

Purpose:This API shows a list of all the channels that have already been integrated in your Shiprocket account.

Source API Documentation https://stripe.com/docs/api/refunds

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
object	STRING
amount	NUMERIC
balance_transaction	STRING
charge	STRING
created	TIMESTAMP
currency	STRING
reason	STRING
receipt_number	STRING
source_transfer_reversal	STRING
status	STRING
transfer_reversal	STRING