Windsor brings all your Stripe data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Stripe Field Reference
![](https://windsor.ai/wp-content/uploads/2020/08/stripe-large.png.webp)
Sample
https://connectors.windsor.ai/stripe?api_key=[your API key]&date_preset=last_7d&fields=date,transaction_id,amount,currency,fee,email&_renderer=csv
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
amount | NUMERIC | Amount | The transaction amount | transaction |
balance__amount | NUMERIC | Balance amount | The balance amount currently on your Stripe account. | balance |
balance__currency | TEXT | Balance currency | The balance three-letter ISO currency code, in lowercase. | balance |
balance__source_types__bank_account | NUMERIC | Balance bank account amount | Breakdown of balance by bank account. | balance |
balance__source_types__card | NUMERIC | Balance card amount | Breakdown of balance by card. | balance |
balance__source_types__fpx | NUMERIC | Balance FPX amount | Breakdown of balance by FPX. | balance |
currency | TEXT | Currency | The transaction three-letter ISO currency code, in lowercase. | transaction |
customer_id | TEXT | Customers ID | The Stripe customer ID | transaction |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
date | DATE | Date | Date | |
day_of_month | TEXT | Day of month | Day of the month | |
description | TEXT | Description | Transaction Description | transaction |
TEXT | The email address of the customer placing the order. | transaction | ||
fee | NUMERIC | Transaction fee | The transaction fee | transaction |
month | TEXT | Month | Number of the month | |
net | NUMERIC | Net Amount | Net amount of the transaction, in pence. | transaction |
product__active | BOOLEAN | Product is active | Whether the product is currently available for purchase. | product |
product__default_price | TEXT | ID of the product default price | The ID of the Price object that is the default price for this product. | product |
product__description | TEXT | Product description | The product's description. | product |
product__features__10__name | TEXT | Product feature 10 name | Feature name 10 for this product. This is displayed in pricing tables. | product |
product__features__11__name | TEXT | Product feature 11 name | Feature name 11 for this product. This is displayed in pricing tables. | product |
product__features__12__name | TEXT | Product feature 12 name | Feature name 12 for this product. This is displayed in pricing tables. | product |
product__features__13__name | TEXT | Product feature 13 name | Feature name 13 for this product. This is displayed in pricing tables. | product |
product__features__14__name | TEXT | Product feature 14 name | Feature name 14 for this product. This is displayed in pricing tables. | product |
product__features__15__name | TEXT | Product feature 15 name | Feature name 15 for this product. This is displayed in pricing tables. | product |
product__features__1__name | TEXT | Product feature 1 name | Feature name 1 for this product. This is displayed in pricing tables. | product |
product__features__2__name | TEXT | Product feature 2 name | Feature name 2 for this product. This is displayed in pricing tables. | product |
product__features__3__name | TEXT | Product feature 3 name | Feature name 3 for this product. This is displayed in pricing tables. | product |
product__features__4__name | TEXT | Product feature 4 name | Feature name 4 for this product. This is displayed in pricing tables. | product |
product__features__5__name | TEXT | Product feature 5 name | Feature name 5 for this product. This is displayed in pricing tables. | product |
product__features__6__name | TEXT | Product feature 6 name | Feature name 6 for this product. This is displayed in pricing tables. | product |
product__features__7__name | TEXT | Product feature 7 name | Feature name 7 for this product. This is displayed in pricing tables. | product |
product__features__8__name | TEXT | Product feature 8 name | Feature name 8 for this product. This is displayed in pricing tables. | product |
product__features__9__name | TEXT | Product feature 9 name | Feature name 9 for this product. This is displayed in pricing tables. | product |
product__id | TEXT | Product id (Stripe) | The product id. | product |
product__images__1 | IMAGE_URL | Product image 1 | An URL of image 1 for this product, meant to be displayable to the customer. | product |
product__images__2 | IMAGE_URL | Product image 2 | An URL of image 2 for this product, meant to be displayable to the customer. | product |
product__images__3 | IMAGE_URL | Product image 3 | An URL of image 3 for this product, meant to be displayable to the customer. | product |
product__images__4 | IMAGE_URL | Product image 4 | An URL of image 4 for this product, meant to be displayable to the customer. | product |
product__images__5 | IMAGE_URL | Product image 5 | An URL of image 5 for this product, meant to be displayable to the customer. | product |
product__images__6 | IMAGE_URL | Product image 6 | An URL of image 6 for this product, meant to be displayable to the customer. | product |
product__images__7 | IMAGE_URL | Product image 7 | An URL of image 7 for this product, meant to be displayable to the customer. | product |
product__images__8 | IMAGE_URL | Product image 8 | An URL of image 8 for this product, meant to be displayable to the customer. | product |
product__livemode | BOOLEAN | Product livemode | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | product |
product__metadata | OBJECT | Product additional information (metadata) | Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. | product |
product__name | TEXT | Product name (Stripe) | The product's name. | product |
product__package_dimensions__height | NUMERIC | Product shipping height | Height of the product for shipping purposes, in inches. | product |
product__package_dimensions__length | NUMERIC | Product shipping length | Length of the product for shipping purposes, in inches. | product |
product__package_dimensions__weight | NUMERIC | Product shipping weight | Weight of the product for shipping purposes, in ounces. | product |
product__package_dimensions__width | NUMERIC | Product shipping width | Width of the product for shipping purposes, in inches. | product |
product__shippable | BOOLEAN | Product is shippable | Whether this product is shipped (i.e., physical goods). | product |
product__statement_descriptor | TEXT | Product extra information on statement | Extra information about a product which will appear on your customer's credit card statement. In the case that multiple products are billed at once, the first statement descriptor will be used. | product |
product__tax_code | TEXT | Product tax code ID. | A tax code ID. | product |
product__unit_label | TEXT | Product unit label | A label that represents units of this product. When set, this will be included in customers' receipts, invoices, Checkout, and the customer portal. | product |
product__updated | DATE | Product updated date | A label that represents units of this product. When set, this will be included in customers' receipts, invoices, Checkout, and the customer portal. | product |
product__url | TEXT | Product url | A URL of a publicly-accessible webpage for this product. | product |
refund__amount | NUMERIC | Refund amount | The refund amount. | refund |
refund__currency | TEXT | Refund currency | The refund three-letter ISO currency code, in lowercase. | refund |
refund__description | TEXT | Refund description | The refund description. | refund |
refund__id | TEXT | Refund ID | The refund id. | refund |
refund__reason | TEXT | Refund reason | Reason for the refund. | refund |
refund__status | TEXT | Refund status | Status of the refund. | refund |
source | TEXT | Source | The name of the Windsor connector returning the row | |
status | TEXT | Status | The transaction status | transaction |
subscription__application | TEXT | Subscription application (Stripe Connect) | ID of the Connect Application that created the subscription. This attribute is only relevant if you're using Stripe Connect. | subscription |
subscription__application_fee_percent | NUMERIC | Subscription application fee percent (Stripe Connect) | A non-negative decimal between 0 and 100, with at most two decimal places. This represents the percentage of the subscription; invoice total that will be transferred to the application owner's Stripe account.; | subscription |
subscription__automatic_tax__enabled | BOOLEAN | Subscription automatic tax | Whether Stripe automatically computes tax on this subscription. | subscription |
subscription__billing_cycle_anchor | DATE | Subscription billing cycle anchor | Determines the date of the first full invoice, and, for plans with month or year intervals, the day of the month for subsequent invoices. | subscription |
subscription__billing_thresholds__amount_gte | NUMERIC | Subscription billing thresholds amount | Monetary threshold that triggers the subscription to create an invoice | subscription |
subscription__billing_thresholds__reset_billing_cycle_anchor | NUMERIC | Subscription billing thresholds reset billing cycle anchor | Indicates if the billing_cycle_anchor should be reset when a threshold is reached. If true, billing_cycle_anchor will be updated to the date/time the threshold was last reached;; otherwise, the value will remain unchanged. This value may not be true if the subscription contains items with plans that have aggregate_usage=last_ever.; | subscription |
subscription__cancel_at_period_end | BOOLEAN | Subscription cancel at period end | If the subscription has been canceled with the at_period_end flag set to true, cancel_at_period_end on the subscription will be true.; You can use this attribute to determine whether a subscription that has a status of active is scheduled to be canceled at the end of the current period.; | subscription |
subscription__canceled_at | DATE | Subscription canceled at | If the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel_at_period_end, canceled_at will; reflect the time of the most recent update request, not the end of the subscription period when the subscription is automatically moved to a canceled state.; | subscription |
subscription__cancellation_details__comment | TEXT | Subscription cancellation details comment | Additional comments about why the user canceled the subscription, if the subscription was canceled explicitly by the user. | subscription |
subscription__cancellation_details__feedback | TEXT | Subscription cancellation details feedback | The customer submitted reason for why they canceled, if the subscription was canceled explicitly by the user. | subscription |
subscription__cancellation_details__reason | TEXT | Subscription cancellation details reason | Why this subscription was canceled. | subscription |
subscription__collection_method | TEXT | Subscription collection method | Either charge_automatically, or send_invoice. When charging automatically, Stripe will attempt to pay this subscription; at the end of the cycle using the default source attached to the customer. When sending an invoice, Stripe will email your; customer an invoice with payment instructions and mark the subscription as active.; | subscription |
subscription__currency | TEXT | Subscription currency | Three-letter ISO currency code, in lowercase. Must be a stripe supported currency. | subscription |
subscription__current_period_end | DATE | Subscription current period end date | End of the current period that the subscription has been invoiced for. | subscription |
subscription__current_period_start | DATE | Subscription current period start date | Start of the current period that the subscription has been invoiced for. | subscription |
subscription__customer | TEXT | Subscription customer ID | ID of the customer who owns the subscription. | subscription |
subscription__days_until_due | NUMERIC | Subscription days until due | Number of days a customer has to pay invoices generated by this subscription. This value will be null for subscriptions where collection_method=charge_automatically. | subscription |
subscription__default_payment_method | TEXT | Subscription default payment method | ID of the default payment method for the subscription. It must belong to the customer associated with the subscription.; This takes precedence over default_source. If neither are set, invoices will use the customer's invoice_settings.default_payment_method or default_source.; | subscription |
subscription__default_source | TEXT | Subscription default payment source | ID of the default payment source for the subscription. It must belong to the customer associated with the subscription and be in a chargeable state.; If default_payment_method is also set, default_payment_method will take precedence. If neither are set, invoices will use the customer's; invoice_settings.default_payment_method or default_source.; | subscription |
subscription__default_tax_rates | OBJECT | Subscription default tax rates | The tax rates that will apply to any subscription item that does not have tax_rates set.; Invoices created will have their default_tax_rates populated from the subscription.; | subscription |
subscription__description | TEXT | Subscription description | The subscription description. | subscription |
subscription__discount__id | TEXT | Subscription discount ID | ID of the Discount object. Discount describes the current discount applied to this subscription, if there is one. When billing,; a discount applied to a subscription overrides a discount applied on a customer-wide basis.; | subscription |
subscription__ended_at | DATE | Subscription ended at date | If the subscription has ended, the date the subscription ended. | subscription |
subscription__id | TEXT | Subscription id | The subscription id. | subscription |
subscription__items | OBJECT | Subscription items | List of subscription items, each with an attached price. | subscription |
subscription__latest_invoice | TEXT | Subscription latest invoice | ID of the most recent invoice this subscription has generated. | subscription |
subscription__livemode | BOOLEAN | Subscription livemode | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | subscription |
subscription__metadata | OBJECT | Subscription metadata | The subscription metadata. | subscription |
subscription__next_pending_invoice_item_invoice | DATE | Subscription next pending invoice item invoice | Specifies the approximate date on which any pending invoice items will be billed according to the schedule provided at pending_invoice_item_interval. | subscription |
subscription__on_behalf_of | TEXT | Subscription on behalf of (Stripe Connect) | The account (if any) the charge was made on behalf of for charges associated with this subscription.; See the Connect documentation for details. This attribute is only relevant if you're using Stripe Connect.; | subscription |
subscription__pause_collection__behavior | TEXT | Subscription pause collection behavior | The payment collection behavior for this subscription while paused. One of keep_as_draft, mark_uncollectible, or void. | subscription |
subscription__pause_collection__resumes_at | DATE | Subscription pause collection resumes at | The date after which the subscription will resume collecting payments. | subscription |
subscription__payment_settings__payment_method_options__acss_debit__mandate_options__transaction_type | TEXT | Subscription payment method mandate option transaction type (acss debit) | Transaction type of the mandate for Canadian pre-authorized debit payment. | subscription |
subscription__payment_settings__payment_method_options__acss_debit__verification_method | TEXT | Subscription payment method option verification method (acss debit) | Bank account verification method. | subscription |
subscription__payment_settings__payment_method_options__bancontact__preferred_language | TEXT | Subscription payment method preferred language (Bancontact) | Preferred language of the Bancontact authorization page that the customer is redirected to. | subscription |
subscription__payment_settings__payment_method_options__card__mandate_options__amount | NUMERIC | Subscription payment method mandate option amount (Card) | Amount to be charged for future payments for eMandate for cards issued in India. | subscription |
subscription__payment_settings__payment_method_options__card__mandate_options__amount_type | TEXT | Subscription payment method mandate option amount type (Card) | One of fixed or maximum. If fixed, the amount param refers to the exact amount to; be charged in future payments. If maximum, the amount charged can be up to the value passed for the amount param.; | subscription |
subscription__payment_settings__payment_method_options__card__mandate_options__description | TEXT | Subscription payment method mandate option description (Card) | A description of the mandate or subscription that is meant to be displayed to the customer. | subscription |
subscription__payment_settings__payment_method_options__card__network | TEXT | Subscription payment method option network (Card) | Selected network to process this Subscription on. Depends on the available networks of the; card attached to the Subscription. Can be only set confirm-time.; | subscription |
subscription__payment_settings__payment_method_options__customer_balance__bank_transfer__eu_bank_transfer__country | COUNTRY | Subscription payment method option eu bank transfer country (Customer balance) | The desired country code of the bank account information for eu bank transfer. | subscription |
subscription__payment_settings__payment_method_options__customer_balance__bank_transfer__type | TEXT | Subscription payment method option bank transfer type (Customer balance) | The bank transfer type that can be used for funding. | subscription |
subscription__payment_settings__payment_method_options__customer_balance__funding_type | TEXT | Subscription payment method option funding type (Customer balance) | The funding method type to be used when there are not enough funds in the customer balance. | subscription |
subscription__payment_settings__payment_method_options__konbini | OBJECT | Subscription payment method options (Konbini) | Details about the Konbini payment method options to pass to invoices created by the subscription. | subscription |
subscription__payment_settings__payment_method_options__us_bank_account__financial_connections__permissions | TEXT | Subscription payment method option financial connections permissions (US bank account) | The list of permissions to request. The payment_method permission must be included. | subscription |
subscription__payment_settings__payment_method_options__us_bank_account__financial_connections__prefetch | TEXT | Subscription payment method option financial connections prefetch (US bank account) | Data features requested to be retrieved upon account creation. | subscription |
subscription__payment_settings__payment_method_options__us_bank_account__verification_method | TEXT | Subscription payment method option verification method (US bank account) | Bank account verification method. | subscription |
subscription__payment_settings__payment_method_types | OBJECT | Subscription payment method types | The list of payment method types to provide to every invoice created by the subscription.; If not set, Stripe attempts to automatically determine the types to use by looking at the invoice's; default payment method, the subscription's default payment method, the customer's default payment method, and your invoice template settings.; | subscription |
subscription__payment_settings__save_default_payment_method | TEXT | Subscription save default payment method | Either off, or on_subscription. With on_subscription Stripe updates subscription.default_payment_method when a subscription payment succeeds. | subscription |
subscription__pending_invoice_item_interval__interval | TEXT | Subscription pending invoice item interval | Specifies invoicing frequency. Either day, week, month or year. | subscription |
subscription__pending_invoice_item_interval__interval_count | NUMERIC | Subscription pending invoice item interval count | The number of intervals between invoices. For example, interval=month and interval_count=3 bills every 3 months.; Maximum of one year interval allowed (1 year, 12 months, or 52 weeks).; | subscription |
subscription__pending_setup_intent | TEXT | Subscription pending setup intent | You can use this SetupIntent to collect user authentication when creating a subscription without immediate payment or; updating a subscription's payment method, allowing you to optimize for off-session payments.; | subscription |
subscription__pending_update__billing_cycle_anchor | DATE | Subscription pending update billing cycle anchor | If the update is applied, determines the date of the first full invoice, and, for plans with month or year; intervals, the day of the month for subsequent invoices. The timestamp is in UTC format.; | subscription |
subscription__pending_update__expires_at | DATE | Subscription pending update expire date | The point after which the changes reflected by this update will be discarded and no longer applied. | subscription |
subscription__pending_update__subscription_items | OBJECT | Subscription pending update subscription items | List of subscription item IDs, leading to plans that will be set if the update is applied. | subscription |
subscription__pending_update__trial_end | DATE | Subscription pending update trial end date | Date representing the end of the trial period the customer will get before being charged; for the first time, if the update is applied.; | subscription |
subscription__pending_update__trial_from_plan | BOOLEAN | Subscription pending update trial from plan | Indicates if a plan's trial_period_days should be applied to the subscription.; Setting trial_end per subscription is preferred, and this defaults to false.; Setting this flag to true together with trial_end is not allowed.; See Using trial periods on subscriptions to learn more.; | subscription |
subscription__schedule | TEXT | Subscription schedule ID | The ID of schedule attached to the subscription. | subscription |
subscription__start_date | DATE | Subscription start date | Date when the subscription was first created. The date might differ from the created date due to backdating. | subscription |
subscription__status | TEXT | Subscription status (Stripe) | The subscription status. Enum: "incomplete", "incomplete_expired", "trialing", "active", "past_due", "canceled", "unpaid", "paused" | subscription |
subscription__test_clock | TEXT | Subscription test clock ID | ID of the test clock this subscription belongs to. | subscription |
subscription__transfer_data__amount_percent | NUMERIC | Subscription transfer data percent amount (Stripe Connect) | A non-negative decimal between 0 and 100, with at most two decimal places.; This represents the percentage of the subscription invoice total that will be; transferred to the destination account. By default, the entire amount is transferred to the destination.; This attribute is only relevant if you're using Stripe Connect.; | subscription |
subscription__transfer_data__destination | TEXT | Subscription transfer data destination (Stripe Connect) | The account where funds from the payment will be transferred to upon payment success.; This attribute is only relevant if you're using Stripe Connect.; | subscription |
subscription__trial_end | DATE | Subscription trial end | If the subscription has a trial, the end of that trial. | subscription |
subscription__trial_settings__end_behavior__missing_payment_method | TEXT | Subscription trial settings end behavior missing payment method | Indicates how the subscription should change when the trial ends if the user did not provide a payment method. | subscription |
subscription__trial_start | DATE | Subscription trial start | If the subscription has a trial, the beginning of that trial. | subscription |
today | DATE | Today | Today's date | |
transaction__amount | NUMERIC | Transaction amount | The transaction amount | transaction |
transaction__currency | TEXT | Transaction currency | The transaction three-letter ISO currency code, in lowercase. | transaction |
transaction__description | TEXT | Transaction description | The transaction description | transaction |
transaction__email | TEXT | Transaction email | The email address of the customer placing the order. | transaction |
transaction__fee | NUMERIC | Transaction fee (same as fee) | The transaction fee | transaction |
transaction__id | TEXT | Transaction ID (same as transactionid) | The transaction id | transaction |
transaction__net | NUMERIC | Transaction net amount | Net amount of the transaction. | transaction |
transaction__status | TEXT | Transaction status | The transaction status | transaction |
transaction__type | TEXT | Transaction type | The transaction type | transaction |
transactionid | TEXT | Transaction ID | The transaction id | transaction |
type | TEXT | Type | Transaction Type | transaction |
week | TEXT | Week | Week (Sun-Sat). | |
week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
year | TEXT | Year | Year | |
year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |