GiftMessageItem
GiftMessageItem is an auto generated table. The supported operations are Insert, and Querying data from this table.
Table Specific Information
Select
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 本製品.
The CartId and ItemId column must be specified in the WHERE clause to retrieve results from GiftMessageItem. CartId and ItemId can be used only with the equals (=) operator.
For example:
SELECT * FROM [GiftMessageItem] WHERE CartId = '123' AND ItemId = '234'
Insert
To create a new gift message for an item, the CartId, ItemId, Message, Recipient and Sender columns are required.
INSERT INTO GiftMessageItem (Message, Recipient, Sender, CartId, ItemId) VALUES ('sample', 'recipient name', 'sender name', '12', '13')
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. |