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
Signin to Daton
Select Stripe from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your stripe account email and password to authorize Daton to periodically extract data from stripe.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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 |
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 |
Last updated