ProductMetafields
Returns a list of Product Metafields.
Table Specific Information
Select
The 本製品 uses the BigCommerce API to process WHERE clause conditions built with Id and ProductId, which supports the '=' operator.
The rest of the filter is executed client-side within the 本製品.
For example, the following queries are processed server-side:
SELECT * FROM ProductMetafields where ProductId=77 SELECT * FROM ProductMetafields where ProductId=77 and Id=2
Insert
To insert a new ProductMetafields, you need to specify at least the following columns: ProductId, Description, Namespace, Key, Value, and PermissionSet.
Insert Into ProductMetafields(ProductId,Description,Namespace,Key,Value,PermissionSet) Values(88,test,Warehouse,location,88,app_only)
Update
Update ProductMetafields Set Description ='updatedtest' where ProductId=77 and Id=3
Delete
Delete FROM ProductMetafields where ProductId=77 and Id=3
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Unique ID of the Metafield. | |
ProductId [KEY] | Integer | True |
Products.Id |
The Id of the corresponding product. |
DateCreated | Datetime | True |
Date and time of the metafield?s creation. | |
DateModified | Datetime | True |
Date and time when the metafield was last updated. | |
Description | String | False |
Description for the metafields. | |
Key | String | False |
The name of the field. | |
Value | String | False |
The value of the field,must enter a JSON formatted string for ShipperHQ metafields. | |
Namespace | String | False |
Namespace for the metafield, for organizational purposes. | |
OwnerClientId | String | True |
ID of metafield's creator. | |
PermissionSet | String | False |
Determines the visibility and writeability of the field by other API consumers.Must be one of app_only, read, write, read_and_sf_access or write_and_sf_access. 使用できる値は次のとおりです。app_only, read, write, read_and_sf_access, write_and_sf_access | |
ResourceId | Integer | True |
The ID of the resource with which the metafield is associated. | |
ResourceType | String | True |
The type of resource with which the metafield is associated. |