Products

Columns

Name	Type	References	Description
Id [KEY]	String		ID of product.
Active	Boolean		Whether or not the product is currently available for purchase.
AttributesAggregate	String		A list of up to 5 attributes that each SKU can provide value.
Caption	String		A short one-line description of the product, meant to be displayable to the customer.
Created	Datetime		The time when product is created.
Description	String		The product's description, meant to be displayable to the customer.
Name	String		The product's name, meant to be displayable to the customer.
PackageDimensionsHeight	Double		The height dimension of this product for shipping purposes.
PackageDimensionsLength	Double		The length dimension of this product for shipping purposes.
PackageDimensionsWeight	Double		The weight dimension of this product for shipping purposes.
PackageDimensionsWidth	Double		The width dimension of this product for shipping purposes.
Shippable	Boolean		Whether this product is a shipped good.
StatementDescriptor	String		Extra information about a charge for the credit card statement of the customer.
Updated	Datetime		The last updated time.
Type	String		The type of the product..
Skus	String		A sublist of active SKUs associated with this product.
Url	String		The URL of a publicly-accessible webpage for this product.

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.