JDBC Driver for Adobe Commerce

Build 24.0.9060

GiftMessageGuestCart

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

Table Specific Information

Select

The driver uses the AdobeCommerce API to filter the results by CartId while the rest of the filter is executed client side within the driver.

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

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

Insert

To add a gift message, the CartId, Message, Recipient and Sender columns are required.

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

Columns

Name Type ReadOnly Description
CustomerId Int False

Customer ID. Otherwise, null.

CartId String False

cartId

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 24.0.9060