turbot/stripe

steampipe plugin install stripesteampipe plugin install stripe

Table: stripe_product

Query information about products defined in the Stripe account.

Examples

List all products

select
*
from
stripe_product

All products that are not active

select
*
from
stripe_product
where
not active

.inspect stripe_product

Products available for purchase or subscription.

NameTypeDescription
activebooleanWhether the product is currently available for purchase.
createdtimestamp without time zoneTime at which the product was created.
descriptiontextAn arbitrary string attached to the product. Often useful for displaying to users.
idtextUnique identifier for the product.
imagesjsonbA list of up to 8 URLs of images for this product, meant to be displayable to the customer.
livemodebooleanHas the value true if the product exists in live mode or the value false if the product exists in test mode.
metadatajsonbSet of key-value pairs that you can attach to an product. This can be useful for storing additional information about the product in a structured format.
nametextThe product’s full name or business name.
package_dimensionsjsonbThe dimensions of this product for shipping purposes.
shippablebooleanWhether this product is shipped (i.e., physical goods).
statement_descriptortextExtra 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.
typetextThe product type.
unit_labeltextA label that represents units of this product in Stripe and on customers’ receipts and invoices. When set, this will be included in associated invoice line item descriptions.
updatedtimestamp without time zoneTime at which the product was updated.
urltextA URL of a publicly-accessible webpage for this product.