ODBC Driver for BigCommerce

Build 24.0.9111

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111