Power BI Connector for Adobe Commerce

Build 23.0.8839


QuoteGuestCart is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information


The 本製品 will use the AdobeCommerce API to filter the results by CartId while the rest of the filter is executed client side within the 本製品.

The CartId column must be specified in the WHERE clause to retrieve results from QuoteGuestCart. CartId can be used only with the equals (=) operator. For example:

SELECT * FROM [QuoteGuestCart] WHERE CartId = '123'


Name Type Description
Id [KEY] Int Cart/quote ID.
CartId String cartId
BillingAddress String This is an auto-generated column
ConvertedAt String Cart conversion date and time. Otherwise, null.
CreatedAt Datetime Cart creation date and time. Otherwise, null.
Currency String This is an auto-generated column
Customer String This is an auto-generated column
CustomerIsGuest Bool For guest customers, false for logged in customers
CustomerNote String Notice text
CustomerNoteNotify Bool Customer notification flag
CustomerTaxClassId Int Customer tax class ID.
ExtensionAttributes String This is an auto-generated column
IsActive Bool Active status flag value. Otherwise, null.
IsVirtual Bool Virtual flag value. Otherwise, null.
Items String Array of items. Otherwise, null.
ItemsCount Int Number of different items or products in the cart. Otherwise, null.
ItemsQty Double Total quantity of all cart items. Otherwise, null.
OrigOrderId Int Original order ID. Otherwise, null.
ReservedOrderId Int Reserved order ID. Otherwise, null.
StoreId Int Store identifier
UpdatedAt Datetime Cart last update date and time. Otherwise, null.

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