Metafields

Retrieves a list of metafields that belong to a resource.

Table-Specific Information

OwnerResource or the metafield Id (when executing non-bulk operations) 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.

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