Stripe

Outros · Disponível

Consultar via API

GET https://askaner.askan.com.br/api/v1/data/stripe?fields=date,account_id&date_preset=last_30d
Authorization: Bearer ik_...

Campos (35 métricas, 169 dimensões)

ID	Tipo	Natureza	Descrição
`balance__amount`	NUMERIC	Métrica	The balance amount currently on your Stripe account.
`balance__currency`	TEXT	Dimensão	The balance three-letter ISO currency code, in lowercase.
`balance__source_types__bank_account`	NUMERIC	Métrica	Breakdown of balance by bank account.
`balance__source_types__card`	NUMERIC	Métrica	Breakdown of balance by card.
`balance__source_types__fpx`	NUMERIC	Métrica	Breakdown of balance by FPX.
`invoice__amount_due`	NUMERIC	Métrica	Final amount due at this time for the invoice.
`invoice__amount_paid`	NUMERIC	Métrica	The amount that was paid on the invoice.
`invoice__created`	DATE	Dimensão	Time at which the invoice was created.
`invoice__currency`	TEXT	Dimensão	Three-letter ISO currency code of the invoice, in lowercase.
`invoice__customer`	TEXT	Dimensão	The ID of the customer who will be billed for the invoice.
`invoice__id`	TEXT	Dimensão	Unique identifier for the invoice.
`invoice__subtotal`	NUMERIC	Métrica	Total of all line items before any invoice-level discount or tax is applied.
`invoice__tax`	NUMERIC	Métrica	The amount of tax on the invoice.
`invoice__total`	NUMERIC	Métrica	Total of the invoice after discounts and taxes are applied.
`invoice__total_discount_amounts`	NUMERIC	Métrica	Aggregated amount of all discounts applied to the invoice.
`payout__amount`	NUMERIC	Métrica	The payout amount.
`payout__arrival_date`	DATE	Dimensão	The date when payout was arrived.
`payout__created`	DATE	Dimensão	The date when payout was created.
`payout__currency`	TEXT	Dimensão	The payout three-letter ISO currency code, in lowercase.
`payout__description`	TEXT	Dimensão	The payout description.
`payout__id`	TEXT	Dimensão	The payout id.
`payout__status`	TEXT	Dimensão	Status of the payout.
`product__active`	BOOLEAN	Dimensão	Whether the product is currently available for purchase.
`product__created`	DATE	Dimensão	The date when product was created.
`product__default_price`	TEXT	Dimensão	The ID of the Price object that is the default price for this product.
`product__description`	TEXT	Dimensão	The product's description.
`product__features__10__name`	TEXT	Dimensão	Feature name 10 for this product. This is displayed in pricing tables.
`product__features__11__name`	TEXT	Dimensão	Feature name 11 for this product. This is displayed in pricing tables.
`product__features__12__name`	TEXT	Dimensão	Feature name 12 for this product. This is displayed in pricing tables.
`product__features__13__name`	TEXT	Dimensão	Feature name 13 for this product. This is displayed in pricing tables.
`product__features__14__name`	TEXT	Dimensão	Feature name 14 for this product. This is displayed in pricing tables.
`product__features__15__name`	TEXT	Dimensão	Feature name 15 for this product. This is displayed in pricing tables.
`product__features__1__name`	TEXT	Dimensão	Feature name 1 for this product. This is displayed in pricing tables.
`product__features__2__name`	TEXT	Dimensão	Feature name 2 for this product. This is displayed in pricing tables.
`product__features__3__name`	TEXT	Dimensão	Feature name 3 for this product. This is displayed in pricing tables.
`product__features__4__name`	TEXT	Dimensão	Feature name 4 for this product. This is displayed in pricing tables.
`product__features__5__name`	TEXT	Dimensão	Feature name 5 for this product. This is displayed in pricing tables.
`product__features__6__name`	TEXT	Dimensão	Feature name 6 for this product. This is displayed in pricing tables.
`product__features__7__name`	TEXT	Dimensão	Feature name 7 for this product. This is displayed in pricing tables.
`product__features__8__name`	TEXT	Dimensão	Feature name 8 for this product. This is displayed in pricing tables.
`product__features__9__name`	TEXT	Dimensão	Feature name 9 for this product. This is displayed in pricing tables.
`product__id`	TEXT	Dimensão	The product id.
`product__images__1`	IMAGE	Dimensão	An URL of image 1 for this product, meant to be displayable to the customer.
`product__images__2`	IMAGE	Dimensão	An URL of image 2 for this product, meant to be displayable to the customer.
`product__images__3`	IMAGE	Dimensão	An URL of image 3 for this product, meant to be displayable to the customer.
`product__images__4`	IMAGE	Dimensão	An URL of image 4 for this product, meant to be displayable to the customer.
`product__images__5`	IMAGE	Dimensão	An URL of image 5 for this product, meant to be displayable to the customer.
`product__images__6`	IMAGE	Dimensão	An URL of image 6 for this product, meant to be displayable to the customer.
`product__images__7`	IMAGE	Dimensão	An URL of image 7 for this product, meant to be displayable to the customer.
`product__images__8`	IMAGE	Dimensão	An URL of image 8 for this product, meant to be displayable to the customer.
`product__livemode`	BOOLEAN	Dimensão	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	Dimensão	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	Dimensão	The product's name.
`product__package_dimensions__height`	NUMERIC	Métrica	Height of the product for shipping purposes, in inches.
`product__package_dimensions__length`	NUMERIC	Métrica	Length of the product for shipping purposes, in inches.
`product__package_dimensions__weight`	NUMERIC	Métrica	Weight of the product for shipping purposes, in ounces.
`product__package_dimensions__width`	NUMERIC	Métrica	Width of the product for shipping purposes, in inches.
`product__shippable`	BOOLEAN	Dimensão	Whether this product is shipped (i.e., physical goods).
`product__statement_descriptor`	TEXT	Dimensão	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	Dimensão	A tax code ID.
`product__unit_label`	TEXT	Dimensão	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	Dimensão	A label that represents units of this product. When set, this will be included in customers' receipts, invoices, Checkout, and the customer portal.
`product__url`	TEXT	Dimensão	A URL of a publicly-accessible webpage for this product.
`refund__amount`	NUMERIC	Métrica	The refund amount.
`refund__balance_transaction`	TEXT	Dimensão	ID of the balance transaction that describes the impact of the refund on the account balance.
`refund__charge`	TEXT	Dimensão	ID of the charge that was refunded.
`refund__created`	DATE	Dimensão	The date when refund was created.
`refund__currency`	TEXT	Dimensão	The refund three-letter ISO currency code, in lowercase.
`refund__description`	TEXT	Dimensão	The refund description.
`refund__id`	TEXT	Dimensão	The refund id.
`refund__payment_intent`	TEXT	Dimensão	ID of the PaymentIntent that was refunded.
`refund__reason`	TEXT	Dimensão	Reason for the refund.
`refund__status`	TEXT	Dimensão	Status of the refund.
`subscription__application`	TEXT	Dimensão	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	Métrica	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	Dimensão	Whether Stripe automatically computes tax on this subscription.
`subscription__billing_cycle_anchor`	DATE	Dimensão	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	Métrica	Monetary threshold that triggers the subscription to create an invoice
`subscription__billing_thresholds__reset_billing_cycle_anchor`	NUMERIC	Métrica	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	Dimensão	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	Dimensão	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	Dimensão	Additional comments about why the user canceled the subscription, if the subscription was canceled explicitly by the user.
`subscription__cancellation_details__feedback`	TEXT	Dimensão	The customer submitted reason for why they canceled, if the subscription was canceled explicitly by the user.
`subscription__cancellation_details__reason`	TEXT	Dimensão	Why this subscription was canceled.
`subscription__collection_method`	TEXT	Dimensão	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	Dimensão	The date when subscription was created.
`subscription__currency`	TEXT	Dimensão	Three-letter ISO currency code, in lowercase. Must be a stripe supported currency.
`subscription__current_period_end`	DATE	Dimensão	End of the current period that the subscription has been invoiced for.
`subscription__current_period_start`	DATE	Dimensão	Start of the current period that the subscription has been invoiced for.
`subscription__customer`	TEXT	Dimensão	ID of the customer who owns the subscription.
`subscription__days_until_due`	NUMERIC	Métrica	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	Dimensão	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	Dimensão	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	Dimensão	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	Dimensão	The subscription description.
`subscription__discount__coupon__amount_off`	NUMERIC	Métrica	Amount taken off the subtotal of invoices for this subscription, in the coupon currency.
`subscription__discount__coupon__currency`	TEXT	Dimensão	Three-letter ISO currency code of the discount amount off, when amount_off is set.
`subscription__discount__coupon__duration`	TEXT	Dimensão	How long the discount applies. One of forever, once or repeating.
`subscription__discount__coupon__id`	TEXT	Dimensão	Unique identifier of the coupon backing the subscription discount.
`subscription__discount__coupon__percent_off`	PERCENT	Métrica	Percent taken off the subtotal of invoices for this subscription for the duration of the coupon.
`subscription__discount__id`	TEXT	Dimensão	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	Dimensão	If the subscription has ended, the date the subscription ended.
`subscription__id`	TEXT	Dimensão	The subscription id.
`subscription__items`	OBJECT	Dimensão	List of subscription items, each with an attached price.
`subscription__latest_invoice`	TEXT	Dimensão	ID of the most recent invoice this subscription has generated.
`subscription__livemode`	BOOLEAN	Dimensão	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	Dimensão	The subscription metadata.
`subscription__next_pending_invoice_item_invoice`	DATE	Dimensão	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	Dimensão	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	Dimensão	The payment collection behavior for this subscription while paused. One of keep_as_draft, mark_uncollectible, or void.
`subscription__pause_collection__resumes_at`	DATE	Dimensão	The date after which the subscription will resume collecting payments.
`subscription__payment_settings__payment_method_options__acss_debit__mandate_options__transaction_type`	TEXT	Dimensão	Transaction type of the mandate for Canadian pre-authorized debit payment.
`subscription__payment_settings__payment_method_options__acss_debit__verification_method`	TEXT	Dimensão	Bank account verification method.
`subscription__payment_settings__payment_method_options__bancontact__preferred_language`	TEXT	Dimensão	Preferred language of the Bancontact authorization page that the customer is redirected to.
`subscription__payment_settings__payment_method_options__card__mandate_options__amount`	NUMERIC	Métrica	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	Dimensão	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	Dimensão	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	Dimensão	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	Dimensão	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	Dimensão	The bank transfer type that can be used for funding.
`subscription__payment_settings__payment_method_options__customer_balance__funding_type`	TEXT	Dimensão	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	Dimensão	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	Dimensão	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	Dimensão	Data features requested to be retrieved upon account creation.
`subscription__payment_settings__payment_method_options__us_bank_account__verification_method`	TEXT	Dimensão	Bank account verification method.
`subscription__payment_settings__payment_method_types`	OBJECT	Dimensão	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	Dimensão	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	Dimensão	Specifies invoicing frequency. Either day, week, month or year.
`subscription__pending_invoice_item_interval__interval_count`	NUMERIC	Métrica	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	Dimensão	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	Dimensão	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	Dimensão	The point after which the changes reflected by this update will be discarded and no longer applied.
`subscription__pending_update__subscription_items`	OBJECT	Dimensão	List of subscription item IDs, leading to plans that will be set if the update is applied.
`subscription__pending_update__trial_end`	DATE	Dimensão	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	Dimensão	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	Dimensão	The ID of schedule attached to the subscription.
`subscription__start_date`	DATE	Dimensão	Date when the subscription was first created. The date might differ from the created date due to backdating.
`subscription__status`	TEXT	Dimensão	The subscription status. Enum: "incomplete", "incomplete_expired", "trialing", "active", "past_due", "canceled", "unpaid", "paused"
`subscription__test_clock`	TEXT	Dimensão	ID of the test clock this subscription belongs to.
`subscription__transfer_data__amount_percent`	NUMERIC	Métrica	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	Dimensão	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	Dimensão	If the subscription has a trial, the end of that trial.
`subscription__trial_settings__end_behavior__missing_payment_method`	TEXT	Dimensão	Indicates how the subscription should change when the trial ends if the user did not provide a payment method.
`subscription__trial_start`	DATE	Dimensão	If the subscription has a trial, the beginning of that trial.
`subscription_item__billing_thresholds__usage_gte`	NUMERIC	Métrica	Usage threshold that triggers the subscription to create an invoice.
`subscription_item__created`	DATE	Dimensão	Time at which the subscription item was created.
`subscription_item__id`	TEXT	Dimensão	Unique identifier for the subscription item.
`subscription_item__metadata`	OBJECT	Dimensão	Set of key-value pairs that you can attach to an object.
`subscription_item__price__active`	BOOLEAN	Dimensão	Whether the price is currently available for purchase.
`subscription_item__price__currency`	TEXT	Dimensão	Three-letter ISO currency code for the price.
`subscription_item__price__id`	TEXT	Dimensão	The ID of the price associated with this subscription item.
`subscription_item__price__product`	TEXT	Dimensão	The ID of the product this price is associated with.
`subscription_item__price__recurring__interval`	TEXT	Dimensão	The frequency at which a subscription is billed. One of day, week, month or year.
`subscription_item__price__recurring__interval_count`	NUMERIC	Métrica	The number of intervals between subscription billings.
`subscription_item__price__recurring__usage_type`	TEXT	Dimensão	Configures how the quantity per period should be determined. Can be either metered or licensed.
`subscription_item__price__type`	TEXT	Dimensão	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	Métrica	The unit amount in cents to be charged, represented as a whole integer if possible.
`subscription_item__price__unit_amount_decimal`	TEXT	Dimensão	The unit amount in cents to be charged, represented as a decimal string with at most 12 decimal places.
`subscription_item__quantity`	NUMERIC	Métrica	The quantity of the plan to which the customer should be subscribed.
`subscription_item__subscription`	TEXT	Dimensão	The ID of the subscription this item belongs to.
`subscription_item__tax_rates`	OBJECT	Dimensão	The tax rates which apply to this subscription item.
`amount`	NUMERIC	Métrica	The transaction amount
`currency`	TEXT	Dimensão	The transaction three-letter ISO currency code, in lowercase.
`customer_id`	TEXT	Dimensão	The Stripe customer ID
`description`	TEXT	Dimensão	Transaction Description
`email`	TEXT	Dimensão	The email address of the customer placing the order.
`fee`	NUMERIC	Métrica	The transaction fee
`net`	NUMERIC	Métrica	Net amount of the transaction, in pence.
`reporting_category`	TEXT	Dimensão	Transaction Reporting Category (charge, refund, payout, etc.)
`status`	TEXT	Dimensão	The transaction status
`transaction__amount`	NUMERIC	Métrica	The transaction amount
`transaction__created`	DATE	Dimensão	The date when transaction was created.
`transaction__currency`	TEXT	Dimensão	The transaction three-letter ISO currency code, in lowercase.
`transaction__description`	TEXT	Dimensão	The transaction description
`transaction__email`	TEXT	Dimensão	The email address of the customer placing the order.
`transaction__fee`	NUMERIC	Métrica	The transaction fee
`transaction__id`	TEXT	Dimensão	The transaction id
`transaction__net`	NUMERIC	Métrica	Net amount of the transaction.
`transaction__source`	TEXT	Dimensão	ID of the Stripe object that caused this transaction, e.g. the charge (ch_...) or the refund (re_...).
`transaction__status`	TEXT	Dimensão	The transaction status
`transaction__type`	TEXT	Dimensão	The transaction type
`transactionid`	TEXT	Dimensão	The transaction id
`type`	TEXT	Dimensão	Transaction Type
`account_id`	TEXT	Dimensão	The Account ID
`account_name`	TEXT	Dimensão	The Account Name
`data_fetched_at`	TIMESTAMP	Dimensão	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	Dimensão	The name of the Windsor connector returning the row
`date`	DATE	Dimensão	Date
`day_of_month`	TEXT	Dimensão	Day of the month
`month`	TEXT	Dimensão	Number of the month
`now`	TIMESTAMP	Dimensão	Current timestamp
`source`	TEXT	Dimensão	The name of the Windsor connector returning the row
`today`	DATE	Dimensão	Today's date
`week`	TEXT	Dimensão	Week (Sun-Sat).
`week_day`	TEXT	Dimensão	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
`week_day_iso`	TEXT	Dimensão	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
`week_iso`	TEXT	Dimensão	Week, ISO format (Mon-Sun).
`year`	TEXT	Dimensão	Year
`year_month`	TEXT	Dimensão	Year and month, e.g. 2024\|3
`year_month_name`	TEXT	Dimensão	Year and month with the month name written out, e.g. "Jan 2025".
`year_of_week`	TEXT	Dimensão	The year that contains first day of the week (Sun-Sat).
`year_of_week_iso`	TEXT	Dimensão	The year that contains first day of the ISO week (Mon-Sun).
`year_week`	TEXT	Dimensão	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
`year_week_iso`	TEXT	Dimensão	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20