Metafields

Retrieves a list of metafields that belong to one or many resource IDs.

Table-Specific Information

Select

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

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

OwnerResource is a required column, and eligible values include "product","variant","shop","draft_order","order","customer","collection".

The connector processes other filters client-side within the connector.

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

SELECT * FROM Metafields WHERE OwnerResource = 'product'

SELECT * FROM Metafields WHERE OwnerResource = 'product' AND Id = 'gid://shopify/Metafield/19334473318423'

SELECT * FROM Metafields WHERE OwnerId = 'gid://shopify/ProductVariant/39378393497623' AND OwnerResource = 'variant'

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

Insert

INSERT statements are mapped to the 'metafieldsSet' GraphQL mutation.

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

Namespace, Key, Value, Type, OwnerId

DELETE

DELETE statements are mapped to the 'metafieldDelete' GraphQL mutation.

You can delete entries by specifying the Id.

Columns