Skus

Query the available SKUs in Stripe.

Table Specific Information

Select

Server-Side Query Support

The connector uses 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 connector.

Id and ProductId support the following operators: IN,=.
Active support the following operator: =.

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

-a SKU by specifying its Id:

SELECT * FROM Skus WHERE Id = '12345678'

-a SKU by specifying its Ids:

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

-Skus of a Product:

SELECT * FROM Skus WHERE Product = 'pd_12345678'

-Active Skus:

SELECT * FROM Skus WHERE Active = 'true'

Columns


Name	Type	References	Description
Id [KEY]	String		Id of SKU.
Active	Boolean		Whether or not the SKU is available for purchase.
AttributesAggregate	String		A dictionary of attributes and values for the attributes defined by the product.
Created	Datetime		The time when SKU is created.
Currency	String		3-letter ISO code for currency.
Images	String		The URL of an image for this SKU, meant to be displayable to the customer.
InventoryQuantity	Double		Quantity of the SKU's inventory.
InventoryType	String		Type of the SKU's inventory.
InventoryValue	String		Value of the SKU's inventory.
PackageDimensionsHeight	Double		The height dimension of this Sku for shipping purposes.
PackageDimensionsLength	Double		The length dimension of this Sku for shipping purposes.
PackageDimensionsWeight	Double		The weight dimension of this Sku for shipping purposes.
PackageDimensionsWidth	Double		The width dimension of this Sku for shipping purposes.
Price	Integer		The cost of the item as a positive integer in the smallest currency unit.
ProductId	String		The Id of the product this SKU is associated with. The product must be currently active.
Updated	Datetime		The last updated time.
Metadata	String		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.
Livemode	Boolean		Has the value true if the object exists in live mode or the value false if the object exists in test mode.
Object	String		String representing the object's type. Objects of the same type share the same value.

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.