StoreMetaFields

Returns a list of Store Metafields.

Table Specific Information

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

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

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

SELECT * FROM StoreMetaFields WHERE Id = 12

SELECT * FROM StoreMetaFields WHERE Namespace = 'Warehouse'

To insert a metafield for a store, specify at least the Namespace, Key, Value and PermissionSet columns.

INSERT INTO StoreMetaFields ( Description, Namespace, Key, Value, PermissionSet) VALUES ( 'test1', 'Warehouse21', 'location', '88', 'read')

UPDATE StoreMetaFields SET Value = 'Updated Value' WHERE Id = 12

DELETE FROM StoreMetaFields WHERE Id = 12


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Unique ID of the metafield.
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.
Description	String	False	Description for the metafield.
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.
ResourceType	String	True	The type of resource with which the metafield is associated. Always store for this table.
ResourceId	String	True	The ID of the resource with which the metafield is associated.
OwnerClientId	String	True	ID of the metafield's creator.
DateCreated	Datetime	True	Date and time of the metafield's creation.
DateModified	Datetime	True	Date and time when the metafield was last updated.