Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
WooCommerce Adapter Views
| Name | Description |
| Continents | Retrieve continents. |
| Countries | Retrieve countries. |
| Currencies | Retrieve available currencies. |
| 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. |
| SalesReport | Executes a Sales report. |
| SettingGroups | Retrieve settings groups. |
| ShippingLocations | Retrieve shipping zone locations. |
| ShippingMethods | Retrieve shipping methods. |
| States | Retrieve shipping states. |
| SystemStatus | Retrieve 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. |