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. 1.
    Signin to Daton
  2. 2.
    Select Stripe from Integrations page
  3. 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. 4.
    Provide your stripe account email and password to authorize Daton to periodically extract data from stripe.
  5. 5.
    Post successful authentication you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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
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
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