GET api/Products?filterExpression={filterExpression}

Returns list of all Products Data based on specified filter criteria

Request Information

URI Parameters

Name	Description	Type	Additional information
filterExpression	Filter expression/criteria	string	Required

Body Parameters

None.

Response Information

Resource Description

Collection of ProductsData

Name	Type	Additional information
ProductID	integer	None.
ProductName	string	None.
SupplierID	integer	None.
CategoryID	integer	None.
QuantityPerUnit	string	None.
UnitPrice	decimal number	None.
UnitsInStock	integer	None.
UnitsOnOrder	integer	None.
ReorderLevel	integer	None.
Discontinued	boolean	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "ProductID": 1,
    "ProductName": "sample string 2",
    "SupplierID": 3,
    "CategoryID": 4,
    "QuantityPerUnit": "sample string 5",
    "UnitPrice": 6.0,
    "UnitsInStock": 7,
    "UnitsOnOrder": 8,
    "ReorderLevel": 9,
    "Discontinued": true
  },
  {
    "ProductID": 1,
    "ProductName": "sample string 2",
    "SupplierID": 3,
    "CategoryID": 4,
    "QuantityPerUnit": "sample string 5",
    "UnitPrice": 6.0,
    "UnitsInStock": 7,
    "UnitsOnOrder": 8,
    "ReorderLevel": 9,
    "Discontinued": true
  }
]

text/xml

Sample:

<ArrayOfProductsData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/NorthwindAPI.Models">
  <ProductsData>
    <CategoryID>4</CategoryID>
    <Discontinued>true</Discontinued>
    <ProductID>1</ProductID>
    <ProductName>sample string 2</ProductName>
    <QuantityPerUnit>sample string 5</QuantityPerUnit>
    <ReorderLevel>9</ReorderLevel>
    <SupplierID>3</SupplierID>
    <UnitPrice>6</UnitPrice>
    <UnitsInStock>7</UnitsInStock>
    <UnitsOnOrder>8</UnitsOnOrder>
  </ProductsData>
  <ProductsData>
    <CategoryID>4</CategoryID>
    <Discontinued>true</Discontinued>
    <ProductID>1</ProductID>
    <ProductName>sample string 2</ProductName>
    <QuantityPerUnit>sample string 5</QuantityPerUnit>
    <ReorderLevel>9</ReorderLevel>
    <SupplierID>3</SupplierID>
    <UnitPrice>6</UnitPrice>
    <UnitsInStock>7</UnitsInStock>
    <UnitsOnOrder>8</UnitsOnOrder>
  </ProductsData>
</ArrayOfProductsData>