Inventory Transaction

Every operation of inventory results into a merge / split of the same (receiving, shipping, etc.) causing an inventory transaction event that can be consumed by downstream applications

Fetch Inventories

GET /wms/inventory-transaction

This API returns single or set of inventory transactions in the system based on the filter criteria provided. This will have log of all the transactions done on an inventory with all the details. Please refer to the sample response below for fields.

Query Parameters

Name	Type	Description
sku_id	String	Blowhorn assigned/supplied integer unique id for the SKU like 12345
sku_name	String	Partial or full text matching name of the SKU like 'Wires'
client_id	String	Warehouse Client id to which the item belongs.
client_name	String	Warehouse Client name like 'ABC Corp' either full or partial for search
site_id	String	Warehouse site identifier which is numeric
site_name	String	Full or partial Warehouse site name for search.
created_date_start	String	Date in the form of YYYY-MM-DD which indicates start filter which is inclusive to filter the result on created_date field date of the inventory.
created_date_end	String	Date in the form of YYYY-MM-DD which indicates end filter which is inclusive to filter the result on created_date of the inventory.
tag	String	Full or partial tag value to filter the inventory result. If passed full value like `TAG-1Y28W7L` then result will be only one inventory returned matching to the tag.

Headers

Name	Type	Description
API_KEY*	string	Contact Blowhorn team for API Key

401 Unauthorized/Validation Error

{
  "status": "FAIL",
  "message": "Unauthorized"
}

500 Unexpected error

{
  "status": "FAIL",
  "message": "Unexpected error"
}

200: OK Response for no search criteria or no matching criteria

{
    "count": 2296,
    "previous": null,
    "next": 2,
    "result": [
        {
            "id": 213504,
            "sku_name": "Cannon Digital Camera",
            "from_loc_name": "Default Client-7",
            "to_loc_name": "Default Client-7",
            "client_name": "Default Client",
            "site_name": "Koramangala WH",
            "supplier_name": "Default Supplier",
            "pack_config_name": "Box of 1",
            "modified_by_name": "",
            "created_by_name": "kiran",
            "order_number": "",
            "ref_number": "",
            "created_date": "2022-04-26T15:52:58.767267+05:30",
            "modified_date": "2022-04-26T15:52:58.782880+05:30",
            "tag": "TAG-2289U82",
            "tracking_level": "Each",
            "qty": 1,
            "uom": null,
            "status": "WMS Shipped",
            "source": null,
            "remarks": null,
            "reference": null,
            "reference_number": null,
            "operation": null,
            "qty_diff": 0,
            "qty_left": 0,
            "created_by": 110035,
            "modified_by": null,
            "from_loc": 6,
            "to_loc": 6,
            "pack_config": 6,
            "sku": 89,
            "site": 7,
            "client": 4,
            "container": null,
            "supplier": 4,
            "order": null
        },
        {
            "id": 212799,
            "sku_name": "Cannon Digital Camera lens",
            "from_loc_name": "Default Client-7",
            "to_loc_name": "Default Client-7",
            "client_name": "Default Client",
            "site_name": "Koramangala WH",
            "supplier_name": "Default Supplier",
            "pack_config_name": "Box of 1",
            "modified_by_name": "",
            "created_by_name": "Shashank",
            "order_number": "",
            "ref_number": "",
            "created_date": "2022-04-26T09:12:06.151557+05:30",
            "modified_date": "2022-04-26T09:12:06.162786+05:30",
            "tag": "TAG-21XHAI9",
            "tracking_level": "Each",
            "qty": 1,
            "uom": null,
            "status": "Quantity Updated",
            "source": null,
            "remarks": null,
            "reference": null,
            "reference_number": null,
            "operation": null,
            "qty_diff": 0,
            "qty_left": 0,
            "created_by": 109093,
            "modified_by": null,
            "from_loc": 6,
            "to_loc": 6,
            "pack_config": 6,
            "sku": 89,
            "site": 7,
            "client": 4,
            "container": null,
            "supplier": 4,
            "order": null
        }

200: OK No inventory transactions found for the search criteria

{
    "count": 0,
    "previous": null,
    "next": 0,
    "result": []
}