Gets
information about stock on existing inventory locations. | Uses your API Key and some Filters in an
array format and returns the search results using the given filters. Optionally, you can use ReturnTopNRecords
to limit the number of the results to the specified number (omit, or add ReturnTopNRecords = -1 to get all
the available results). The ReturnTopNRecords chooses the top records in a ProductId descending order.
We can add more than two Filters by using the Group ("StartGroup" and "EndGroup" are used to group parts of the
filter expression and create a priority sequence for the filter expression. For example: XYZ (SQL) is the equivalent
of XYZ (MV API)) and then an AndOr operator as shown below:
A. Return the first 3 out of all inventory location stocks of products with ID equal
to 51 or 53, whose description contains the word "NBA". The results will be returned as an mvProductStockList object which is an Array
of mvStocks objects.
Value: {
"Filters": [
{
"Group": "StartGroup",
"FieldName": "productid",
"SearchOperator": "Equals",
"SearchValue": "54"
},
{
"AndOr": "Or",
"Group": "EndGroup",
"FieldName": "productid",
"SearchOperator": "Equals",
"SearchValue": "51"
},
{
"AndOr": "And",
"FieldName": "productdescription",
"SearchOperator": "Contains",
"SearchValue": "NBA"
}
],
"showDeleted": "showAllDeletedAndUndeleted",
"ReturnTopNRecords": "3"
}
Response: {
"mvProductStockList": [
{
"productID": 51,
"mvStock": [
{
"InventoryLocationID": 4,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176817-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176817-0000)/"
},
{
"InventoryLocationID": 5,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176817-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176817-0000)/"
},
{
"InventoryLocationID": 6,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176817-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176817-0000)/"
},
{
"InventoryLocationID": 7,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176817-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176817-0000)/"
},
{
"InventoryLocationID": 8,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1505221877037-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1505221877037-0000)/"
}
],
"StockPhysicalTotal": 0,
"StockOnHoldTotal": 0,
"StockNonShippedTotal": 0,
"StockNonAllocatedWOsTotal": 0,
"StockNonReceivedPOsTotal": 0,
"StockNonReceivedWOsTotal": 0,
"StockOnHandTotal": 0,
"StockAlertLevelTotal": 0
},
{
"productID": 54,
"mvStock": [
{
"InventoryLocationID": 4,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176863-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176863-0000)/"
},
{
"InventoryLocationID": 5,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176863-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176863-0000)/"
},
{
"InventoryLocationID": 6,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176863-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176863-0000)/"
},
{
"InventoryLocationID": 7,
"StockPhysical": 0,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 0,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1504777176897-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1504777176897-0000)/"
},
{
"InventoryLocationID": 8,
"StockPhysical": 1,
"StockOnHold": 0,
"StockNonShipped": 0,
"StockNonAllocatedWOs": 0,
"StockNonReceivedPOs": 0,
"StockNonReceivedWOs": 0,
"StockOnHand": 1,
"StockAlertLevel": 0,
"SubLocation": "",
"InventoryLocationStockCreationDate": "/Date(1505221877050-0000)/",
"InventoryLocationStockLastUpdatedDate": "/Date(1505728795243-0000)/"
}
],
"StockPhysicalTotal": 1,
"StockOnHoldTotal": 0,
"StockNonShippedTotal": 0,
"StockNonAllocatedWOsTotal": 0,
"StockNonReceivedPOsTotal": 0,
"StockNonReceivedWOsTotal": 0,
"StockOnHandTotal": 1,
"StockAlertLevelTotal": 0
}
],
"ResponseStatus": {
"ErrorCode": "0"
}
}
|