JDBC Driver for Shopify

Build 23.0.8839

Catalogs

The catalogs belonging to the shop.

Select

The 本製品 processes all filters client-side within the 本製品. The following query is the only one processed server side:

  SELECT * FROM Catalogs

Insert

Insert statements are mapped to the 'catalogCreate' GraphQL mutation.

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

Status, Title, PriceListId, PublicationId

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

CompanyLocationIds

Update

Update statements are mapped to the 'catalogUpdate' GraphQL mutation.

The following columns can be updated:

Id, Status, Title, PriceListId, PublicationId

The following pseudo-columns can be updated:

CompanyLocationIds

Delete

Delete statements are mapped to the 'catalogDelete' GraphQL mutation.

You can delete entries by specifying the Id

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

Status String False

The status of the catalog.

Title String False

The name of the catalog.

PriceListId String False

A globally-unique ID.

PublicationId String False

A globally-unique ID.

OperationId String True

A globally-unique ID.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。

Name Type Description
CompanyLocationIds String

The IDs of the company locations to associate to the catalog.

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