Metafields

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

Table-Specific Information

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

OwnerResource must be one of the following values:

shop
draft_order
product
variant
page
article
order
customer
collection
blog
product_image

Any other value will run the query against "shop" instead.

Select

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

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

OwnerResource is a required column, 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 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

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