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

Table Specific Information

Select

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

The connector uses the AdobeCommerce API to filter the results by CartId and ItemId while the rest of the filter is executed client side within the connector. For example:

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

Insert

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')

Columns