Stripe Field Reference

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

IDTypeNameDescriptionReport
amountNUMERICAmountThe transaction amounttransaction
balance__amountNUMERICBalance amountThe balance amount currently on your Stripe account.balance
balance__currencyTEXTBalance currencyThe balance three-letter ISO currency code, in lowercase.balance
balance__source_types__bank_accountNUMERICBalance bank account amountBreakdown of balance by bank account.balance
balance__source_types__cardNUMERICBalance card amountBreakdown of balance by card.balance
balance__source_types__fpxNUMERICBalance FPX amountBreakdown of balance by FPX.balance
currencyTEXTCurrencyThe transaction three-letter ISO currency code, in lowercase.transaction
customer_idTEXTCustomers IDThe Stripe customer IDtransaction
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate
day_of_monthTEXTDay of monthDay of the month
descriptionTEXTDescriptionTransaction Descriptiontransaction
emailTEXTEmailThe email address of the customer placing the order.transaction
feeNUMERICTransaction feeThe transaction feetransaction
monthTEXTMonthNumber of the month
netNUMERICNet AmountNet amount of the transaction, in pence.transaction
product__activeBOOLEANProduct is activeWhether the product is currently available for purchase.product
product__default_priceTEXTID of the product default priceThe ID of the Price object that is the default price for this product.product
product__descriptionTEXTProduct descriptionThe product's description.product
product__features__10__nameTEXTProduct feature 10 nameFeature name 10 for this product. This is displayed in pricing tables.product
product__features__11__nameTEXTProduct feature 11 nameFeature name 11 for this product. This is displayed in pricing tables.product
product__features__12__nameTEXTProduct feature 12 nameFeature name 12 for this product. This is displayed in pricing tables.product
product__features__13__nameTEXTProduct feature 13 nameFeature name 13 for this product. This is displayed in pricing tables.product
product__features__14__nameTEXTProduct feature 14 nameFeature name 14 for this product. This is displayed in pricing tables.product
product__features__15__nameTEXTProduct feature 15 nameFeature name 15 for this product. This is displayed in pricing tables.product
product__features__1__nameTEXTProduct feature 1 nameFeature name 1 for this product. This is displayed in pricing tables.product
product__features__2__nameTEXTProduct feature 2 nameFeature name 2 for this product. This is displayed in pricing tables.product
product__features__3__nameTEXTProduct feature 3 nameFeature name 3 for this product. This is displayed in pricing tables.product
product__features__4__nameTEXTProduct feature 4 nameFeature name 4 for this product. This is displayed in pricing tables.product
product__features__5__nameTEXTProduct feature 5 nameFeature name 5 for this product. This is displayed in pricing tables.product
product__features__6__nameTEXTProduct feature 6 nameFeature name 6 for this product. This is displayed in pricing tables.product
product__features__7__nameTEXTProduct feature 7 nameFeature name 7 for this product. This is displayed in pricing tables.product
product__features__8__nameTEXTProduct feature 8 nameFeature name 8 for this product. This is displayed in pricing tables.product
product__features__9__nameTEXTProduct feature 9 nameFeature name 9 for this product. This is displayed in pricing tables.product
product__idTEXTProduct id (Stripe)The product id.product
product__images__1IMAGE_URLProduct image 1An URL of image 1 for this product, meant to be displayable to the customer.product
product__images__2IMAGE_URLProduct image 2An URL of image 2 for this product, meant to be displayable to the customer.product
product__images__3IMAGE_URLProduct image 3An URL of image 3 for this product, meant to be displayable to the customer.product
product__images__4IMAGE_URLProduct image 4An URL of image 4 for this product, meant to be displayable to the customer.product
product__images__5IMAGE_URLProduct image 5An URL of image 5 for this product, meant to be displayable to the customer.product
product__images__6IMAGE_URLProduct image 6An URL of image 6 for this product, meant to be displayable to the customer.product
product__images__7IMAGE_URLProduct image 7An URL of image 7 for this product, meant to be displayable to the customer.product
product__images__8IMAGE_URLProduct image 8An URL of image 8 for this product, meant to be displayable to the customer.product
product__livemodeBOOLEANProduct livemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.product
product__metadataOBJECTProduct 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__nameTEXTProduct name (Stripe)The product's name.product
product__package_dimensions__heightNUMERICProduct shipping heightHeight of the product for shipping purposes, in inches.product
product__package_dimensions__lengthNUMERICProduct shipping lengthLength of the product for shipping purposes, in inches.product
product__package_dimensions__weightNUMERICProduct shipping weightWeight of the product for shipping purposes, in ounces.product
product__package_dimensions__widthNUMERICProduct shipping widthWidth of the product for shipping purposes, in inches.product
product__shippableBOOLEANProduct is shippableWhether this product is shipped (i.e., physical goods).product
product__statement_descriptorTEXTProduct extra information on statementExtra 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_codeTEXTProduct tax code ID.A tax code ID.product
product__unit_labelTEXTProduct unit labelA label that represents units of this product. When set, this will be included in customers' receipts, invoices, Checkout, and the customer portal.product
product__updatedDATEProduct updated dateA label that represents units of this product. When set, this will be included in customers' receipts, invoices, Checkout, and the customer portal.product
product__urlTEXTProduct urlA URL of a publicly-accessible webpage for this product.product
refund__amountNUMERICRefund amountThe refund amount.refund
refund__currencyTEXTRefund currencyThe refund three-letter ISO currency code, in lowercase.refund
refund__descriptionTEXTRefund descriptionThe refund description.refund
refund__idTEXTRefund IDThe refund id.refund
refund__reasonTEXTRefund reasonReason for the refund.refund
refund__statusTEXTRefund statusStatus of the refund.refund
sourceTEXTSourceThe name of the Windsor connector returning the row
statusTEXTStatusThe transaction statustransaction
subscription__applicationTEXTSubscription 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_percentNUMERICSubscription 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__enabledBOOLEANSubscription automatic taxWhether Stripe automatically computes tax on this subscription.subscription
subscription__billing_cycle_anchorDATESubscription billing cycle anchorDetermines 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_gteNUMERICSubscription billing thresholds amountMonetary threshold that triggers the subscription to create an invoicesubscription
subscription__billing_thresholds__reset_billing_cycle_anchorNUMERICSubscription billing thresholds reset billing cycle anchorIndicates 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_endBOOLEANSubscription cancel at period endIf 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_atDATESubscription canceled atIf 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__commentTEXTSubscription cancellation details commentAdditional comments about why the user canceled the subscription, if the subscription was canceled explicitly by the user.subscription
subscription__cancellation_details__feedbackTEXTSubscription cancellation details feedbackThe customer submitted reason for why they canceled, if the subscription was canceled explicitly by the user.subscription
subscription__cancellation_details__reasonTEXTSubscription cancellation details reasonWhy this subscription was canceled.subscription
subscription__collection_methodTEXTSubscription collection methodEither 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__currencyTEXTSubscription currencyThree-letter ISO currency code, in lowercase. Must be a stripe supported currency.subscription
subscription__current_period_endDATESubscription current period end dateEnd of the current period that the subscription has been invoiced for.subscription
subscription__current_period_startDATESubscription current period start dateStart of the current period that the subscription has been invoiced for.subscription
subscription__customerTEXTSubscription customer IDID of the customer who owns the subscription.subscription
subscription__days_until_dueNUMERICSubscription days until dueNumber 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_methodTEXTSubscription default payment methodID 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_sourceTEXTSubscription default payment sourceID 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_ratesOBJECTSubscription default tax ratesThe 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__descriptionTEXTSubscription descriptionThe subscription description.subscription
subscription__discount__idTEXTSubscription discount IDID 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_atDATESubscription ended at dateIf the subscription has ended, the date the subscription ended.subscription
subscription__idTEXTSubscription idThe subscription id.subscription
subscription__itemsOBJECTSubscription itemsList of subscription items, each with an attached price.subscription
subscription__latest_invoiceTEXTSubscription latest invoiceID of the most recent invoice this subscription has generated.subscription
subscription__livemodeBOOLEANSubscription livemodeHas the value true if the object exists in live mode or the value false if the object exists in test mode.subscription
subscription__metadataOBJECTSubscription metadataThe subscription metadata.subscription
subscription__next_pending_invoice_item_invoiceDATESubscription next pending invoice item invoiceSpecifies 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_ofTEXTSubscription 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__behaviorTEXTSubscription pause collection behaviorThe payment collection behavior for this subscription while paused. One of keep_as_draft, mark_uncollectible, or void.subscription
subscription__pause_collection__resumes_atDATESubscription pause collection resumes atThe date after which the subscription will resume collecting payments.subscription
subscription__payment_settings__payment_method_options__acss_debit__mandate_options__transaction_typeTEXTSubscription 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_methodTEXTSubscription payment method option verification method (acss debit)Bank account verification method.subscription
subscription__payment_settings__payment_method_options__bancontact__preferred_languageTEXTSubscription 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__amountNUMERICSubscription 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_typeTEXTSubscription 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__descriptionTEXTSubscription 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__networkTEXTSubscription 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__countryCOUNTRYSubscription 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__typeTEXTSubscription 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_typeTEXTSubscription 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__konbiniOBJECTSubscription 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__permissionsTEXTSubscription 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__prefetchTEXTSubscription 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_methodTEXTSubscription payment method option verification method (US bank account)Bank account verification method.subscription
subscription__payment_settings__payment_method_typesOBJECTSubscription payment method typesThe 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_methodTEXTSubscription save default payment methodEither off, or on_subscription. With on_subscription Stripe updates subscription.default_payment_method when a subscription payment succeeds.subscription
subscription__pending_invoice_item_interval__intervalTEXTSubscription pending invoice item intervalSpecifies invoicing frequency. Either day, week, month or year.subscription
subscription__pending_invoice_item_interval__interval_countNUMERICSubscription pending invoice item interval countThe 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_intentTEXTSubscription pending setup intentYou 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_anchorDATESubscription pending update billing cycle anchorIf 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_atDATESubscription pending update expire dateThe point after which the changes reflected by this update will be discarded and no longer applied.subscription
subscription__pending_update__subscription_itemsOBJECTSubscription pending update subscription itemsList of subscription item IDs, leading to plans that will be set if the update is applied.subscription
subscription__pending_update__trial_endDATESubscription pending update trial end dateDate 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_planBOOLEANSubscription pending update trial from planIndicates 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__scheduleTEXTSubscription schedule IDThe ID of schedule attached to the subscription.subscription
subscription__start_dateDATESubscription start dateDate when the subscription was first created. The date might differ from the created date due to backdating.subscription
subscription__statusTEXTSubscription status (Stripe)The subscription status. Enum: "incomplete", "incomplete_expired", "trialing", "active", "past_due", "canceled", "unpaid", "paused"subscription
subscription__test_clockTEXTSubscription test clock IDID of the test clock this subscription belongs to.subscription
subscription__transfer_data__amount_percentNUMERICSubscription 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__destinationTEXTSubscription 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_endDATESubscription trial endIf the subscription has a trial, the end of that trial.subscription
subscription__trial_settings__end_behavior__missing_payment_methodTEXTSubscription trial settings end behavior missing payment methodIndicates how the subscription should change when the trial ends if the user did not provide a payment method.subscription
subscription__trial_startDATESubscription trial startIf the subscription has a trial, the beginning of that trial.subscription
todayDATETodayToday's date
transaction__amountNUMERICTransaction amountThe transaction amounttransaction
transaction__currencyTEXTTransaction currencyThe transaction three-letter ISO currency code, in lowercase.transaction
transaction__descriptionTEXTTransaction descriptionThe transaction descriptiontransaction
transaction__emailTEXTTransaction emailThe email address of the customer placing the order.transaction
transaction__feeNUMERICTransaction fee (same as fee)The transaction feetransaction
transaction__idTEXTTransaction ID (same as transactionid)The transaction idtransaction
transaction__netNUMERICTransaction net amountNet amount of the transaction.transaction
transaction__statusTEXTTransaction statusThe transaction statustransaction
transaction__typeTEXTTransaction typeThe transaction typetransaction
transactionidTEXTTransaction IDThe transaction idtransaction
typeTEXTTypeTransaction Typetransaction
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20