Northwind (OData V2) sample service

The same Northwind model as an OData V2 service: associations, association sets and function imports.

OData version: 2.0
Service root: https://services.odata.org/V2/Northwind/Northwind.svc/
$metadata: https://services.odata.org/V2/Northwind/Northwind.svc/$metadata
Entity sets: 26, entity types: 26, complex types: 0, enum types: 0

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.

Open in the viewer