Product Storage
Interface
It allows you:
to get the detailed inventory for a product
This API Method is recommended to use when you need detailed information about product inventory.
Columns that can be used as filters:
Organization
Warehouse
Warehouse_ID
Value
Name
LastModified (UTC time format ISO 8601: yyyy-MM-dd HH:mm:ss Z from M_Storage). The sign used for comparison is ”>” (exclusive). Use this filter to get all the inventory/stock modified after the date/time value sent in this parameter.
eg: LastModified=2014-06-13 12:40:00 +0300 if you are in Romania or LastModified=2014-06-13%2012:40:00%20%2b0300
Actions can be done:
list
API Methods fields:
API Methods:
List:
URL: https://api.socratecloud.com/webapi/rest/product/storage/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}
Method: GET
Return: JSON object with next format:
{
"data": [
{
"Organization": "Demo SRL",
"Value": "product_value",
"Name": "product_name",
"WSOrganization": "Demo SRL",
"Warehouse": "PF",
"Warehouse_ID": 1000006,"
"OnHandQty": 1021,
"ReservedQty": 0,
"OrderedQty": 9,
"AvailableQty": 1021,
"InProgressQty": 0
}
],
"totalRows": 7
}
List Full:
URL: https://api.socratecloud.com/webapi/rest/product/storage/list_full/{version}?startRow={0}&endRow={100}&accessToken={access_token}
Method: GET
Return: JSON object with next format:
{
"data": [
{
"Organization": "Demo SRL",
"Value": "product_value",
"Name": "product_name",
"WSOrganization": "Demo SRL",
"Warehouse": "PF",
"Warehouse_ID": 1000006,"
"OnHandQty": 1021,
"ReservedQty": 0,
"OrderedQty": 9,
"AvailableQty": 1021,
"InProgressQty": 0,
"orderedQtyList": [
{
"DatePromised": "2020-06-09 00:00:00+0300",
"QtyOrdered": 3
},
{
"DatePromised": "2020-06-11 00:00:00+0300",
"QtyOrdered": 6
}
]
}
],
"totalRows": 7
}