Products
Query the available products 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, Active, Created, Shippable, Type, and Url support the following operators: IN,<,>>=,<,<=,=.
The following query retrieves all products:
SELECT * FROM Products
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:
Product by specifying its Id:
SELECT * FROM Products WHERE Id = '12345678'
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'
Insert
Name are required to create a product.
INSERT INTO Products(Name,images,featuresAggregate,MetadataAggregate) values ('asdwd','[\"http://da.cs/fs.jpg\",\"http://da.cs/fss.jpg\"]','[{\"name\":\"asdsa\"}]','[{\"nsame\":\"asdsa\"}]')
Update
To update a product, specify Id column.
Update Products set Name = 'fafs' where id = 'prod_PEcZQqWgJzbBCW'
Delete
To delete a product, specify Id column.
Delete Products where id = 'prod_PEcZQqWgJzbBCW'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
ID of product. | |
| Active | Boolean | False |
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. | |
| FeaturesAggregate | String | False |
A list of up to 5 attributes that each SKU can provide value. | |
| AttributesAggregate | String | False |
A list of up to 5 attributes that each SKU can provide value. | |
| Caption | String | True |
A short one-line description of the product, meant to be displayable to the customer. | |
| Created | Datetime | True |
The time when product is created. | |
| DefaultPrice | String | False |
The ID of the Price object that is the default price for this product. Can be used in Update. | |
| Description | String | False |
The product's description, meant to be displayable to the customer. | |
| Name | String | False |
The product's name, meant to be displayable to the customer.maximum character length limit of 250 | |
| PackageDimensionsHeight | Double | False |
The height dimension of this product for shipping purposes. | |
| PackageDimensionsLength | Double | False |
The length dimension of this product for shipping purposes. | |
| PackageDimensionsWeight | Double | False |
The weight dimension of this product for shipping purposes. | |
| PackageDimensionsWidth | Double | False |
The width dimension of this product for shipping purposes. | |
| Shippable | Boolean | False |
Whether this product is a shipped good. | |
| StatementDescriptor | String | False |
Extra information about a charge for the credit card statement of the customer. | |
| Updated | Datetime | True |
The last updated time. | |
| Type | String | True |
The type of the product. | |
| Url | String | False |
The URL of a publicly-accessible webpage for this product. | |
| TaxCode | String | False |
A tax code ID. | |
| Livemode | Boolean | True |
Tells if the dispute is in livemode. | |
| MetadataAggregate | String | False |
Set of key-value pairs | |
| Object | String | True |
String representing the object's type. Objects of the same type share the same value. | |
| UnitLabel | String | False |
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 | False |
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.
| Name | Type | Description |
| AccountId | String |
The Id of the connected account to get products for. |