GET api/InventorySearch/AggregatedMultiLoc

ODATA enabled GET aggregated InventorySearch requests - returns inventory totals for multiple locations. This is meant to work in conjunction with inventory search filter scripts that use specific locations.

Request Information

Parameters

NameDescriptionAdditional information
options 
No documentation available.

None.

Response Information

Response body formats

application/json, text/json

Sample: 
{
  "Items": [
    {
      "Item_Number": "sample string 1",
      "Description": "sample string 2",
      "Short_Descr": "sample string 3",
      "Generic_Descr": "sample string 4",
      "NonInv": true,
      "Item_Class": "sample string 5",
      "Item_Type": "sample string 6",
      "UOfM_Sched": "sample string 7",
      "Selling_UOfM": "sample string 8",
      "Purchasing_UOfM": "sample string 9",
      "Avail": 1.0,
      "Onhand": 1.0,
      "Allocated": 1.0,
      "Backordered": 1.0,
      "Onorder": 1.0,
      "List_Price": 1.0,
      "Item_Shipping_Weight": 1.0,
      "Last_Sold_On": "2025-11-04T14:05:59.778-05:00",
      "Sold_Most_By": "sample string 10",
      "User_1": "sample string 11",
      "User_2": "sample string 12",
      "User_3": "sample string 13",
      "User_4": "sample string 14",
      "User_5": "sample string 15",
      "User_6": "sample string 16",
      "Current_Cost": 17.0,
      "Standard_Cost": 18.0,
      "Item_Curr_Dec": 1,
      "Item_Qty_Dec": 1,
      "IsAvail": true,
      "Location": "sample string 19",
      "USCATVLS_1": "sample string 20",
      "USCATVLS_2": "sample string 21",
      "USCATVLS_3": "sample string 22",
      "USCATVLS_4": "sample string 23",
      "USCATVLS_5": "sample string 24",
      "USCATVLS_6": "sample string 25",
      "Base_Uofm": "sample string 26",
      "Replaced_By": "sample string 27",
      "Item_Blocked": true,
      "Selling_Multiple": 29.0,
      "Inactive": 64,
      "Purchase_Item_Tax_Schedu": "sample string 30",
      "Purchase_Tax_Options": 31,
      "Sales_Tax_Option": 32,
      "Item_Tax_Schedule_ID": "sample string 33",
      "In_Stock": "Yes",
      "UserFieldData": [
        {},
        {},
        {}
      ],
      "UserFieldNames": [
        "sample string 1",
        "sample string 2",
        "sample string 3"
      ],
      "Notifications": null
    },
    {
      "Item_Number": "sample string 1",
      "Description": "sample string 2",
      "Short_Descr": "sample string 3",
      "Generic_Descr": "sample string 4",
      "NonInv": true,
      "Item_Class": "sample string 5",
      "Item_Type": "sample string 6",
      "UOfM_Sched": "sample string 7",
      "Selling_UOfM": "sample string 8",
      "Purchasing_UOfM": "sample string 9",
      "Avail": 1.0,
      "Onhand": 1.0,
      "Allocated": 1.0,
      "Backordered": 1.0,
      "Onorder": 1.0,
      "List_Price": 1.0,
      "Item_Shipping_Weight": 1.0,
      "Last_Sold_On": "2025-11-04T14:05:59.778-05:00",
      "Sold_Most_By": "sample string 10",
      "User_1": "sample string 11",
      "User_2": "sample string 12",
      "User_3": "sample string 13",
      "User_4": "sample string 14",
      "User_5": "sample string 15",
      "User_6": "sample string 16",
      "Current_Cost": 17.0,
      "Standard_Cost": 18.0,
      "Item_Curr_Dec": 1,
      "Item_Qty_Dec": 1,
      "IsAvail": true,
      "Location": "sample string 19",
      "USCATVLS_1": "sample string 20",
      "USCATVLS_2": "sample string 21",
      "USCATVLS_3": "sample string 22",
      "USCATVLS_4": "sample string 23",
      "USCATVLS_5": "sample string 24",
      "USCATVLS_6": "sample string 25",
      "Base_Uofm": "sample string 26",
      "Replaced_By": "sample string 27",
      "Item_Blocked": true,
      "Selling_Multiple": 29.0,
      "Inactive": 64,
      "Purchase_Item_Tax_Schedu": "sample string 30",
      "Purchase_Tax_Options": 31,
      "Sales_Tax_Option": 32,
      "Item_Tax_Schedule_ID": "sample string 33",
      "In_Stock": "Yes",
      "UserFieldData": [
        {},
        {},
        {}
      ],
      "UserFieldNames": [
        "sample string 1",
        "sample string 2",
        "sample string 3"
      ],
      "Notifications": null
    },
    {
      "Item_Number": "sample string 1",
      "Description": "sample string 2",
      "Short_Descr": "sample string 3",
      "Generic_Descr": "sample string 4",
      "NonInv": true,
      "Item_Class": "sample string 5",
      "Item_Type": "sample string 6",
      "UOfM_Sched": "sample string 7",
      "Selling_UOfM": "sample string 8",
      "Purchasing_UOfM": "sample string 9",
      "Avail": 1.0,
      "Onhand": 1.0,
      "Allocated": 1.0,
      "Backordered": 1.0,
      "Onorder": 1.0,
      "List_Price": 1.0,
      "Item_Shipping_Weight": 1.0,
      "Last_Sold_On": "2025-11-04T14:05:59.778-05:00",
      "Sold_Most_By": "sample string 10",
      "User_1": "sample string 11",
      "User_2": "sample string 12",
      "User_3": "sample string 13",
      "User_4": "sample string 14",
      "User_5": "sample string 15",
      "User_6": "sample string 16",
      "Current_Cost": 17.0,
      "Standard_Cost": 18.0,
      "Item_Curr_Dec": 1,
      "Item_Qty_Dec": 1,
      "IsAvail": true,
      "Location": "sample string 19",
      "USCATVLS_1": "sample string 20",
      "USCATVLS_2": "sample string 21",
      "USCATVLS_3": "sample string 22",
      "USCATVLS_4": "sample string 23",
      "USCATVLS_5": "sample string 24",
      "USCATVLS_6": "sample string 25",
      "Base_Uofm": "sample string 26",
      "Replaced_By": "sample string 27",
      "Item_Blocked": true,
      "Selling_Multiple": 29.0,
      "Inactive": 64,
      "Purchase_Item_Tax_Schedu": "sample string 30",
      "Purchase_Tax_Options": 31,
      "Sales_Tax_Option": 32,
      "Item_Tax_Schedule_ID": "sample string 33",
      "In_Stock": "Yes",
      "UserFieldData": [
        {},
        {},
        {}
      ],
      "UserFieldNames": [
        "sample string 1",
        "sample string 2",
        "sample string 3"
      ],
      "Notifications": null
    }
  ],
  "NextPageLink": null,
  "Count": 3
}