Metafields
Retrieves a list of metafields that belong to one or many resource IDs.
View-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the Id, OwnerId and OwnerResource columns. The adapter processes other filters client-side within the adapter.
OwnerResource is a required column, and eligible values include "product" and "variant".
The following columns correspond to the same name columns in the REST table, except for Id and LegacyResourceId:
- Id
- LegacyResourceId
- Namespace
- Key
- Value
- Type
- Description
- OwnerId
- OwnerResource
- CreatedAt
- UpdatedAt
Id corresponds to REST.Metafields.AdminGraphqlApiId, and LegacyResourceId corresponds to REST.Metafields.Id.
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'
Columns
Name | Type | References | Description |
Id [KEY] | String | The unique ID of the metafield. | |
LegacyResourceId | Long | The ID of the corresponding resource in the REST Admin API. | |
Namespace | String | A container for a set of metafields. You need to define a custom namespace for your metafields to distinguish them from the metafields used by other apps. | |
Key | String | The name of the metafield. | |
Value | String | The information to be stored as metadata. | |
Type | String | The metafield's information type. | |
Description | String | A description of the information that the metafield contains. | |
OwnerId | String | The ID of the resource that the metafield is attached to. | |
OwnerResource | String | The type of resource that the metafield is attached to.
The allowed values are product, variant. | |
CreatedAt | Datetime | The date and time when the metafield was created. | |
UpdatedAt | Datetime | The date and time when the metafield was last updated. |