Query the available SKUs in Stripe.
Table Specific Information
Server-Side Query Support
The connector 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 connector.
- Id, Active, AttributesAggregate, ProductId support the following operators IN :=.
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 retreive:
-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'
-Skus that are in stock:
SELECT * FROM Skus WHERE InStock='true'
SELECT * FROM Skus WHERE Active='true'
|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||Description of the SKU's inventory.|
|InventoryType||String||Description of the SKU's inventory.|
|InventoryValue||Double||Description 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.|
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.
|InStock||String||if the SKUs is either in stock or out of stock|
|AccountId||String||The Id of the connected account to get SKUs for.|