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.
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 '=' 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:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique ID of the metafield. | |
| LegacyResourceId | Long | True |
The ID of the corresponding resource in the REST Admin API. | |
| Namespace | String | True |
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 | True |
The name of the metafield. | |
| Value | String | True |
The information to be stored as metadata. | |
| Type | String | True |
The metafield's information type. | |
| Description | String | True |
A description of the information that the metafield contains. | |
| OwnerId | String | True |
The ID of the resource that the metafield is attached to. | |
| OwnerResource | String | True |
The type of resource that the metafield is attached to. The allowed values are product, variant, shop, draft_order, order, customer, collection. | |
| CreatedAt | Datetime | True |
The date and time when the metafield was created. | |
| UpdatedAt | Datetime | True |
The date and time when the metafield was last updated. |