ODBC Driver for Shopify

Build 24.0.9062

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData ODBC Driver for Shopify ビュー

Name Description
AbandonedCheckouts Query abandoned checkouts.
AbandonedCheckoutsItems Query abandoned checkouts items.
AssignedFulfillmentOrders The AssignedFulfillmentOrder resource allows you to retrieve all the fulfillment orders that are assigned to an app at the shop level.
DiscountApplications Query note attributes belonging to an order or draft order.
DraftOrderItemProperties Query order item properties.
DraftOrderItems Query draft order items.
DraftOrderItemTaxLines Query draft order items tax lines.
Events Retrieve events which have happened in your shop.
FulfillmentOrderLineItems Query fulfillment order line items.
FulfillmentOrders Query fulfillment orders.
Locations Retrieve information regarding store locations.
NoteAttributes Query note attributes belonging to an order or draft order.
OrderDiscountCodes Query note attributes belonging to an order or draft order.
OrderItemDiscountAllocations Query order item discount allocations.
OrderItemProperties Query order item properties.
OrdersItems Query order items.
Payouts Retrieves a list of all payouts ordered by payout date, with the most recent being first.
PayoutTransactions Retrieves a list of all balance transactions ordered by processing time, with the most recent being first.
RefundAdjustments Create and query transactions.
RefundsItems Get data on OrdersItems that have been refunded.
RefundTransactions Query transactions for Refund Object.
Reports To query all the Reports.
ShippingItemDiscountAllocations Query Shipping item discount allocations.
ShippingItems Query order shipping.
ShippingZones Retrieve information regarding shipping zones.
Shop Contains general settings and information about the shop.
TaxItems Query order taxes.
Users Query Users.

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