ビュー

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

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

CData SSIS Components for WooCommerce ビュー


Name	Description
Continents	Retrieve continents.
Countries	Retrieve countries.
Currencies	Retrieve available currencies.
CustomerDownloads	Retrieves the permissions required for customer downloads.
CustomerMetadata	Retrieve the metadata for each customer.
Data	Retrieves a list of available data endpoints.
OrderCouponLines	Retrieve the coupon lines for an order.
OrderFeeLines	Retrieve the fee lines for an order.
OrderRefundLineItems	Retrieve the line items for a refund.
OrderShippingLines	Retrieve the shipping lines for an order.
OrderTaxLines	Retrieve the tax lines for an order.
ProductAttributes	Retrieve product attributes.
ProductCategories	Retrieve product categories.
ProductImages	Retrieve images for a product.
Refunds	Retrieve and view refunds from your store, regardless of which order they are associated with.
Reports	Retrieves a list of available reports.
SalesReport	Executes a Sales report.
SettingGroups	Retrieve settings groups.
ShippingLocations	Retrieve shipping zone locations.
ShippingMethods	Retrieve shipping methods.
States	Retrieve shipping states.
SubscriptionCouponLines	Retrieves all subscription coupon lines. This view shows data only if the WooCommerce Subscriptions Plugin is enabled.
SubscriptionFeeLines	Retrieves all subscription fee lines. This view shows data only if the WooCommerce Subscriptions Plugin is enabled.
SubscriptionLineItems	Retrieves all subscription line items. This view shows data only if the WooCommerce Subscriptions Plugin is enabled.
SubscriptionOrders	Retrieves all subscription orders. This view shows data only if the WooCommerce Subscriptions Plugin is enabled.
SubscriptionShippingLines	Retrieves all subscription shipping lines. This view shows data only if the WooCommerce Subscriptions Plugin is enabled.
SystemStatus	Retrieves system status items.
SystemStatusPages	Retrieve and system status items.
SystemStatusTools	Retrieve system status tools.
TopSellersReports	Execute a top sellers report.
TotalsReport	Execute a totals report.