Inventory
End Point
'FourWallReport' is used to retrieve a comprehensive list of available inventory across the tenant (including multiple warehouses if applicable).
Typically used as a facility to synchronize inventory.
GET https://{tenant_name}.p4warehouse.com/api/Report/FourWallReport
Headers
| Name | Type | Description |
|---|---|---|
ApiKey* | String | System API key |
[
{
"$id": "1",
"ProductId": "eca6e721-9a16-4b61-b739-06a0f099f3d3",
"Sku": "PRODUCT_A",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 368.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "2",
"ProductId": "3e3c425e-bd87-4cc4-bb58-ee13f95255bb",
"Sku": "PRODUCT_AB",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 207.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "3",
"ProductId": "26abbbbd-ef13-418e-a96d-815c3c237303",
"Sku": "PRODUCT_B",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 337.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "4",
"ProductId": "ffd56b97-6c32-4319-8331-0def8c5a7c36",
"Sku": "PRODUCT_C",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 1248.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "5",
"ProductId": "a1856298-32d5-476b-8f54-582e89274c93",
"Sku": "PRODUCT_CD",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 135.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "6",
"ProductId": "76aece53-56d6-402b-86dd-1949713c92d6",
"Sku": "PRODUCT_D",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 6284.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "7",
"ProductId": "e4fec495-2dff-4987-a41a-e6dde322f8d9",
"Sku": "PRODUCT001",
"ClientId": "e21f7253-b17b-42f8-bacc-ff968df4fcfc",
"ClientName": "03",
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 99.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "8",
"ProductId": "e4fec495-2dff-4987-a41a-e6dde322f8d9",
"Sku": "PRODUCT001",
"ClientId": "e21f7253-b17b-42f8-bacc-ff968df4fcfc",
"ClientName": "03",
"WarehouseId": "a8398ca3-bcbd-464d-954d-f7f1fa3e3876",
"Warehouse": "Warehouse3",
"Quantity": 610.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "9",
"ProductId": "9c1e8c1c-24e3-46da-921f-899124d60ba7",
"Sku": "PRODUCT002",
"ClientId": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"ClientName": "02",
"WarehouseId": "a8398ca3-bcbd-464d-954d-f7f1fa3e3876",
"Warehouse": "Warehouse3",
"Quantity": 205.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "10",
"ProductId": "9c1e8c1c-24e3-46da-921f-899124d60ba7",
"Sku": "PRODUCT002",
"ClientId": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"ClientName": "02",
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 34.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "11",
"ProductId": "a49c9506-29b4-474c-9e5b-5554ad1b6ecb",
"Sku": "PRODUCT003",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 2304.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "12",
"ProductId": "3a7a6ba2-6e69-474f-9769-a6bfb7f5c092",
"Sku": "PRODUCT004",
"ClientId": "ce54af79-2587-4053-8c65-b13734f4bf39",
"ClientName": "01",
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 1211.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "13",
"ProductId": "3a7a6ba2-6e69-474f-9769-a6bfb7f5c092",
"Sku": "PRODUCT004",
"ClientId": "ce54af79-2587-4053-8c65-b13734f4bf39",
"ClientName": "01",
"WarehouseId": "a8398ca3-bcbd-464d-954d-f7f1fa3e3876",
"Warehouse": "Warehouse3",
"Quantity": 1210.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "14",
"ProductId": "48519ad9-9126-4c97-82d3-668d0340d23a",
"Sku": "PRODUCT005",
"ClientId": "ce54af79-2587-4053-8c65-b13734f4bf39",
"ClientName": "01",
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 348.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "15",
"ProductId": "48519ad9-9126-4c97-82d3-668d0340d23a",
"Sku": "PRODUCT005",
"ClientId": "ce54af79-2587-4053-8c65-b13734f4bf39",
"ClientName": "01",
"WarehouseId": "a8398ca3-bcbd-464d-954d-f7f1fa3e3876",
"Warehouse": "Warehouse3",
"Quantity": 250.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "16",
"ProductId": "76d04eac-e1e4-4315-aff4-9495f1f7295e",
"Sku": "PRODUCT006",
"ClientId": "ce54af79-2587-4053-8c65-b13734f4bf39",
"ClientName": "01",
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 165.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "17",
"ProductId": "190adbd4-fb44-4b4e-8dc8-b60dd8780b00",
"Sku": "PRODUCT007",
"ClientId": "ce54af79-2587-4053-8c65-b13734f4bf39",
"ClientName": "01",
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 295.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "18",
"ProductId": "f8ee74b8-6868-40f0-b8fb-ecd2ee2d6940",
"Sku": "PRODUCT008",
"ClientId": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"ClientName": "02",
"WarehouseId": "a8398ca3-bcbd-464d-954d-f7f1fa3e3876",
"Warehouse": "Warehouse3",
"Quantity": 450.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "19",
"ProductId": "f8ee74b8-6868-40f0-b8fb-ecd2ee2d6940",
"Sku": "PRODUCT008",
"ClientId": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"ClientName": "02",
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 576.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "20",
"ProductId": "91982098-fd8e-477b-9d17-2f5c74fde64a",
"Sku": "PRODUCT009",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 4.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "21",
"ProductId": "590d1f77-86f5-4bd6-988d-cac5b3af4f41",
"Sku": "PRODUCT010",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 997.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "22",
"ProductId": "dd7591f3-886e-4eb0-b2d2-591e172c7fde",
"Sku": "PRODUCT011",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 425.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": "2023-05-14T00:00:00+00:00",
"EachCount": null
},
{
"$id": "23",
"ProductId": "dd7591f3-886e-4eb0-b2d2-591e172c7fde",
"Sku": "PRODUCT011",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 250.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": "2025-10-21T00:00:00+00:00",
"EachCount": null
},
{
"$id": "24",
"ProductId": "589c0758-2603-4121-add1-7904cada9cbd",
"Sku": "PRODUCT012",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 4.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": 5
},
{
"$id": "25",
"ProductId": "589c0758-2603-4121-add1-7904cada9cbd",
"Sku": "PRODUCT012",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 57.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": 10
},
{
"$id": "26",
"ProductId": "e50e5f0e-e86a-4db7-804c-c6c79ec9191d",
"Sku": "PRODUCT013",
"ClientId": null,
"ClientName": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": "Warehouse1",
"Quantity": 609.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": null
},
{
"$id": "27",
"ProductId": "a3bc0471-4947-44a6-b325-1d64a2ec06d3",
"Sku": "PRODUCT014",
"ClientId": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"ClientName": "02",
"WarehouseId": "4438c1b1-ef0a-42c8-88aa-f355bbf05d0f",
"Warehouse": "Warehouse2",
"Quantity": 40.00,
"SerialNumber": null,
"LotNumber": null,
"Expiry": null,
"EachCount": 10
}
]Following reports includes all the product quantities that are currently present in the warehouse including products that are allocated, picked, etc.