REST Data Model
The CData Power BI Connector for Shopify models the Shopify API as relational tables, views, and stored procedures.
To use the REST Data Model, simply set Schema to REST.
Note: As of October 1, 2024, Shopify has designated the REST API as legacy.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Shopify account.
Common tables include:
| Table | Description |
| Shop | Contains general settings and information about the shop. |
| Customers | Create, update, delete, and query customers. |
| CustomerAddresses | Create, update, delete, and query customer addresses. |
| Orders | Create, update, delete, and query orders. |
| OrdersItems | Query order items. |
| OrderTransactions | Create, update, delete, and query transactions. |
| Refunds | Create, update, delete, and query refunds. |
| RefundsItems | Get data on OrdersItems that have been refunded. |
| Redirects | Create, update, delete, and query redirects. |
| Collects | Query, insert, or delete information regarding different collects. |
| DiscountCodes | Create, select, update, and delete information regarding discount codes. |
| PriceRules | Create, update, delete, and query price rules. |
| DraftOrders | Create, update, delete, and query draft orders. |
| DraftOrderItems | Query draft order items. |
| Fulfillments | Create, update, and query fulfillments. |
| FulfillmentOrders | Query fulfillment orders. |
| FulfillmentEvents | Create, delete, and query information regarding fulfillment events. |
| Locations | Retrieve information regarding store locations. |
| TaxItems | Query order taxes. |
| Users | Query Users. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including managing order cancellations and fulfillments, sending invoices, and handling authentication flows.