Metafields
Lists metafields attached to one or more 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 |
A unique Id for the metafield. | |
| LegacyResourceId | Long | True |
The Id of the corresponding resource in the REST Admin API. | |
| Namespace | String | True |
The namespace, or container, that groups the metafield. Custom namespaces distinguish your metafields from those created by other apps. | |
| Key | String | True |
The unique key name of the metafield within its namespace. | |
| Value | String | True |
The data stored as metadata in the metafield. | |
| Type | String | True |
The data type of the metafield value. | |
| Description | String | True |
A human-readable description of the information stored in the metafield. | |
| DefinitionId | String | True |
The Id of the metafield definition 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. |