Metafields

Retrieves a list of metafields that belong to a resource.

Table-Specific Information

OwnerResource or the metafield Id is required for any query against Metafields.

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

Id supports the '=, IN' comparison operators.
OwnerId supports the '=, IN' comparison operators.
OwnerResource supports the '=' comparison operator.

OwnerResource is a required column (except for when executing non-bulk operations and Id is specified), and eligible values include "product","variant","shop","draft_order","order","customer","collection".

For example, the following queries are processed server side:

	SELECT * FROM Metafields WHERE Id = 'gid://shopify/Metafield/19334473318423'
	SELECT * FROM Metafields WHERE Id IN ('gid://shopify/Metafield/19334473318423', 'gid://shopify/Metafield/19334473318424')
	SELECT * FROM Metafields WHERE OwnerResource = 'product'
	SELECT * FROM Metafields WHERE OwnerResource = 'variant' AND OwnerId = 'gid://shopify/ProductVariant/39378393497623'
	SELECT * FROM Metafields WHERE OwnerResource = 'variant' AND OwnerId IN ('gid://shopify/ProductVariant/39378393497623', 'gid://shopify/Product/1418248224791')

Insert

The following columns can be used to create a new record:

Namespace, Key, Value, Type, OwnerId

Delete

You can delete entries by specifying the following column:

Columns