Product Purchasing
Interface:
It allows you to:
insert new product purchasings
process(update) existing product purchasings
view product purchasings
Columns that can be used as filters:
Product_ID
Actions that can be done:
list
create
update
API Methods:
List:
URL: https://api.socratecloud.com/webapi/rest/product/purchasing/list/{version}?startRow={0}&endRow={100}&accessToken={accessToken}
Method: GET
Available filter parameters:
Product_ID
Return: JSON object with next format:
{
"data": [
{
"Organization_ID": 1000001,
"Active": true,
"Created": "2014-03-05 09:09:43+0200",
"CreatedBy": 1000863,
"Updated": "2014-03-05 09:09:43+0200",
"UpdatedBy": 1000863,
"CurrentVendor": true,
"UOM_ID": 100,
"Currency_ID": 102,
"ListPrice": 11,
"POPrice": 9,
"PriceEffective": null,
"LastPOPrice": 33,
"LastInvoicePrice": null,
"UPC": null,
"PartnerCategory": null,
"Discontinued": false,
"DiscontinuedBy": null,
"MinimumOrderQty": 1,
"OrderPackQty": 1,
"CostPerOrder": 0,
"ActualDeliveryTime": null,
"LeadTime": 0,
"RoyaltyAmount": 0,
"Manufacturer": null,
"QualityRating": null,
"Description": null,
"PartnerProductKey": "TDK91",
"BPartner_ID": 1000493,
"CalendarUpdated": null
}
],
"totalRows":1
}
Create
URL: https://api.socratecloud.com/webapi/rest/product/purchasing/create/{version}?accessToken={accessToken}&Product_ID={Product_ID}
Method: POST
Return: product value for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000001,
"Active": true,
"Created": "2014-03-05 09:09:43+0200",
"CreatedBy": 1000863,
"Updated": "2014-03-05 09:09:43+0200",
"UpdatedBy": 1000863,
"CurrentVendor": true,
"UOM_ID": 100,
"Currency_ID": 102,
"ListPrice": 11,
"POPrice": 9,
"PriceEffective": null,
"UPC": null,
"PartnerCategory": null,
"Discontinued": false,
"DiscontinuedBy": null,
"MinimumOrderQty": 1,
"OrderPackQty": 1,
"CostPerOrder": 0,
"LeadTime": 0,
"RoyaltyAmount": 0,
"Manufacturer": null,
"QualityRating": null,
"Description": null,
"PartnerProductKey": "TDK91",
"BPartner_ID": 1000493,
"CalendarUpdated": null
}
Update:
URL: https://api.socratecloud.com/webapi/rest/product/purchasing/update/{version}?accessToken={accessToken}&Product_ID={Product_ID}&BPartner_ID={BPartner_ID}
Method: POST
Return: product value for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000001,
"Active": true,
"Created": "2014-03-05 09:09:43+0200",
"CreatedBy": 1000863,
"Updated": "2014-03-05 09:09:43+0200",
"UpdatedBy": 1000863,
"CurrentVendor": true,
"UOM_ID": 100,
"Currency_ID": 102,
"ListPrice": 11,
"POPrice": 9,
"PriceEffective": null,
"UPC": null,
"PartnerCategory": null,
"Discontinued": false,
"DiscontinuedBy": null,
"MinimumOrderQty": 1,
"OrderPackQty": 1,
"CostPerOrder": 0,
"LeadTime": 0,
"RoyaltyAmount": 0,
"Manufacturer": null,
"QualityRating": null,
"Description": null,
"PartnerProductKey": "TDK91",
"BPartner_ID": 1000493,
"CalendarUpdated": null
}