CategorySalesfor1997
| API | Description |
|---|---|
| GET api/CategorySalesfor1997 |
Returns list of all CategorySalesfor1997 Data |
| GET api/CategorySalesfor1997?filterExpression={filterExpression} |
Returns list of all CategorySalesfor1997 Data based on specified criteria |
| GET api/CategorySalesfor1997?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all CategorySalesfor1997 Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/CategorySalesfor1997/{id} |
Returns a CategorySalesfor1997 record based on specified ID |
OrdersQry
| API | Description |
|---|---|
| GET api/OrdersQry |
Returns list of all OrdersQry Data |
| GET api/OrdersQry?filterExpression={filterExpression} |
Returns list of all OrdersQry Data based on specified criteria |
| GET api/OrdersQry?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all OrdersQry Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/OrdersQry/{id} |
Returns a OrdersQry record based on specified ID |
Suppliers
| API | Description |
|---|---|
| GET api/Suppliers |
Returns list of all Suppliers Data |
| GET api/Suppliers?filterExpression={filterExpression} |
Returns list of all Suppliers Data based on specified filter criteria |
| GET api/Suppliers?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Suppliers Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Suppliers/{id} |
Returns a Suppliers record based on specified ID |
| POST api/Suppliers |
Creates a new Suppliers entity |
| PUT api/Suppliers |
Updates an existing Suppliers entity |
| DELETE api/Suppliers/{id} |
Deletes Suppliers record based on specified ID |
| DELETE api/Suppliers?filterExpression={filterExpression} |
Deletes Suppliers data based on the specified filter criteria |
CurrentProductList
| API | Description |
|---|---|
| GET api/CurrentProductList |
Returns list of all CurrentProductList Data |
| GET api/CurrentProductList?filterExpression={filterExpression} |
Returns list of all CurrentProductList Data based on specified criteria |
| GET api/CurrentProductList?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all CurrentProductList Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/CurrentProductList/{id} |
Returns a CurrentProductList record based on specified ID |
SalesbyCategory
| API | Description |
|---|---|
| GET api/SalesbyCategory |
Returns list of all SalesbyCategory Data |
| GET api/SalesbyCategory?filterExpression={filterExpression} |
Returns list of all SalesbyCategory Data based on specified criteria |
| GET api/SalesbyCategory?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all SalesbyCategory Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/SalesbyCategory/{id} |
Returns a SalesbyCategory record based on specified ID |
CustomerCustomerDemo
| API | Description |
|---|---|
| GET api/CustomerCustomerDemo |
Returns list of all CustomerCustomerDemo Data |
| GET api/CustomerCustomerDemo?filterExpression={filterExpression} |
Returns list of all CustomerCustomerDemo Data based on specified filter criteria |
| GET api/CustomerCustomerDemo?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all CustomerCustomerDemo Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/CustomerCustomerDemo/{id} |
Returns a CustomerCustomerDemo record based on specified ID |
| POST api/CustomerCustomerDemo |
Creates a new CustomerCustomerDemo entity |
| PUT api/CustomerCustomerDemo |
Updates an existing CustomerCustomerDemo entity |
| DELETE api/CustomerCustomerDemo/{id} |
Deletes CustomerCustomerDemo record based on specified ID |
| DELETE api/CustomerCustomerDemo?filterExpression={filterExpression} |
Deletes CustomerCustomerDemo data based on the specified filter criteria |
SummaryofSalesbyQuarter
| API | Description |
|---|---|
| GET api/SummaryofSalesbyQuarter |
Returns list of all SummaryofSalesbyQuarter Data |
| GET api/SummaryofSalesbyQuarter?filterExpression={filterExpression} |
Returns list of all SummaryofSalesbyQuarter Data based on specified criteria |
| GET api/SummaryofSalesbyQuarter?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all SummaryofSalesbyQuarter Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/SummaryofSalesbyQuarter/{id} |
Returns a SummaryofSalesbyQuarter record based on specified ID |
Invoices
| API | Description |
|---|---|
| GET api/Invoices |
Returns list of all Invoices Data |
| GET api/Invoices?filterExpression={filterExpression} |
Returns list of all Invoices Data based on specified criteria |
| GET api/Invoices?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Invoices Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Invoices/{id} |
Returns a Invoices record based on specified ID |
OrderDetails
| API | Description |
|---|---|
| GET api/OrderDetails |
Returns list of all OrderDetails Data |
| GET api/OrderDetails?filterExpression={filterExpression} |
Returns list of all OrderDetails Data based on specified filter criteria |
| GET api/OrderDetails?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all OrderDetails Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/OrderDetails/{id} |
Returns a OrderDetails record based on specified ID |
| POST api/OrderDetails |
Creates a new OrderDetails entity |
| PUT api/OrderDetails |
Updates an existing OrderDetails entity |
| DELETE api/OrderDetails/{id} |
Deletes OrderDetails record based on specified ID |
| DELETE api/OrderDetails?filterExpression={filterExpression} |
Deletes OrderDetails data based on the specified filter criteria |
EmployeeTerritories
| API | Description |
|---|---|
| GET api/EmployeeTerritories |
Returns list of all EmployeeTerritories Data |
| GET api/EmployeeTerritories?filterExpression={filterExpression} |
Returns list of all EmployeeTerritories Data based on specified filter criteria |
| GET api/EmployeeTerritories?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all EmployeeTerritories Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/EmployeeTerritories/{id} |
Returns a EmployeeTerritories record based on specified ID |
| POST api/EmployeeTerritories |
Creates a new EmployeeTerritories entity |
| PUT api/EmployeeTerritories |
Updates an existing EmployeeTerritories entity |
| DELETE api/EmployeeTerritories/{id} |
Deletes EmployeeTerritories record based on specified ID |
| DELETE api/EmployeeTerritories?filterExpression={filterExpression} |
Deletes EmployeeTerritories data based on the specified filter criteria |
SalesTotalsbyAmount
| API | Description |
|---|---|
| GET api/SalesTotalsbyAmount |
Returns list of all SalesTotalsbyAmount Data |
| GET api/SalesTotalsbyAmount?filterExpression={filterExpression} |
Returns list of all SalesTotalsbyAmount Data based on specified criteria |
| GET api/SalesTotalsbyAmount?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all SalesTotalsbyAmount Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/SalesTotalsbyAmount/{id} |
Returns a SalesTotalsbyAmount record based on specified ID |
Territories
| API | Description |
|---|---|
| GET api/Territories |
Returns list of all Territories Data |
| GET api/Territories?filterExpression={filterExpression} |
Returns list of all Territories Data based on specified filter criteria |
| GET api/Territories?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Territories Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Territories/{id} |
Returns a Territories record based on specified ID |
| POST api/Territories |
Creates a new Territories entity |
| PUT api/Territories |
Updates an existing Territories entity |
| DELETE api/Territories/{id} |
Deletes Territories record based on specified ID |
| DELETE api/Territories?filterExpression={filterExpression} |
Deletes Territories data based on the specified filter criteria |
ProductsAboveAveragePrice
| API | Description |
|---|---|
| GET api/ProductsAboveAveragePrice |
Returns list of all ProductsAboveAveragePrice Data |
| GET api/ProductsAboveAveragePrice?filterExpression={filterExpression} |
Returns list of all ProductsAboveAveragePrice Data based on specified criteria |
| GET api/ProductsAboveAveragePrice?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all ProductsAboveAveragePrice Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/ProductsAboveAveragePrice/{id} |
Returns a ProductsAboveAveragePrice record based on specified ID |
OrderDetailsExtended
| API | Description |
|---|---|
| GET api/OrderDetailsExtended |
Returns list of all OrderDetailsExtended Data |
| GET api/OrderDetailsExtended?filterExpression={filterExpression} |
Returns list of all OrderDetailsExtended Data based on specified criteria |
| GET api/OrderDetailsExtended?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all OrderDetailsExtended Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/OrderDetailsExtended/{id} |
Returns a OrderDetailsExtended record based on specified ID |
CustomerandSuppliersbyCity
| API | Description |
|---|---|
| GET api/CustomerandSuppliersbyCity |
Returns list of all CustomerandSuppliersbyCity Data |
| GET api/CustomerandSuppliersbyCity?filterExpression={filterExpression} |
Returns list of all CustomerandSuppliersbyCity Data based on specified criteria |
| GET api/CustomerandSuppliersbyCity?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all CustomerandSuppliersbyCity Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/CustomerandSuppliersbyCity/{id} |
Returns a CustomerandSuppliersbyCity record based on specified ID |
Customers
| API | Description |
|---|---|
| GET api/Customers |
Returns list of all Customers Data |
| GET api/Customers?filterExpression={filterExpression} |
Returns list of all Customers Data based on specified filter criteria |
| GET api/Customers?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Customers Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Customers/{id} |
Returns a Customers record based on specified ID |
| POST api/Customers |
Creates a new Customers entity |
| PUT api/Customers |
Updates an existing Customers entity |
| DELETE api/Customers/{id} |
Deletes Customers record based on specified ID |
| DELETE api/Customers?filterExpression={filterExpression} |
Deletes Customers data based on the specified filter criteria |
Shippers
| API | Description |
|---|---|
| GET api/Shippers |
Returns list of all Shippers Data |
| GET api/Shippers?filterExpression={filterExpression} |
Returns list of all Shippers Data based on specified filter criteria |
| GET api/Shippers?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Shippers Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Shippers/{id} |
Returns a Shippers record based on specified ID |
| POST api/Shippers |
Creates a new Shippers entity |
| PUT api/Shippers |
Updates an existing Shippers entity |
| DELETE api/Shippers/{id} |
Deletes Shippers record based on specified ID |
| DELETE api/Shippers?filterExpression={filterExpression} |
Deletes Shippers data based on the specified filter criteria |
Categories
| API | Description |
|---|---|
| GET api/Categories |
Returns list of all Categories Data |
| GET api/Categories?filterExpression={filterExpression} |
Returns list of all Categories Data based on specified filter criteria |
| GET api/Categories?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Categories Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Categories/{id} |
Returns a Categories record based on specified ID |
| POST api/Categories |
Creates a new Categories entity |
| PUT api/Categories |
Updates an existing Categories entity |
| DELETE api/Categories/{id} |
Deletes Categories record based on specified ID |
| DELETE api/Categories?filterExpression={filterExpression} |
Deletes Categories data based on the specified filter criteria |
Employees
| API | Description |
|---|---|
| GET api/Employees |
Returns list of all Employees Data |
| GET api/Employees?filterExpression={filterExpression} |
Returns list of all Employees Data based on specified filter criteria |
| GET api/Employees?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Employees Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Employees/{id} |
Returns a Employees record based on specified ID |
| POST api/Employees |
Creates a new Employees entity |
| PUT api/Employees |
Updates an existing Employees entity |
| DELETE api/Employees/{id} |
Deletes Employees record based on specified ID |
| DELETE api/Employees?filterExpression={filterExpression} |
Deletes Employees data based on the specified filter criteria |
ProductsbyCategory
| API | Description |
|---|---|
| GET api/ProductsbyCategory |
Returns list of all ProductsbyCategory Data |
| GET api/ProductsbyCategory?filterExpression={filterExpression} |
Returns list of all ProductsbyCategory Data based on specified criteria |
| GET api/ProductsbyCategory?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all ProductsbyCategory Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/ProductsbyCategory/{id} |
Returns a ProductsbyCategory record based on specified ID |
Alphabeticallistofproducts
| API | Description |
|---|---|
| GET api/Alphabeticallistofproducts |
Returns list of all Alphabeticallistofproducts Data |
| GET api/Alphabeticallistofproducts?filterExpression={filterExpression} |
Returns list of all Alphabeticallistofproducts Data based on specified criteria |
| GET api/Alphabeticallistofproducts?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Alphabeticallistofproducts Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Alphabeticallistofproducts/{id} |
Returns a Alphabeticallistofproducts record based on specified ID |
CustomerDemographics
| API | Description |
|---|---|
| GET api/CustomerDemographics |
Returns list of all CustomerDemographics Data |
| GET api/CustomerDemographics?filterExpression={filterExpression} |
Returns list of all CustomerDemographics Data based on specified filter criteria |
| GET api/CustomerDemographics?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all CustomerDemographics Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/CustomerDemographics/{id} |
Returns a CustomerDemographics record based on specified ID |
| POST api/CustomerDemographics |
Creates a new CustomerDemographics entity |
| PUT api/CustomerDemographics |
Updates an existing CustomerDemographics entity |
| DELETE api/CustomerDemographics/{id} |
Deletes CustomerDemographics record based on specified ID |
| DELETE api/CustomerDemographics?filterExpression={filterExpression} |
Deletes CustomerDemographics data based on the specified filter criteria |
Orders
| API | Description |
|---|---|
| GET api/Orders |
Returns list of all Orders Data |
| GET api/Orders?filterExpression={filterExpression} |
Returns list of all Orders Data based on specified filter criteria |
| GET api/Orders?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Orders Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Orders/{id} |
Returns a Orders record based on specified ID |
| POST api/Orders |
Creates a new Orders entity |
| PUT api/Orders |
Updates an existing Orders entity |
| DELETE api/Orders/{id} |
Deletes Orders record based on specified ID |
| DELETE api/Orders?filterExpression={filterExpression} |
Deletes Orders data based on the specified filter criteria |
QuarterlyOrders
| API | Description |
|---|---|
| GET api/QuarterlyOrders |
Returns list of all QuarterlyOrders Data |
| GET api/QuarterlyOrders?filterExpression={filterExpression} |
Returns list of all QuarterlyOrders Data based on specified criteria |
| GET api/QuarterlyOrders?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all QuarterlyOrders Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/QuarterlyOrders/{id} |
Returns a QuarterlyOrders record based on specified ID |
ProductSalesfor1997
| API | Description |
|---|---|
| GET api/ProductSalesfor1997 |
Returns list of all ProductSalesfor1997 Data |
| GET api/ProductSalesfor1997?filterExpression={filterExpression} |
Returns list of all ProductSalesfor1997 Data based on specified criteria |
| GET api/ProductSalesfor1997?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all ProductSalesfor1997 Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/ProductSalesfor1997/{id} |
Returns a ProductSalesfor1997 record based on specified ID |
SummaryofSalesbyYear
| API | Description |
|---|---|
| GET api/SummaryofSalesbyYear |
Returns list of all SummaryofSalesbyYear Data |
| GET api/SummaryofSalesbyYear?filterExpression={filterExpression} |
Returns list of all SummaryofSalesbyYear Data based on specified criteria |
| GET api/SummaryofSalesbyYear?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all SummaryofSalesbyYear Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/SummaryofSalesbyYear/{id} |
Returns a SummaryofSalesbyYear record based on specified ID |
Region
| API | Description |
|---|---|
| GET api/Region |
Returns list of all Region Data |
| GET api/Region?filterExpression={filterExpression} |
Returns list of all Region Data based on specified filter criteria |
| GET api/Region?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Region Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Region/{id} |
Returns a Region record based on specified ID |
| POST api/Region |
No documentation available. |
| PUT api/Region |
No documentation available. |
| DELETE api/Region/{id} |
Deletes Region record based on specified ID |
| DELETE api/Region?filterExpression={filterExpression} |
Deletes Region data based on the specified filter criteria |
Products
| API | Description |
|---|---|
| GET api/Products |
Returns list of all Products Data |
| GET api/Products?filterExpression={filterExpression} |
Returns list of all Products Data based on specified filter criteria |
| GET api/Products?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all Products Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/Products/{id} |
Returns a Products record based on specified ID |
| POST api/Products |
Creates a new Products entity |
| PUT api/Products |
Updates an existing Products entity |
| DELETE api/Products/{id} |
Deletes Products record based on specified ID |
| DELETE api/Products?filterExpression={filterExpression} |
Deletes Products data based on the specified filter criteria |
OrderSubtotals
| API | Description |
|---|---|
| GET api/OrderSubtotals |
Returns list of all OrderSubtotals Data |
| GET api/OrderSubtotals?filterExpression={filterExpression} |
Returns list of all OrderSubtotals Data based on specified criteria |
| GET api/OrderSubtotals?filterExpression={filterExpression}&sortExpression={sortExpression}&pageIndex={pageIndex}&pageSize={pageSize} |
Returns list of all OrderSubtotals Data by Page based on specified filter criteria, sort expression, page number and page size |
| GET api/OrderSubtotals/{id} |
Returns a OrderSubtotals record based on specified ID |