Products

Query the available products in Stripe.

Table Specific Information

Select

Server-Side Query Support

The adapter will use the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client side within the adapter.

Id, Active, Created, Shippable, Type, and Url support the following operators: IN,<,>>=,<,<=,=.

The following query retrieves all products:

SELECT * FROM Products

The provider supports all columns to be used as criteria in the WHERE clause of SELECT statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

-a Product by specifying its Id:

SELECT * FROM Products WHERE Id = '12345678'

-a Product by specifying its Ids:

SELECT * FROM Products WHERE Id IN ('12345678','123456789','123456788',)

-Products that can be shipped:

SELECT * FROM Products WHERE Shippable = 'true'

-Products for a given URL:

SELECT * FROM Products WHERE URL = '/v1/skus?product=1234\u0026active=true'

-Active Products:

SELECT * FROM Products WHERE Active = True

-Products created after a certain date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):

SELECT * FROM Products WHERE Created > '12/1/2015'

Columns

Name	Type	References	Description
Id [KEY]	String		ID of product.
Active	Boolean		Whether or not the product is currently available for purchase. afterwards stripe:version = 2016-06-15 setting active to false no longer marks the product's SKUs as inactive.
AttributesAggregate	String		A list of up to 5 attributes that each SKU can provide value.
Caption	String		A short one-line description of the product, meant to be displayable to the customer.
Created	Datetime		The time when product is created.
Description	String		The product's description, meant to be displayable to the customer.
Name	String		The product's name, meant to be displayable to the customer.maximum character length limit of 250
PackageDimensionsHeight	Double		The height dimension of this product for shipping purposes.
PackageDimensionsLength	Double		The length dimension of this product for shipping purposes.
PackageDimensionsWeight	Double		The weight dimension of this product for shipping purposes.
PackageDimensionsWidth	Double		The width dimension of this product for shipping purposes.
Shippable	Boolean		Whether this product is a shipped good.
StatementDescriptor	String		Extra information about a charge for the credit card statement of the customer.
Updated	Datetime		The last updated time.
Type	String		The type of the product..
Url	String		The URL of a publicly-accessible webpage for this product.
TaxCode	String		A tax code ID.
Livemode	Boolean		Tells if the dispute is in livemode.
MetadataAggregate	String		Set of key-value pairs
Object	String		String representing the object's type. Objects of the same type share the same value.
UnitLabel	String		A 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.
Images	String		A list of up to 8 URLs of images for this product, meant to be displayable to the customer.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.