GET api/Invoices?filterExpression={filterExpression}

Returns list of all Invoices 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 InvoicesData

Name	Type	Additional information
ShipName	string	None.
ShipAddress	string	None.
ShipCity	string	None.
ShipRegion	string	None.
ShipPostalCode	string	None.
ShipCountry	string	None.
CustomerID	string	None.
CustomerName	string	None.
Address	string	None.
City	string	None.
Region	string	None.
PostalCode	string	None.
Country	string	None.
Salesperson	string	None.
OrderID	integer	None.
OrderDate	date	None.
RequiredDate	date	None.
ShippedDate	date	None.
ShipperName	string	None.
ProductID	integer	None.
ProductName	string	None.
UnitPrice	decimal number	None.
Quantity	integer	None.
Discount	decimal number	None.
ExtendedPrice	decimal number	None.
Freight	decimal number	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "ShipName": "sample string 1",
    "ShipAddress": "sample string 2",
    "ShipCity": "sample string 3",
    "ShipRegion": "sample string 4",
    "ShipPostalCode": "sample string 5",
    "ShipCountry": "sample string 6",
    "CustomerID": "sample string 7",
    "CustomerName": "sample string 8",
    "Address": "sample string 9",
    "City": "sample string 10",
    "Region": "sample string 11",
    "PostalCode": "sample string 12",
    "Country": "sample string 13",
    "Salesperson": "sample string 14",
    "OrderID": 15,
    "OrderDate": "2025-07-04T14:07:03.8672943-07:00",
    "RequiredDate": "2025-07-04T14:07:03.8682663-07:00",
    "ShippedDate": "2025-07-04T14:07:03.8682663-07:00",
    "ShipperName": "sample string 16",
    "ProductID": 17,
    "ProductName": "sample string 18",
    "UnitPrice": 19.0,
    "Quantity": 20,
    "Discount": 21.1,
    "ExtendedPrice": 22.0,
    "Freight": 23.0
  },
  {
    "ShipName": "sample string 1",
    "ShipAddress": "sample string 2",
    "ShipCity": "sample string 3",
    "ShipRegion": "sample string 4",
    "ShipPostalCode": "sample string 5",
    "ShipCountry": "sample string 6",
    "CustomerID": "sample string 7",
    "CustomerName": "sample string 8",
    "Address": "sample string 9",
    "City": "sample string 10",
    "Region": "sample string 11",
    "PostalCode": "sample string 12",
    "Country": "sample string 13",
    "Salesperson": "sample string 14",
    "OrderID": 15,
    "OrderDate": "2025-07-04T14:07:03.8672943-07:00",
    "RequiredDate": "2025-07-04T14:07:03.8682663-07:00",
    "ShippedDate": "2025-07-04T14:07:03.8682663-07:00",
    "ShipperName": "sample string 16",
    "ProductID": 17,
    "ProductName": "sample string 18",
    "UnitPrice": 19.0,
    "Quantity": 20,
    "Discount": 21.1,
    "ExtendedPrice": 22.0,
    "Freight": 23.0
  }
]

text/xml

Sample:

<ArrayOfInvoicesData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/NorthwindAPI.Models">
  <InvoicesData>
    <Address>sample string 9</Address>
    <City>sample string 10</City>
    <Country>sample string 13</Country>
    <CustomerID>sample string 7</CustomerID>
    <CustomerName>sample string 8</CustomerName>
    <Discount>21.1</Discount>
    <ExtendedPrice>22</ExtendedPrice>
    <Freight>23</Freight>
    <OrderDate>2025-07-04T14:07:03.8672943-07:00</OrderDate>
    <OrderID>15</OrderID>
    <PostalCode>sample string 12</PostalCode>
    <ProductID>17</ProductID>
    <ProductName>sample string 18</ProductName>
    <Quantity>20</Quantity>
    <Region>sample string 11</Region>
    <RequiredDate>2025-07-04T14:07:03.8682663-07:00</RequiredDate>
    <Salesperson>sample string 14</Salesperson>
    <ShipAddress>sample string 2</ShipAddress>
    <ShipCity>sample string 3</ShipCity>
    <ShipCountry>sample string 6</ShipCountry>
    <ShipName>sample string 1</ShipName>
    <ShipPostalCode>sample string 5</ShipPostalCode>
    <ShipRegion>sample string 4</ShipRegion>
    <ShippedDate>2025-07-04T14:07:03.8682663-07:00</ShippedDate>
    <ShipperName>sample string 16</ShipperName>
    <UnitPrice>19</UnitPrice>
  </InvoicesData>
  <InvoicesData>
    <Address>sample string 9</Address>
    <City>sample string 10</City>
    <Country>sample string 13</Country>
    <CustomerID>sample string 7</CustomerID>
    <CustomerName>sample string 8</CustomerName>
    <Discount>21.1</Discount>
    <ExtendedPrice>22</ExtendedPrice>
    <Freight>23</Freight>
    <OrderDate>2025-07-04T14:07:03.8672943-07:00</OrderDate>
    <OrderID>15</OrderID>
    <PostalCode>sample string 12</PostalCode>
    <ProductID>17</ProductID>
    <ProductName>sample string 18</ProductName>
    <Quantity>20</Quantity>
    <Region>sample string 11</Region>
    <RequiredDate>2025-07-04T14:07:03.8682663-07:00</RequiredDate>
    <Salesperson>sample string 14</Salesperson>
    <ShipAddress>sample string 2</ShipAddress>
    <ShipCity>sample string 3</ShipCity>
    <ShipCountry>sample string 6</ShipCountry>
    <ShipName>sample string 1</ShipName>
    <ShipPostalCode>sample string 5</ShipPostalCode>
    <ShipRegion>sample string 4</ShipRegion>
    <ShippedDate>2025-07-04T14:07:03.8682663-07:00</ShippedDate>
    <ShipperName>sample string 16</ShipperName>
    <UnitPrice>19</UnitPrice>
  </InvoicesData>
</ArrayOfInvoicesData>