GET api/Orders?filterExpression={filterExpression}

Returns list of all Orders 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 OrdersData

Name	Type	Additional information
OrderID	integer	None.
CustomerID	string	None.
EmployeeID	integer	None.
OrderDate	date	None.
RequiredDate	date	None.
ShippedDate	date	None.
ShipVia	integer	None.
Freight	decimal number	None.
ShipName	string	None.
ShipAddress	string	None.
ShipCity	string	None.
ShipRegion	string	None.
ShipPostalCode	string	None.
ShipCountry	string	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "OrderID": 1,
    "CustomerID": "sample string 2",
    "EmployeeID": 3,
    "OrderDate": "2025-10-26T03:08:19.9659219-07:00",
    "RequiredDate": "2025-10-26T03:08:19.9659219-07:00",
    "ShippedDate": "2025-10-26T03:08:19.9659219-07:00",
    "ShipVia": 4,
    "Freight": 5.0,
    "ShipName": "sample string 6",
    "ShipAddress": "sample string 7",
    "ShipCity": "sample string 8",
    "ShipRegion": "sample string 9",
    "ShipPostalCode": "sample string 10",
    "ShipCountry": "sample string 11"
  },
  {
    "OrderID": 1,
    "CustomerID": "sample string 2",
    "EmployeeID": 3,
    "OrderDate": "2025-10-26T03:08:19.9659219-07:00",
    "RequiredDate": "2025-10-26T03:08:19.9659219-07:00",
    "ShippedDate": "2025-10-26T03:08:19.9659219-07:00",
    "ShipVia": 4,
    "Freight": 5.0,
    "ShipName": "sample string 6",
    "ShipAddress": "sample string 7",
    "ShipCity": "sample string 8",
    "ShipRegion": "sample string 9",
    "ShipPostalCode": "sample string 10",
    "ShipCountry": "sample string 11"
  }
]

text/xml

Sample:

<ArrayOfOrdersData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/NorthwindAPI.Models">
  <OrdersData>
    <CustomerID>sample string 2</CustomerID>
    <EmployeeID>3</EmployeeID>
    <Freight>5</Freight>
    <OrderDate>2025-10-26T03:08:19.9659219-07:00</OrderDate>
    <OrderID>1</OrderID>
    <RequiredDate>2025-10-26T03:08:19.9659219-07:00</RequiredDate>
    <ShipAddress>sample string 7</ShipAddress>
    <ShipCity>sample string 8</ShipCity>
    <ShipCountry>sample string 11</ShipCountry>
    <ShipName>sample string 6</ShipName>
    <ShipPostalCode>sample string 10</ShipPostalCode>
    <ShipRegion>sample string 9</ShipRegion>
    <ShipVia>4</ShipVia>
    <ShippedDate>2025-10-26T03:08:19.9659219-07:00</ShippedDate>
  </OrdersData>
  <OrdersData>
    <CustomerID>sample string 2</CustomerID>
    <EmployeeID>3</EmployeeID>
    <Freight>5</Freight>
    <OrderDate>2025-10-26T03:08:19.9659219-07:00</OrderDate>
    <OrderID>1</OrderID>
    <RequiredDate>2025-10-26T03:08:19.9659219-07:00</RequiredDate>
    <ShipAddress>sample string 7</ShipAddress>
    <ShipCity>sample string 8</ShipCity>
    <ShipCountry>sample string 11</ShipCountry>
    <ShipName>sample string 6</ShipName>
    <ShipPostalCode>sample string 10</ShipPostalCode>
    <ShipRegion>sample string 9</ShipRegion>
    <ShipVia>4</ShipVia>
    <ShippedDate>2025-10-26T03:08:19.9659219-07:00</ShippedDate>
  </OrdersData>
</ArrayOfOrdersData>