ProductMetafields

Returns a list of Product Metafields.

Table Specific Information

Select

The connector uses the BigCommerce API to process WHERE clause conditions built with the Id and ProductId columns, which support the = comparison.

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

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

SELECT * FROM ProductMetafields WHERE ProductId = 77
SELECT * FROM ProductMetafields WHERE ProductId = 77 and Id = 2

Insert

To insert a product metafield, specify at least the following columns: ProductId, Description, Namespace, Key, Value, and PermissionSet.

INSERT Into ProductMetafields(ProductId, Description, Namespace, Key, Value, PermissionSet) Values(88, test, Warehouse, location, 88, app_only)

Update

UPDATE ProductMetafields SET Description ='updatedtest' WHERE ProductId = 77 and Id = 3

Delete

DELETE FROM ProductMetafields WHERE ProductId = 77 and Id = 3

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Unique ID of the Metafield.
ProductId [KEY]	Integer	True	Products.Id	The Id of the corresponding product.
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,must enter a JSON formatted string for ShipperHQ metafields.
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.Must be one of app_only, read, write, read_and_sf_access or write_and_sf_access. The allowed values are app_only, read, write, read_and_sf_access, write_and_sf_access.
ResourceId	Integer	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.