EcommerceCarts

A list of an account's ecommerce carts.

Table Specific Information

Select

The connector will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.

The StoreId can be retrieved by selecting the ECommerceStores view.

StoreId supports the '=' operator.
Id supports the '=' operator.

For example:

SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123'

SELECT * FROM EcommerceCarts WHERE StoreId = 'Test_Store123' and Id = '44'

Columns


Name	Type	ReadOnly	Description
StoreId [KEY]	String	False	The StoreId for the table.
Id [KEY]	String	False	A unique identifier for the cart.
Customer	String	False	Information about a specific customer. Carts for existing customers should include only the id parameter in the customer object body.
CampaignId	String	False	A string that uniquely identifies the campaign associated with a cart.
CheckoutUrl	String	False	The URL for the cart.
CurrencyCode	String	False	The three-letter ISO 4217 code for the currency that the cart uses.
OrderTotal	Decimal	False	The order total for the cart.
TaxTotal	Decimal	False	The total tax for the cart.
Lines	String	False	An array of the cart's line items. The column will not work for Update. Lines can be updated using EcommerceCartLines table.
CreatedAt	Datetime	True	The date and time when the cart was created.
UpdatedAt	Datetime	True	The date and time when the cart was last updated.

Power BI Connector for Mailchimp

EcommerceCarts

Table Specific Information

Select

Columns