Products
Query the available products in Stripe.
Table Specific Information
Select
Server-Side Query Support
The 本製品 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 本製品.
- Id supports the following operator: =.
- Active supports the following operator: =.
- Created supports the following operators: <, <=, =, >, >=.
- Shippable supports the following operator: =.
- Type supports the following operator: =.
- Url supports the following operator: =.
- Description supports the following operator: =.
- Name supports the following operator: =.
- Metadata supports the following operator: =.
You can select:
A product by specifying its Id:
SELECT * FROM Products WHERE Id = '12345678'
Multiple products by specifying their 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
A name is 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 the Id:
Update Products set Name = 'fafs' where id = 'prod_PEcZQqWgJzbBCW'
Delete
To delete a product, specify the Id:
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. | |
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AccountId | String |
The Id of the connected account to get products for. |