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