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.
DepartmentID	integer	None.
Title	string	None.
Description	string	None.
SKU	string	None.
UnitPrice	decimal number	None.
DiscountPercentage	integer	None.
UnitsInStock	integer	None.
SmallImageUrl	string	None.
FullImageUrl	string	None.
Votes	integer	None.
TotalRating	integer	None.
AddedDate	date	None.
AddedBy	string	None.
Active	boolean	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "ProductID": 1,
    "DepartmentID": 2,
    "Title": "sample string 3",
    "Description": "sample string 4",
    "SKU": "sample string 5",
    "UnitPrice": 6.0,
    "DiscountPercentage": 7,
    "UnitsInStock": 8,
    "SmallImageUrl": "sample string 9",
    "FullImageUrl": "sample string 10",
    "Votes": 11,
    "TotalRating": 12,
    "AddedDate": "2026-01-18T14:44:30.9548356-08:00",
    "AddedBy": "sample string 13",
    "Active": true
  },
  {
    "ProductID": 1,
    "DepartmentID": 2,
    "Title": "sample string 3",
    "Description": "sample string 4",
    "SKU": "sample string 5",
    "UnitPrice": 6.0,
    "DiscountPercentage": 7,
    "UnitsInStock": 8,
    "SmallImageUrl": "sample string 9",
    "FullImageUrl": "sample string 10",
    "Votes": 11,
    "TotalRating": 12,
    "AddedDate": "2026-01-18T14:44:30.9548356-08:00",
    "AddedBy": "sample string 13",
    "Active": true
  }
]

text/xml

Sample:

<ArrayOfProductsData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/CodeBhagat.DAL">
  <ProductsData>
    <Active>true</Active>
    <AddedBy>sample string 13</AddedBy>
    <AddedDate>2026-01-18T14:44:30.9548356-08:00</AddedDate>
    <DepartmentID>2</DepartmentID>
    <Description>sample string 4</Description>
    <DiscountPercentage>7</DiscountPercentage>
    <FullImageUrl>sample string 10</FullImageUrl>
    <ProductID>1</ProductID>
    <SKU>sample string 5</SKU>
    <SmallImageUrl>sample string 9</SmallImageUrl>
    <Title>sample string 3</Title>
    <TotalRating>12</TotalRating>
    <UnitPrice>6</UnitPrice>
    <UnitsInStock>8</UnitsInStock>
    <Votes>11</Votes>
  </ProductsData>
  <ProductsData>
    <Active>true</Active>
    <AddedBy>sample string 13</AddedBy>
    <AddedDate>2026-01-18T14:44:30.9548356-08:00</AddedDate>
    <DepartmentID>2</DepartmentID>
    <Description>sample string 4</Description>
    <DiscountPercentage>7</DiscountPercentage>
    <FullImageUrl>sample string 10</FullImageUrl>
    <ProductID>1</ProductID>
    <SKU>sample string 5</SKU>
    <SmallImageUrl>sample string 9</SmallImageUrl>
    <Title>sample string 3</Title>
    <TotalRating>12</TotalRating>
    <UnitPrice>6</UnitPrice>
    <UnitsInStock>8</UnitsInStock>
    <Votes>11</Votes>
  </ProductsData>
</ArrayOfProductsData>