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.
Shopify Adapter Views
| 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. |
| 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. |
| ProductOptions | Query product options. |
| 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. |