GET api/OrdersQry?filterExpression={filterExpression}

Returns list of all OrdersQry Data based on specified 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 OrdersQryData

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.
CompanyName	string	None.
Address	string	None.
City	string	None.
Region	string	None.
PostalCode	string	None.
Country	string	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "OrderID": 1,
    "CustomerID": "sample string 2",
    "EmployeeID": 3,
    "OrderDate": "2025-07-04T12:51:57.3129158-07:00",
    "RequiredDate": "2025-07-04T12:51:57.313909-07:00",
    "ShippedDate": "2025-07-04T12:51:57.313909-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",
    "CompanyName": "sample string 12",
    "Address": "sample string 13",
    "City": "sample string 14",
    "Region": "sample string 15",
    "PostalCode": "sample string 16",
    "Country": "sample string 17"
  },
  {
    "OrderID": 1,
    "CustomerID": "sample string 2",
    "EmployeeID": 3,
    "OrderDate": "2025-07-04T12:51:57.3129158-07:00",
    "RequiredDate": "2025-07-04T12:51:57.313909-07:00",
    "ShippedDate": "2025-07-04T12:51:57.313909-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",
    "CompanyName": "sample string 12",
    "Address": "sample string 13",
    "City": "sample string 14",
    "Region": "sample string 15",
    "PostalCode": "sample string 16",
    "Country": "sample string 17"
  }
]

text/xml

Sample:

<ArrayOfOrdersQryData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/NorthwindAPI.Models">
  <OrdersQryData>
    <Address>sample string 13</Address>
    <City>sample string 14</City>
    <CompanyName>sample string 12</CompanyName>
    <Country>sample string 17</Country>
    <CustomerID>sample string 2</CustomerID>
    <EmployeeID>3</EmployeeID>
    <Freight>5</Freight>
    <OrderDate>2025-07-04T12:51:57.3129158-07:00</OrderDate>
    <OrderID>1</OrderID>
    <PostalCode>sample string 16</PostalCode>
    <Region>sample string 15</Region>
    <RequiredDate>2025-07-04T12:51:57.313909-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-07-04T12:51:57.313909-07:00</ShippedDate>
  </OrdersQryData>
  <OrdersQryData>
    <Address>sample string 13</Address>
    <City>sample string 14</City>
    <CompanyName>sample string 12</CompanyName>
    <Country>sample string 17</Country>
    <CustomerID>sample string 2</CustomerID>
    <EmployeeID>3</EmployeeID>
    <Freight>5</Freight>
    <OrderDate>2025-07-04T12:51:57.3129158-07:00</OrderDate>
    <OrderID>1</OrderID>
    <PostalCode>sample string 16</PostalCode>
    <Region>sample string 15</Region>
    <RequiredDate>2025-07-04T12:51:57.313909-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-07-04T12:51:57.313909-07:00</ShippedDate>
  </OrdersQryData>
</ArrayOfOrdersQryData>