CartMetafields

Returns a list of Cart Metafields.

Table Specific Information

Select

The add-in uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

Id supports the = comparison.
CartId supports the = comparison. A value for CartId is required.
Key supports the = comparison.
Namespace supports the = comparison.

The rest of the filter is executed client-side within the add-in.

For example, the following queries are processed server-side:

SELECT * FROM CartMetafields WHERE CartId = '82676093-e069-4d1d-93a2-96c1d3169dfc'
SELECT * FROM CartMetafields WHERE CartId = '82676093-e069-4d1d-93a2-96c1d3169dfc' AND Id = 2

Insert

To insert a cart metafield, specify at least the following columns: CartId, Namespace, Key, Value, and PermissionSet. Description is optional.

INSERT INTO CartMetafields (CartId, Description, Namespace, Key, Value, PermissionSet) VALUES ('82676093-e069-4d1d-93a2-96c1d3169dfc', 'test', 'Warehouse', 'location', '88', 'app_only')

Update

UPDATE CartMetafields SET Value = 'updatedtest' WHERE CartId = '82676093-e069-4d1d-93a2-96c1d3169dfc' AND Id = 3

Delete

DELETE FROM CartMetafields WHERE CartId = '82676093-e069-4d1d-93a2-96c1d3169dfc' AND Id = 3

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Unique ID of the Metafield.
CartId [KEY]	String	False	The Id of the corresponding cart.
DateCreated	Datetime	True	Date and time of the metafield's creation.
DateModified	Datetime	True	Date and time when the metafield was last updated.
Description	String	False	Description for the metafields.
Key	String	False	The name of the field.
Value	String	False	The value of the field.
Namespace	String	False	Namespace for the metafield, for organizational purposes.
OwnerClientId	String	True	ID of metafield's creator.
PermissionSet	String	False	Determines the visibility and writeability of the field by other API consumers. The allowed values are app_only, read, write, read_and_sf_access, write_and_sf_access.
ResourceId	String	True	The ID of the resource with which the metafield is associated.
ResourceType	String	True	The type of resource with which the metafield is associated.