Stripe

Stripe is an online payment processing and credit card processing platform for businesses. Stripe provides the technical, fraud prevention, and banking infrastructure required to operate online payment systems.

Features

Feature name	Supported
Column Hashing	True	Field level
Blocking	True	Field level
Incremental	True
Custom data	False
History	False
ReSync	True	Table level
Templates	True

Data Schema

stripe_invoice_item_tax_rate

evidence_details_due_by

date

evidence_details_has_evidence

boolean

evidence_details_past_due

boolean

evidence_details_submission_count

evidence_access_activity_log

string

evidence_billing_address

string

evidence_cancellation_policy

string

evidence_cancellation_policy_disclosure

string

evidence_cancellation_rebuttal

string

evidence_customer_communication

string

evidence_customer_email_address

string

evidence_customer_name

string

evidence_customer_purchase_ip

string

evidence_customer_signature

string

evidence_duplicate_charge_documentation

string

evidence_duplicate_charge_explanation

string

evidence_duplicate_charge_id

string

evidence_product_description

string

evidence_receipt

string

evidence_refund_policy

string

evidence_refund_policy_disclosure

string

evidence_refund_refusal_explanation

string

evidence_service_date

string

evidence_service_documentation

string

evidence_shipping_address

string

evidence_shipping_carrier

string

evidence_shipping_date

string

evidence_shipping_documentation

string

evidence_shipping_tracking_number

string

evidence_uncategorized_file

string

evidence_uncategorized_text

string

_weld_synced

date

stripe_dispute_balance_transaction

dispute_id

string

balance_transaction_id

application_fee_amount

automatic_tax_enabled

boolean

automatic_tax_liability_account

string

automatic_tax_liability_type

string

automatically_finalizes_at

customer_address_city

string

customer_address_country

string

customer_address_line1

string

customer_address_line2

string

customer_address_postal_code

string

customer_address_state

customer_shipping_address_city

string

customer_shipping_address_country

string

customer_shipping_address_line1

string

customer_shipping_address_line2

string

customer_shipping_address_postal_code

string

customer_shipping_address_state

string

customer_shipping_name

string

customer_shipping_phone

default_payment_method_id

last_finalization_error

post_payment_credit_notes_amount

int

pre_payment_credit_notes_amount

rendering_amount_tax_display

string

rendering_pdf_page_size

status_transitions_finalized_at

date

status_transitions_marked_uncollectible_at

date

status_transitions_paid_at

date

status_transitions_voided_at

date

subscription_details

string

subscription_proration_date

date

subtotal

int

subtotal_excluding_tax

total_discount_amounts

transfer_data_destination

string

webhooks_delivered_at

date

_weld_synced

date

stripe_invoice_line_item

unit_amount_excluding_tax

string

stripe_invoice_line_item_discount_amount

stripe_invoice_discount

stripe_invoice_discount_amount

default_payment_method_id

string

latest_invoice_id

string

pending_setup_intent_id

string

application_fee_percent

double

billing_cycle_anchor

date

billing_threshold_reset_billing_cycle_anchor

boolean

billing_threshold_amount_gte

pause_collection_behavior

string

pause_collection_resumes_at

date

cancellation_details_reason

string

cancellation_details_comment

string

cancellation_details_feedback

string

_weld_synced

date

stripe_subscription_item

billing_threshold_usage_gte

stripe_subscription_tax_rate

stripe_subscription_discount

customer_balance_transaction

stripe_credit_note_line_item

stripe_credit_note_line_item_discount

index

int

credit_note_line_item_id

transform_usage_divide_by

int

transform_usage_round

billing_detail_country

billing_detail_postal_code

stripe_payment_method_card

three_d_secure_usage_supported

boolean

checks_address_line1_check

string

checks_address_postal_code_check

string

checks_cvc_check

string

generated_from_charge

string

generated_from_payment_method_details

stripe_payment_method_sepa_debit

stripe_payment_method_fpx

stripe_payment_method_ideal

stripe_payment_method_au_becs_debit

invoice_settings_default_payment_method

string

invoice_settings_footer

shipping_address_city

string

shipping_address_country

string

shipping_address_line1

string

shipping_address_line2

string

shipping_address_postal_code

string

shipping_address_state

stripe_customer_discount

stripe_customer_tax_id

recurring_aggregate_usage

string

recurring_interval

string

recurring_interval_count

int

recurring_usage_type

string

transform_quantity_divide_by

int

transform_quantity_round

subscription_schedule

current_phase_start_date

date

current_phase_end_date

released_subscription

stripe_subscription_schedules_phase

subscription_schedule_id

application_fee_percent

double

billing_thresholds_amount_gte

int

billing_thresholds_reset_billing_cycle_anchor

boolean

collection_method

string

default_payment_method

string

invoice_settings_days_until_due

stripe_balance_transactions_fee

balance_transaction_id

balance_transaction_id

string

failure_balance_transaction_id

destination_bank_account_id

package_dimensions_height

double

package_dimensions_length

double

package_dimensions_weight

double

package_dimensions_width

available_payout_methods

originating_transaction

customer_balance_transaction

tos_acceptance_service_agreement

string

tos_acceptance_user_agent

setup_error_decline_code

setup_error_payment_method_types

first_time_transaction

minimum_amount_currency

balance_transaction_id

transfer_data_destination_id

application_fee_amount

date

billing_details_email

string

billing_details_name

string

billing_details_phone

string

billing_details_address_city

string

billing_details_address_country

string

billing_details_address_line1

string

billing_details_address_line2

string

billing_details_address_postal_code

string

billing_details_address_state

string

calculated_statement_descriptor

fraud_details_stripe_report

string

fraud_details_user_report

outcome_network_status

outcome_seller_message

shipping_address_city

string

shipping_address_country

string

shipping_address_line1

string

shipping_address_line2

string

shipping_address_postal_code

string

shipping_address_state

shipping_tracking_number

string

statement_descriptor

string

statement_descriptor_suffix

last_payment_error_charge_id

string

on_behalf_of

string

transfer_data_destination

application_fee_amount

last_payment_error_code

string

last_payment_error_decline_code

string

last_payment_error_doc_url

string

last_payment_error_message

string

last_payment_error_param

balance_transaction_id

failure_balance_transaction_id

balance_transaction_id

string

destination_id

string

source_transaction_id

string

destination_payment_id

source_types_bank_account

Open full-page schema explorer

The Stripe connector currently does not support the API categories Connect, Issuing, Orders, and Fraud. We also do not support Connected Accounts. To request support for other API categories or features, please reach out to our team.

Setup Guide

Prerequisites

To connect Stripe to Weld, you need:

An active Stripe account with permission to access data from accounts you would like to sync.
Administratior or Developer access to the account.

Step 1 - Create API Keys

Log into the account that you will connect to Weld.
Click on the Developers tab.
Go to API Keys, and click on Create Restricted Key.
Create a name for your Key.
Grant Read permissions for the resources you want to sync.
Create your Key

Step 2 - Configuration and finalize

On the Weld connector setup page, enter a destination schema name.
Enter the Stripe API key.
Click Connect

Step 3 - Data To Sync

Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.

Step 4 - Configure Sync

Select how often you would like the data to sync.
Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Stripe account.\

SQL Templates

View all →

Stripe

Features

Data Schema

Setup Guide

Step 1 - Create API Keys

Step 2 - Configuration and finalize

Step 3 - Data To Sync

Step 4 - Configure Sync

SQL Templates

Get all subscriptions

Get subscription plans

Normalize to monthly revenue

Identify active subscriptions and sum revenue

Create time series for each customer

Summarize Monthly Recurring Revenue (MRR)