Stripe
Stripe ETL connector for data replication
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
- 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
- 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
Invoices
Purpose: Invoices are statements of amounts owed by a customer, and are either generated one-off, or generated periodically from a subscription.
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.
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
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.
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
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.
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.
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 modified 8d ago