GET api/Inventories/ByLot?WarehouseId={WarehouseId}

Retrieves the inventory levels by lot for all non-kit items in a warehouse for the current date.

Request Information

URI Parameters

NameDescriptionTypeAdditional information
WarehouseId

The WarehouseId from the BGS system. Acceptable values are: 1 (for Memphis, TN) or 2 (for Salt Lake City, UT)

integer

Required

Body Parameters

None.

Response Information

Resource Description

Collection of InventoryByLot
NameDescriptionTypeAdditional information
WarehouseId

Acceptable values are: 1 (for Memphis, TN) or 2 (for Salt Lake City, UT)

integer

None.

ItemId

Unique identifier from the BGS system that is assigned at item creation, and it can be used as the id parameter.

integer

None.

SKU

SKU identifier assigned to the item.

string

None.

SKU2

An alternate SKU identifier assigned to the item.

string

None.

ItemName

Name/Description given to the item.

string

None.

Lot

Lot of the given item.

string

None.

ExpirationDate

Expiration date of the given item. The expiration date can be null.

date

None.

ItemQuantity

Inventory level of the item.

integer

None.

Response Formats

application/json, text/json

Sample:
[
  {
    "WarehouseId": 2,
    "ItemId": 3,
    "SKU": "sample string 4",
    "SKU2": "sample string 5",
    "ItemName": "sample string 6",
    "Lot": "sample string 7",
    "ExpirationDate": "2025-12-14T15:23:46.5924228+00:00",
    "ItemQuantity": 8
  },
  {
    "WarehouseId": 2,
    "ItemId": 3,
    "SKU": "sample string 4",
    "SKU2": "sample string 5",
    "ItemName": "sample string 6",
    "Lot": "sample string 7",
    "ExpirationDate": "2025-12-14T15:23:46.5924228+00:00",
    "ItemQuantity": 8
  }
]

application/xml, text/xml

Sample:
<ArrayOfInventoryByLot xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/ISCBGSAPI.Models">
  <InventoryByLot>
    <ExpirationDate>2025-12-14T15:23:46.5924228+00:00</ExpirationDate>
    <InventoryId>1</InventoryId>
    <ItemId>3</ItemId>
    <ItemName>sample string 6</ItemName>
    <ItemQuantity>8</ItemQuantity>
    <Lot>sample string 7</Lot>
    <SKU>sample string 4</SKU>
    <SKU2>sample string 5</SKU2>
    <WarehouseId>2</WarehouseId>
  </InventoryByLot>
  <InventoryByLot>
    <ExpirationDate>2025-12-14T15:23:46.5924228+00:00</ExpirationDate>
    <InventoryId>1</InventoryId>
    <ItemId>3</ItemId>
    <ItemName>sample string 6</ItemName>
    <ItemQuantity>8</ItemQuantity>
    <Lot>sample string 7</Lot>
    <SKU>sample string 4</SKU>
    <SKU2>sample string 5</SKU2>
    <WarehouseId>2</WarehouseId>
  </InventoryByLot>
</ArrayOfInventoryByLot>