ADO.NET Provider for Stripe

Build 23.0.8771

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, 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AccountId String

The Id of the connected account to get products for.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8771