Power BI Connector for Adobe Commerce

Build 23.0.8839


GiftMessageGuestItem is an auto generated table. The supported operations are Insert, and Querying data from this table.

Table Specific Information


The CartId and ItemId columns must be specified in the WHERE clause to retrieve results from GiftMessageGuestItem. CartId and ItemId can be used only with the equals (=) operator.

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

SELECT * FROM [GiftMessageGuestItem] WHERE ItemId = '123' AND CartId = '234'


To create a new gift message for an item, the CartId, ItemId, Message, Recipient and Sender columns are required.

INSERT INTO GiftMessageGuestItem (Message, Recipient, Sender, CartId, ItemId) VALUES ('sample', 'recipient name', 'sender name', '12', '13')


Name Type ReadOnly Description
CustomerId Int False

Customer ID. Otherwise, null.

CartId String False


ExtensionAttributes String False

This is an auto-generated column

GiftMessageId [KEY] Int False

Gift message ID. Otherwise, null.

Message String False

Message text.

Recipient String False

Recipient name.

Sender String False

Sender name.

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