ADO.NET Provider for Stripe

Build 23.0.8771

Skus

Query the available SKUs 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 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

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

Name Type Description
InStock Boolean if the SKUs is either in stock or out of stock
AccountId String The Id of the connected account to get SKUs for.

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