テーブル

本製品はShopify のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、Shopify テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData ADO.NET Provider for Shopify テーブル


Name	Description
ApplicationCharges	Create or view Application Charges for Billing.
ApplicationCredit	Create or view Application Credit for Billing.
Articles	Create, read, update or delete articles
Assets	Create, read, update or delete assets
Blogs	Create, read, update or delete blogs
CollectionListings	Query and delete information regarding different collects.
Collects	Query, insert, or delete information regarding different collects.
Comments	Create, read, update and delete the comments.
Countries	Create, select, update, and delete information regarding countries.
CustomCollections	Query, insert, update, or delete information regarding different custom collections.
CustomerAddresses	Create, update, delete, and query customer addresses.
Customers	Create, update, delete, and query customers.
DiscountCodes	Create, select, update, and delete information regarding discount codes.
DraftOrders	Create, update, delete, and query draft orders.
FulfillmentEvents	Create, delete, and query information regarding fulfillment events.
Fulfillments	Create, update, and query fulfillments.
FulfillmentServices	Query, create, update, and delete information regarding different fulfillment services.
InventoryItems	Query and update information regarding different inventory items.
InventoryLevels	Query, create, and update information regarding different inventory levels.
MarketingEvents	Create, update, delete, and query marketing events.
Metafields	Retrieves a list of metafields that belong to a resource.
OrderRisks	Create, update, delete, and query order risks.
Orders	Create, update, delete, and query orders.
OrderTransactions	Create and query transactions.
Pages	Create, read, update or delete pages
PriceRules	Create, update, delete, and query price rules.
ProductImages	Query, Update and Delete Product Images
ProductListings	Query and delete product listings.
Products	Create, update, delete, and query products.
ProductVariants	Query and delete product listings.
Provinces	Query and update information regarding different provinces.
RecurringApplicationCharges	Create, update, delete, and query Recurring Application Charges.
Redirects	Create, read, update or delete redirects.
Refunds	Create and query refunds.
ScriptTags	Create, read, update or delete script tags.
SmartCollections	Query, insert, update, or delete information regarding different smart collections.
Themes	Create, read, update or delete themes
UsageCharges	Create or view Usage Charges for Recurring Application Charges.