Metafields
Retrieves a list of metafields that belong to one or many resource IDs.
Table-Specific Information
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 = 'Val1'
SELECT * FROM Metafields WHERE OwnerId = 'Val1'
SELECT * FROM Metafields WHERE OwnerResource = 'product'
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 columns:
Namespace, Key, OwnerId
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. | |
| DefinitionId | String | True |
The metafield definition that the metafield belongs to, if any. | |
| 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, media_image, selling_plan, article, blog, page. | |
| 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. |