Online OData Viewer
Open the viewer
Northwind (OData V4) sample service
The classic Northwind trading database: customers, orders, products and suppliers as an OData V4 service.
- OData version: 4.0
- Service root:
https://services.odata.org/V4/Northwind/Northwind.svc/ $metadata:https://services.odata.org/V4/Northwind/Northwind.svc/$metadata- Entity sets: 26, entity types: 26, complex types: 0, enum types: 0
Open the ER diagram · Browse the tree
Entity sets
| Entity set | Entity type | Key | Properties | Navigations |
|---|---|---|---|---|
| Categories | Category | CategoryID | 4 | Products |
| CustomerDemographics | CustomerDemographic | CustomerTypeID | 2 | Customers |
| Customers | Customer | CustomerID | 11 | Orders, CustomerDemographics |
| Employees | Employee | EmployeeID | 18 | Employees1, Employee1, Orders, Territories |
| Order_Details | Order_Detail | OrderID, ProductID | 5 | Order, Product |
| Orders | Order | OrderID | 14 | Customer, Employee, Order_Details, Shipper |
| Products | Product | ProductID | 10 | Category, Order_Details, Supplier |
| Regions | Region | RegionID | 2 | Territories |
| Shippers | Shipper | ShipperID | 3 | Orders |
| Suppliers | Supplier | SupplierID | 12 | Products |
| Territories | Territory | TerritoryID | 3 | Region, Employees |
| Alphabetical_list_of_products | Alphabetical_list_of_product | CategoryName, Discontinued, ProductID, ProductName | 11 | — |
| Category_Sales_for_1997 | Category_Sales_for_1997 | CategoryName | 2 | — |
| Current_Product_Lists | Current_Product_List | ProductID, ProductName | 2 | — |
| Customer_and_Suppliers_by_Cities | Customer_and_Suppliers_by_City | CompanyName, Relationship | 4 | — |
| Invoices | Invoice | CustomerName, Discount, OrderID, ProductID, ProductName, Quantity, Salesperson, ShipperName, UnitPrice | 26 | — |
| Order_Details_Extendeds | Order_Details_Extended | Discount, OrderID, ProductID, ProductName, Quantity, UnitPrice | 7 | — |
| Order_Subtotals | Order_Subtotal | OrderID | 2 | — |
| Orders_Qries | Orders_Qry | CompanyName, OrderID | 20 | — |
| Product_Sales_for_1997 | Product_Sales_for_1997 | CategoryName, ProductName | 3 | — |
| Products_Above_Average_Prices | Products_Above_Average_Price | ProductName | 2 | — |
| Products_by_Categories | Products_by_Category | CategoryName, Discontinued, ProductName | 5 | — |
| Sales_by_Categories | Sales_by_Category | CategoryID, CategoryName, ProductName | 4 | — |
| Sales_Totals_by_Amounts | Sales_Totals_by_Amount | CompanyName, OrderID | 4 | — |
| Summary_of_Sales_by_Quarters | Summary_of_Sales_by_Quarter | OrderID | 3 | — |
| Summary_of_Sales_by_Years | Summary_of_Sales_by_Year | OrderID | 3 | — |
Example queries
- First five Categories —
Categories?$top=5 - Categories by CategoryID, descending —
Categories?$orderby=CategoryID desc&$top=5 - First five CustomerDemographics —
CustomerDemographics?$top=5 - CustomerDemographics by CustomerTypeID, descending —
CustomerDemographics?$orderby=CustomerTypeID desc&$top=5 - First five Customers —
Customers?$top=5 - Customers by CustomerID, descending —
Customers?$orderby=CustomerID desc&$top=5
More examples: OData query options cheat sheet.