Schema Information of Stripe Connector
This topic provides a structured reference to assist you in working with Daton's Stripe connector and the associated fields and tables.
Schema Information of Stripe Connector
This topic provides a structured reference to assist you in working with Daton's Stripe connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Stripe connector:
- Invoices
- Customers
- Subscriptions
- Taxrates
- Products
- Coupons
- Refunds
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 |