Get Product Inventory
GET/products/:lookupkey/:key/inventory
This endpoint gives cumulative product inventory data by searching on a lookup key.
Request
Path Parameters
lookupkey stringrequired
Available lookup keys: id, sourceId, sku, supplierCode
key stringrequired
Lookup key value
Query Parameters
expands string
Expands cumulative inventory data with detailed records
Responses
- 200
- 404
Get Product Inventory by Id - 200 / Get Product Inventory by Id - expands - 200 / Get Product Inventory by Id - 200 (reserved stock) / Get Product Inventory by Id - expands - 200 (reserved stock)
Response Headers
Connection
string
Content-Length
string
Date
string
Keep-Alive
string
Return-Format
string
- application/json
- Schema
- Example (from schema)
- Get Product Inventory by Id - expands - 200
- Get Product Inventory by Id - 200
- Get Product Inventory by Id - 200 (reserved stock)
- Get Product Inventory by Id - expands - 200 (reserved stock)
Schema
Array [
]
data
object[]
localQuantity number
localReservedQuantity number
nextDeliveryDate string
productId number
supplierQuantity number
supplierReservedQuantity number
totalQuantity number
totalReservedQuantity number
messages undefined[]
total number
{
"data": [
{
"localQuantity": 136,
"localReservedQuantity": 0,
"nextDeliveryDate": "2022-02-15T00:00:00",
"productId": 38952,
"supplierQuantity": 54,
"supplierReservedQuantity": 0,
"totalQuantity": 190,
"totalReservedQuantity": 0
}
],
"messages": [],
"total": 1
}
{
"data": [
{
"balance": [
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-03-09T10:49:54",
"id": 16150,
"location": "",
"nextDeliveryDate": "2022-02-15T00:00:00",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 11.31,
"dateModified": "2022-02-21T12:55:27",
"id": 16152,
"location": "L5",
"nextDeliveryDate": "2022-02-15T00:00:00",
"notes": "",
"productId": 38952,
"quantity": 3,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 4
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T10:59:59",
"id": 16157,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-03-09T10:46:25",
"id": 16159,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 5,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T22:05:16",
"id": 16160,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 11.31,
"dateModified": "2022-02-16T22:05:17",
"id": 16162,
"location": "L5",
"nextDeliveryDate": "2022-02-20T00:00:00",
"notes": "",
"productId": 38952,
"quantity": 16,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 4
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T22:12:18",
"id": 16164,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 5,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T22:12:19",
"id": 16165,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T22:17:44",
"id": 16168,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 5,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T22:17:44",
"id": 16169,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T22:21:27",
"id": 16172,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 5,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-16T22:21:28",
"id": 16173,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-17T00:03:24",
"id": 16176,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 5,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-17T00:03:24",
"id": 16177,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-17T00:05:35",
"id": 16180,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 5,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-17T00:05:35",
"id": 16181,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-17T00:18:15",
"id": 16184,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 5,
"sku": "AA 0635613",
"supplier": "KERRIDGE",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
},
{
"companyId": 0,
"costPrice": 0,
"dateModified": "2022-02-17T00:18:15",
"id": 16185,
"location": "",
"nextDeliveryDate": "",
"notes": "",
"productId": 38952,
"quantity": 13,
"sku": "AA 0635613",
"supplier": "INTERN",
"supplierCode": "AA 0635613",
"usergroupId": 0,
"warehouseId": 0
}
],
"localQuantity": 133,
"localReservedQuantity": 0,
"nextDeliveryDate": "2022-02-15T00:00:00",
"productId": 38952,
"supplierQuantity": 38,
"supplierReservedQuantity": 0,
"totalQuantity": 171,
"totalReservedQuantity": 0
}
],
"messages": [],
"total": 1
}
{
"data": [
{
"localQuantity": 136,
"localReservedQuantity": 0,
"nextDeliveryDate": "2022-02-15T00:00:00",
"productId": 38952,
"supplierQuantity": 54,
"supplierReservedQuantity": 0,
"totalQuantity": 190,
"totalReservedQuantity": 0
}
],
"messages": [],
"total": 1
}
{
"data": [
{
"localQuantity": 0,
"localReservedQuantity": 0,
"nextDeliveryDate": "2021-03-01T00:00:00",
"productId": 227237,
"supplierQuantity": 246,
"supplierReservedQuantity": 164,
"totalQuantity": 262,
"totalReservedQuantity": 164
}
],
"messages": [
"Completed"
],
"total": 1
}
{
"data": [
{
"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
}
],
"messages": [
"Completed"
],
"total": 1
}
Get Product Inventory by Id - 404
Response Headers
Alt-Svc
string
Via
string
alt-svc
string
content-length
string
date
string
return-format
string
server
string
x-request-id
string
- application/json
- Schema
- Example (from schema)
- Get Product Inventory by Id - 404
Schema
error
object
code number
messages string[]
moreInfo string
status number
type string
{
"error": {
"code": 80006,
"messages": [
"Product with id [59328] not found"
],
"moreInfo": "https://www.propel.us/docs/errors/80006",
"status": 404,
"type": "ProductNotFound"
}
}
{
"error": {
"code": 80006,
"messages": [
"Product with id [59328] not found"
],
"moreInfo": "https://www.propel.us/docs/errors/80006",
"status": 404,
"type": "ProductNotFound"
}
}
Loading...