Stripe Connector Reference

35 metrics169 dimensions

Fields Actions

https://connectors.windsor.ai/stripe?api_key=[your API key]&date_preset=last_7d&fields=date,transaction_id,amount,currency,fee,email&_renderer=csv

The Stripe connector exposes 204 fields (35 metrics, 169 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Available actions

Create Customer Create a new Stripe customer and return its id (cus_...), which create_subscription then uses to start a subscription. Provide at least an email or a name.

Create a new Stripe customer and return its id (cus_...), which create_subscription then uses to start a subscription. Provide at least an email or a name.

Parameters

emailstringnamestringdescriptionstringmetadatastring

Create Subscription Create a recurring Stripe subscription for an existing customer, billing a fixed amount each interval (e.g. an opportunity or contract value from a CRM). amount is in the currency's minor unit (e.g. cents: 5000 means 50.00). A price is created inline for that amount; set product to bill against an existing product, otherwise product_name names a new product (defaults to "Subscription"). collection_method defaults to send_invoice, which emails the customer an invoice; days_until_due sets how many days they have to pay (defaults to 0, due on receipt). Use charge_automatically to charge the customer's saved payment method instead.

Create a recurring Stripe subscription for an existing customer, billing a fixed amount each interval (e.g. an opportunity or contract value from a CRM). amount is in the currency's minor unit (e.g. cents: 5000 means 50.00). A price is created inline for that amount; set product to bill against an existing product, otherwise product_name names a new product (defaults to "Subscription"). collection_method defaults to send_invoice, which emails the customer an invoice; days_until_due sets how many days they have to pay (defaults to 0, due on receipt). Use charge_automatically to charge the customer's saved payment method instead.

Parameters

customerstringRequiredamountintegerRequiredcurrencystringRequiredintervalstringRequiredinterval_countintegerproductstringproduct_namestringcollection_methodstringdays_until_duestringdescriptionstringmetadatastring

Stripe Fields

Stripe balance fields

The balance report of the Stripe connector includes 5 fields.

ID	Type	Name	Description
balance__amount	NUMERIC	Balance amount	The balance amount currently on your Stripe account.
balance__currency	TEXT	Balance currency	The balance three-letter ISO currency code, in lowercase.
balance__source_types__bank_account	NUMERIC	Balance bank account amount	Breakdown of balance by bank account.
balance__source_types__card	NUMERIC	Balance card amount	Breakdown of balance by card.
balance__source_types__fpx	NUMERIC	Balance FPX amount	Breakdown of balance by FPX.

Stripe invoice fields

The invoice report of the Stripe connector includes 10 fields.

ID	Type	Name	Description
invoice__amount_due	NUMERIC	Invoice amount due	Final amount due at this time for the invoice.
invoice__amount_paid	NUMERIC	Invoice amount paid	The amount that was paid on the invoice.
invoice__created	DATE	Invoice created	Time at which the invoice was created.
invoice__currency	TEXT	Invoice currency	Three-letter ISO currency code of the invoice, in lowercase.
invoice__customer	TEXT	Invoice customer ID	The ID of the customer who will be billed for the invoice.
invoice__id	TEXT	Invoice ID	Unique identifier for the invoice.
invoice__subtotal	NUMERIC	Invoice subtotal	Total of all line items before any invoice-level discount or tax is applied.
invoice__tax	NUMERIC	Invoice tax	The amount of tax on the invoice.
invoice__total	NUMERIC	Invoice total	Total of the invoice after discounts and taxes are applied.
invoice__total_discount_amounts	NUMERIC	Invoice total discount amount	Aggregated amount of all discounts applied to the invoice.

Stripe payout fields

The payout report of the Stripe connector includes 7 fields.

ID	Type	Name	Description
payout__amount	NUMERIC	Payout amount	The payout amount.
payout__arrival_date	DATE	Payout arrived	The date when payout was arrived.
payout__created	DATE	Payout created	The date when payout was created.
payout__currency	TEXT	Payout currency	The payout three-letter ISO currency code, in lowercase.
payout__description	TEXT	Payout description	The payout description.
payout__id	TEXT	Payout ID	The payout id.
payout__status	TEXT	Payout status	Status of the payout.

Stripe product fields

The product report of the Stripe connector includes 41 fields.

Stripe product fields (productactive to productupdated)

ID	Type	Name	Description
product__active	BOOLEAN	Product is active	Whether the product is currently available for purchase.
product__created	DATE	Product created	The date when product was created.
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__description	TEXT	Product description	The product's description.
product__features__10__name	TEXT	Product feature 10 name	Feature name 10 for this product. This is displayed in pricing tables.
product__features__11__name	TEXT	Product feature 11 name	Feature name 11 for this product. This is displayed in pricing tables.
product__features__12__name	TEXT	Product feature 12 name	Feature name 12 for this product. This is displayed in pricing tables.
product__features__13__name	TEXT	Product feature 13 name	Feature name 13 for this product. This is displayed in pricing tables.
product__features__14__name	TEXT	Product feature 14 name	Feature name 14 for this product. This is displayed in pricing tables.
product__features__15__name	TEXT	Product feature 15 name	Feature name 15 for this product. This is displayed in pricing tables.
product__features__1__name	TEXT	Product feature 1 name	Feature name 1 for this product. This is displayed in pricing tables.
product__features__2__name	TEXT	Product feature 2 name	Feature name 2 for this product. This is displayed in pricing tables.
product__features__3__name	TEXT	Product feature 3 name	Feature name 3 for this product. This is displayed in pricing tables.
product__features__4__name	TEXT	Product feature 4 name	Feature name 4 for this product. This is displayed in pricing tables.
product__features__5__name	TEXT	Product feature 5 name	Feature name 5 for this product. This is displayed in pricing tables.
product__features__6__name	TEXT	Product feature 6 name	Feature name 6 for this product. This is displayed in pricing tables.
product__features__7__name	TEXT	Product feature 7 name	Feature name 7 for this product. This is displayed in pricing tables.
product__features__8__name	TEXT	Product feature 8 name	Feature name 8 for this product. This is displayed in pricing tables.
product__features__9__name	TEXT	Product feature 9 name	Feature name 9 for this product. This is displayed in pricing tables.
product__id	TEXT	Product id (Stripe)	The product id.
product__images__1	IMAGE_URL	Product image 1	An URL of image 1 for this product, meant to be displayable to the customer.
product__images__2	IMAGE_URL	Product image 2	An URL of image 2 for this product, meant to be displayable to the customer.
product__images__3	IMAGE_URL	Product image 3	An URL of image 3 for this product, meant to be displayable to the customer.
product__images__4	IMAGE_URL	Product image 4	An URL of image 4 for this product, meant to be displayable to the customer.
product__images__5	IMAGE_URL	Product image 5	An URL of image 5 for this product, meant to be displayable to the customer.
product__images__6	IMAGE_URL	Product image 6	An URL of image 6 for this product, meant to be displayable to the customer.
product__images__7	IMAGE_URL	Product image 7	An URL of image 7 for this product, meant to be displayable to the customer.
product__images__8	IMAGE_URL	Product image 8	An URL of image 8 for this product, meant to be displayable to the customer.
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__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__name	TEXT	Product name (Stripe)	The product's name.
product__package_dimensions__height	NUMERIC	Product shipping height	Height of the product for shipping purposes, in inches.
product__package_dimensions__length	NUMERIC	Product shipping length	Length of the product for shipping purposes, in inches.
product__package_dimensions__weight	NUMERIC	Product shipping weight	Weight of the product for shipping purposes, in ounces.
product__package_dimensions__width	NUMERIC	Product shipping width	Width of the product for shipping purposes, in inches.
product__shippable	BOOLEAN	Product is shippable	Whether this product is shipped (i.e., physical goods).
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__tax_code	TEXT	Product tax code ID.	A tax code ID.
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__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.

Stripe product fields (producturl to producturl)

ID	Type	Name	Description
product__url	TEXT	Product url	A URL of a publicly-accessible webpage for this product.

Stripe refund fields

The refund report of the Stripe connector includes 10 fields.

ID	Type	Name	Description
refund__amount	NUMERIC	Refund amount	The refund amount.
refund__balance_transaction	TEXT	Refund Balance Transaction ID	ID of the balance transaction that describes the impact of the refund on the account balance.
refund__charge	TEXT	Refund Charge ID	ID of the charge that was refunded.
refund__created	DATE	Refund created	The date when refund was created.
refund__currency	TEXT	Refund currency	The refund three-letter ISO currency code, in lowercase.
refund__description	TEXT	Refund description	The refund description.
refund__id	TEXT	Refund ID	The refund id.
refund__payment_intent	TEXT	Refund Payment Intent ID	ID of the PaymentIntent that was refunded.
refund__reason	TEXT	Refund reason	Reason for the refund.
refund__status	TEXT	Refund status	Status of the refund.

Stripe subscription fields

The subscription report of the Stripe connector includes 71 fields.

Stripe subscription fields (subscriptionapplication to subscriptionpayment_settings__payment_method_options__acss_debit__verification_method)

ID	Type	Name	Description
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__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__automatic_tax__enabled	BOOLEAN	Subscription automatic tax	Whether Stripe automatically computes tax on this 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__billing_thresholds__amount_gte	NUMERIC	Subscription billing thresholds amount	Monetary threshold that triggers the subscription to create an invoice
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__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__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__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__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__cancellation_details__reason	TEXT	Subscription cancellation details reason	Why this subscription was canceled.
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__created	DATE	Subscription created	The date when subscription was created.
subscription__currency	TEXT	Subscription currency	Three-letter ISO currency code, in lowercase. Must be a stripe supported currency.
subscription__current_period_end	DATE	Subscription current period end date	End of the current period that the subscription has been invoiced for.
subscription__current_period_start	DATE	Subscription current period start date	Start of the current period that the subscription has been invoiced for.
subscription__customer	TEXT	Subscription customer ID	ID of the customer who owns the 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__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__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__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__description	TEXT	Subscription description	The subscription description.
subscription__discount__coupon__amount_off	NUMERIC	Subscription discount amount off	Amount taken off the subtotal of invoices for this subscription, in the coupon currency.
subscription__discount__coupon__currency	TEXT	Subscription discount currency	Three-letter ISO currency code of the discount amount off, when amount_off is set.
subscription__discount__coupon__duration	TEXT	Subscription discount duration	How long the discount applies. One of forever, once or repeating.
subscription__discount__coupon__id	TEXT	Subscription discount coupon ID	Unique identifier of the coupon backing the subscription discount.
subscription__discount__coupon__percent_off	PERCENT	Subscription discount percent off	Percent taken off the subtotal of invoices for this subscription for the duration of the coupon.
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__ended_at	DATE	Subscription ended at date	If the subscription has ended, the date the subscription ended.
subscription__id	TEXT	Subscription id	The subscription id.
subscription__items	OBJECT	Subscription items	List of subscription items, each with an attached price.
subscription__latest_invoice	TEXT	Subscription latest invoice	ID of the most recent invoice this subscription has generated.
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__metadata	OBJECT	Subscription metadata	The subscription metadata.
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__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__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__pause_collection__resumes_at	DATE	Subscription pause collection resumes at	The date after which the subscription will resume collecting payments.
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__payment_settings__payment_method_options__acss_debit__verification_method	TEXT	Subscription payment method option verification method (acss debit)	Bank account verification method.

Stripe subscription fields (subscription__payment_settings__payment_method_optionsbancontactpreferred_language to subscription__trial_start)

ID	Type	Name	Description
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__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__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__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__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__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__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__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__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__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__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__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__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__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__pending_invoice_item_interval__interval	TEXT	Subscription pending invoice item interval	Specifies invoicing frequency. Either day, week, month or year.
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__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__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__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__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__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__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__schedule	TEXT	Subscription schedule ID	The ID of schedule attached to the 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__status	TEXT	Subscription status (Stripe)	The subscription status. Enum: "incomplete", "incomplete_expired", "trialing", "active", "past_due", "canceled", "unpaid", "paused"
subscription__test_clock	TEXT	Subscription test clock ID	ID of the test clock this subscription belongs to.
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__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__trial_end	DATE	Subscription trial end	If the subscription has a trial, the end of that trial.
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__trial_start	DATE	Subscription trial start	If the subscription has a trial, the beginning of that trial.

Stripe subscription_item fields

The subscription_item report of the Stripe connector includes 17 fields.

ID	Type	Name	Description
subscription_item__billing_thresholds__usage_gte	NUMERIC	Subscription item billing threshold usage	Usage threshold that triggers the subscription to create an invoice.
subscription_item__created	DATE	Subscription item created	Time at which the subscription item was created.
subscription_item__id	TEXT	Subscription item ID	Unique identifier for the subscription item.
subscription_item__metadata	OBJECT	Subscription item metadata	Set of key-value pairs that you can attach to an object.
subscription_item__price__active	BOOLEAN	Subscription item price active	Whether the price is currently available for purchase.
subscription_item__price__currency	TEXT	Subscription item price currency	Three-letter ISO currency code for the price.
subscription_item__price__id	TEXT	Subscription item price ID	The ID of the price associated with this subscription item.
subscription_item__price__product	TEXT	Subscription item price product ID	The ID of the product this price is associated with.
subscription_item__price__recurring__interval	TEXT	Subscription item price recurring interval	The frequency at which a subscription is billed. One of day, week, month or year.
subscription_item__price__recurring__interval_count	NUMERIC	Subscription item price recurring interval count	The number of intervals between subscription billings.
subscription_item__price__recurring__usage_type	TEXT	Subscription item price recurring usage type	Configures how the quantity per period should be determined. Can be either metered or licensed.
subscription_item__price__type	TEXT	Subscription item price type	One of one_time or recurring depending on whether the price is for a one-time purchase or a recurring (subscription) purchase.
subscription_item__price__unit_amount	NUMERIC	Subscription item price unit amount	The unit amount in cents to be charged, represented as a whole integer if possible.
subscription_item__price__unit_amount_decimal	TEXT	Subscription item price unit amount decimal	The unit amount in cents to be charged, represented as a decimal string with at most 12 decimal places.
subscription_item__quantity	NUMERIC	Subscription item quantity	The quantity of the plan to which the customer should be subscribed.
subscription_item__subscription	TEXT	Subscription item subscription ID	The ID of the subscription this item belongs to.
subscription_item__tax_rates	OBJECT	Subscription item tax rates	The tax rates which apply to this subscription item.

Stripe transaction fields

The transaction report of the Stripe connector includes 22 fields.

ID	Type	Name	Description
amount	NUMERIC	Amount	The transaction amount
currency	TEXT	Currency	The transaction three-letter ISO currency code, in lowercase.
customer_id	TEXT	Customers ID	The Stripe customer ID
description	TEXT	Description	Transaction Description
email	TEXT	Email	The email address of the customer placing the order.
fee	NUMERIC	Transaction fee	The transaction fee
net	NUMERIC	Net Amount	Net amount of the transaction, in pence.
reporting_category	TEXT	Reporting Category	Transaction Reporting Category (charge, refund, payout, etc.)
status	TEXT	Status	The transaction status
transaction__amount	NUMERIC	Transaction amount	The transaction amount
transaction__created	DATE	Transaction created	The date when transaction was created.
transaction__currency	TEXT	Transaction currency	The transaction three-letter ISO currency code, in lowercase.
transaction__description	TEXT	Transaction description	The transaction description
transaction__email	TEXT	Transaction email	The email address of the customer placing the order.
transaction__fee	NUMERIC	Transaction fee (same as fee)	The transaction fee
transaction__id	TEXT	Transaction ID (same as transactionid)	The transaction id
transaction__net	NUMERIC	Transaction net amount	Net amount of the transaction.
transaction__source	TEXT	Transaction Source ID	ID of the Stripe object that caused this transaction, e.g. the charge (ch_...) or the refund (re_...).
transaction__status	TEXT	Transaction status	The transaction status
transaction__type	TEXT	Transaction type	The transaction type
transactionid	TEXT	Transaction ID	The transaction id
type	TEXT	Type	Transaction Type

Stripe other fields

The Stripe connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The Account ID
account_name	TEXT	Account Name	The Account Name
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
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
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
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_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
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

API Connectors