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.
CData JDBC Driver for Shopify Views
| Name | Description |
| Customers | List of customers. |
| DraftOrders | List of saved draft orders. |
| FulfillmentEvents | Retrieves the history of events associated with one or many fulfillments. |
| FulfillmentOrders | FulfillmentOrders represents a group of one or more items in an order that are to be fulfilled from the same location. |
| Fulfillments | Fulfillment represents a shipment of one or more items in an order. |
| FulfillmentServices | Lists fulfillmentServices which Represents service that prepares and ships orders on behalf of the store owner. |
| Metafields | Retrieves a list of metafields that belong to one or many resource IDs. |
| OrderRisks | The order risks associated with this order. |
| Orders | Tax rates with their effective dates of application |
| OrderTransactions | List of all transactions associated with the orders. |
| ProductImages | The images associated with the product. |
| ProductOptions | A list of product options. The limit is specified by Shop.resourceLimits.maxProductOptions. |
| Products | List of products. |
| ProductVariants | List of the product variants. |
| Refunds | Represents a refund of items or transactions in an order. |