Search Inventory
POST/inventory/search
This endpoint allows searching for product inventory cumulative quantities, separated by inventory type.
Available search fields
Name | Description | Required |
---|---|---|
productIds (array [integer]) | Array of product ids. | yes |
warehouseId (integer) | Warehouse id. | no |
location (string) | Location. | no |
Mandatory field in search payload is productIds array. If warehouseId or location are not sent in the payload, inventories will not be filtered by warehouse and/or location.
Request
Query Parameters
Expands cumulative inventory data with detailed records
Number of records per page. Default value is 12
Page number. Default value is 1
- application/json
Body
Responses
- 200
- 400
Search Inventory - 200 / Search Inventory - 200 (expands inventoryBalance)
Response Headers
Connection
string
Content-Length
string
Date
string
Keep-Alive
string
Return-Format
string
- application/json
- Schema
- Example (from schema)
- Search Inventory - 200
- Search Inventory - 200 (expands inventoryBalance)
Schema
Array [
]
data
object[]
{
"data": [
{
"localQuantity": 20,
"nextDeliveryDate": "2022-02-20T00:00:00",
"productId": 37232,
"supplierQuantity": 0,
"totalQuantity": 20
},
{
"localQuantity": 0,
"nextDeliveryDate": "",
"productId": 227197,
"supplierQuantity": 0,
"totalQuantity": 0
},
{
"localQuantity": 0,
"localReservedQuantity": 0,
"nextDeliveryDate": "2021-03-01T00:00:00",
"productId": 227237,
"supplierQuantity": 246,
"supplierReservedQuantity": 164,
"totalQuantity": 262,
"totalReservedQuantity": 164
}
],
"end": 3,
"itemsFound": 3,
"messages": [
"Completed"
],
"offset": 12,
"page": 1,
"pages": 1,
"start": 1,
"total": 3
}
{
"data": [
{
"localQuantity": 20,
"nextDeliveryDate": "2022-02-20T00:00:00",
"productId": 37232,
"supplierQuantity": 0,
"totalQuantity": 20
},
{
"localQuantity": 0,
"nextDeliveryDate": "",
"productId": 227197,
"supplierQuantity": 0,
"totalQuantity": 0
},
{
"localQuantity": 0,
"localReservedQuantity": 0,
"nextDeliveryDate": "2021-03-01T00:00:00",
"productId": 227237,
"supplierQuantity": 246,
"supplierReservedQuantity": 164,
"totalQuantity": 262,
"totalReservedQuantity": 164
}
],
"end": 3,
"itemsFound": 3,
"messages": [
"Completed"
],
"offset": 12,
"page": 1,
"pages": 1,
"start": 1,
"total": 3
}
{
"data": [
{
"balance": [
{
"companyId": 0,
"costPrice": 25.5,
"dateModified": "2022-06-20T13:40:00",
"id": 1,
"location": "",
"nextDeliveryDate": "2022-02-20T00:00:00",
"notes": "",
"productId": 37232,
"quantity": 20,
"sku": "",
"supplier": "",
"supplierCode": "757540",
"usergroupId": 0,
"warehouseId": ""
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-08-29T21:27:39",
"id": 16132,
"location": "B45",
"nextDeliveryDate": "2021-03-01T00:00:00",
"notes": "",
"productId": 37232,
"quantity": 3,
"sku": "757540",
"supplier": "INTERN",
"supplierCode": "757540",
"usergroupId": 0,
"warehouseId": 2
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-08-29T21:29:17",
"id": 16138,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 37232,
"quantity": 3,
"sku": "757540",
"supplier": "INTERN",
"supplierCode": "757540",
"usergroupId": 0,
"warehouseId": 0
}
],
"localQuantity": 26,
"localReservedQuantity": 0,
"nextDeliveryDate": "2021-03-01T00:00:00",
"productId": 37232,
"supplierQuantity": 0,
"supplierReservedQuantity": 0,
"totalQuantity": 26,
"totalReservedQuantity": 0
},
{
"balance": [
{
"companyId": 227583,
"costPrice": 400.95,
"dateModified": "2023-09-29T17:54:11",
"id": 16139,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 227237,
"quantity": 87,
"sku": "NCABD70004",
"supplier": "TECHDATA",
"supplierCode": "NCABD70004",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 11.31,
"dateModified": "2023-09-28T19:56:35",
"id": 16140,
"location": "L5",
"nextDeliveryDate": "2022-02-20T00:00:00",
"notes": "",
"productId": 227237,
"quantity": 16,
"sku": "NCABD70004",
"supplier": "KERRIDGE",
"supplierCode": "NCABD70004",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 400.95,
"dateModified": "2023-09-29T17:54:11",
"id": 16141,
"location": "B45",
"nextDeliveryDate": "2021-03-01T00:00:00",
"notes": "",
"productId": 227237,
"quantity": 77,
"sku": "NCABD70004",
"supplier": "TECHDATA",
"supplierCode": "NCABD70004",
"usergroupId": 143,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 400.95,
"dateModified": "2023-09-29T17:12:48",
"id": 16142,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 227237,
"quantity": 82,
"sku": "NCABD70004",
"supplier": "TECHDATA",
"supplierCode": "NCABD70004",
"usergroupId": 0,
"warehouseId": 0
}
],
"localQuantity": 0,
"localReservedQuantity": 0,
"nextDeliveryDate": "2021-03-01T00:00:00",
"productId": 227237,
"supplierQuantity": 246,
"supplierReservedQuantity": 164,
"totalQuantity": 262,
"totalReservedQuantity": 164
},
{
"balance": [
{
"costPrice": 25.5,
"dateModified": "2022-06-20T13:40:00",
"id": 1,
"location": "",
"nextDeliveryDate": "2022-02-20T00:00:00",
"notes": "",
"productId": 37232,
"quantity": 20,
"sku": "",
"supplier": "",
"supplierCode": "757540",
"warehouseId": ""
}
],
"localQuantity": 20,
"nextDeliveryDate": "2022-02-20T00:00:00",
"productId": 37232,
"supplierQuantity": 0,
"totalQuantity": 20
},
{
"balance": [],
"localQuantity": 0,
"nextDeliveryDate": "",
"productId": 227197,
"supplierQuantity": 0,
"totalQuantity": 0
}
],
"end": 3,
"itemsFound": 3,
"messages": [
"Completed"
],
"offset": 12,
"page": 1,
"pages": 1,
"start": 1,
"total": 3
}
Search Inventory - 400 (empty productIds array)
Response Headers
Connection
string
Content-Length
string
Date
string
Return-Format
string
- application/json
- Schema
- Example (from schema)
- Search Inventory - 400 (empty productIds array)
Schema
error
object
{
"error": {
"code": 10007,
"messages": [
"#/productIds: expected minimum item count: 1, found: 0"
],
"moreInfo": "https://www.propel.us/docs/errors/10007",
"status": 400,
"type": "SchemaValidationException"
}
}
{
"error": {
"code": 10007,
"messages": [
"#/productIds: expected minimum item count: 1, found: 0"
],
"moreInfo": "https://www.propel.us/docs/errors/10007",
"status": 400,
"type": "SchemaValidationException"
}
}