CData Python Connector for Shopify

Build 23.0.8839

Metafields

Retrieves a list of metafields that belong to one or many resource IDs.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' comparison operator.
  • OwnerId supports the '=,IN' comparison operators.
  • OwnerResource supports the '=' comparison operator.

OwnerResource is a required column, and eligible values include "product","variant","shop","draft_order","order","customer","collection".

The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM Metafields WHERE OwnerResource = 'product'

SELECT * FROM Metafields WHERE OwnerResource = 'product' AND Id = 'gid://shopify/Metafield/19334473318423'

SELECT * FROM Metafields WHERE OwnerId = 'gid://shopify/ProductVariant/39378393497623' AND OwnerResource = 'variant'

SELECT * FROM Metafields WHERE OwnerId IN ('gid://shopify/ProductVariant/39378393497623', 'gid://shopify/Product/1418248224791') AND OwnerResource = 'variant'

Insert

INSERT statements are mapped to the 'metafieldsSet' GraphQL mutation.

The following columns can be used to create a new record:

Namespace, Key, Value, Type, OwnerId

DELETE

DELETE statements are mapped to the 'metafieldDelete' GraphQL mutation.

You can delete entries by specifying the 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.

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.

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