Gets information on existing products | 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.
A. Get all the finished goods manufactured from a work order.
We can add two Filters by using the AndOr operator as shown below:
Value: {
"Filters": [
{
"FieldName": "ProductType",
"SearchOperator": "Equals",
"SearchValue": "ManufactureFromWorkOrder"
}
],
"ReturnTopNRecords": 1
}
Response: {
"mvProducts": [
{
"ProductID": 27412,
"ProductType": "ManufactureFromWorkOrder",
"ProductSKU": "prod111",
"ProductEAN": "",
"ProductDescription": "manufacture test",
"ProductVersion": "",
"ProductLongDescription": "",
"ProductCategoryID": 0,
"ProductUnitOfMeasurement": "",
"ProductSellingPrice": 0,
"ProductPurchasePrice": 0,
"ProductUnitCost": 0,
"ProductWeight": 0,
"ProductLength": 0,
"ProductBreadth": 0,
"ProductHeight": 0,
"ProductImageURL": "",
"ProductComments": "",
"ProductCustomField1": "",
"ProductCustomField2": "",
"ProductCustomField3": "",
"ProductCustomField4": "",
"ProductCustomField5": "",
"ProductCustomField6": "",
"ProductCustomField7": "",
"ProductCustomField8": "",
"ProductCustomField9": "",
"ProductCustomField10": "",
"ProductCustomField11": "",
"ProductCustomField12": "",
"ProductCustomField13": "",
"ProductCustomField14": "",
"ProductCustomField15": "",
"ProductCustomField16": "",
"ProductCustomField17": "",
"ProductCustomField18": "",
"ProductCustomField19": "",
"ProductCustomField20": "",
"ProductOption1": "",
"ProductOption2": "",
"ProductOption3": "",
"ProductOption4": "",
"ProductOption5": "",
"ProductOption6": "",
"ProductOption7": "",
"ProductOption8": "",
"ProductOption9": "",
"ProductOption10": "",
"ProductMainSupplierID": 0,
"ProductMainSupplierPrice": 0,
"ProductMainSupplierSKU": "",
"ProductMainSupplierDescription": "",
"ProductCreationDate": "/Date(1530110485503-0000)/",
"IsInventorySerialised": false,
"IsBatchNumbersEnabled": false,
"SerialNumberPrefix": "",
"SerialNumberLength": 11,
"IsPurchasable": true,
"PurchasableStartDate": "/Date(1519499361953-0000)/",
"PurchasableEndDate": "/Date(1519499361953-0000)/",
"IsSellable": true,
"SellableStartDate": "/Date(1519499361953-0000)/",
"SellableEndDate": "/Date(1519499361953-0000)/",
"DefaultSalesQuantity": 1,
"DefaultPurchaseQuantity": 1,
"MinimumSalesQuantity": 1,
"MinimumPurchaseQuantity": 1,
"MaximumSalesQuantity": 10,
"MaximumPurchaseQuantity": 100
}
],
"ResponseStatus": {
"ErrorCode": "0"
}
}
B. Get all the products that have a product image and a selling price less than 20.
Value: {
"Filters": [
{
"FieldName": "ProductImageURL",
"SearchOperator": "NotEquals",
"SearchValue": ""
},
{
"AndOr": "And",
"FieldName": "ProductSellingPrice",
"SearchOperator": "LessThan",
"SearchValue": 20
}
]
}
Response: {
"mvProducts": [
{
"ProductID": 27397,
"ProductType": "BuyFromSupplier",
"ProductSKU": "aass2s1",
"ProductEAN": "",
"ProductDescription": "aass2s1",
"ProductVersion": "",
"ProductLongDescription": "",
"ProductCategoryID": 0,
"ProductUnitOfMeasurement": "",
"ProductSellingPrice": 0,
"ProductPurchasePrice": 0,
"ProductUnitCost": 0,
"ProductWeight": 0,
"ProductLength": 0,
"ProductBreadth": 0,
"ProductHeight": 0,
"ProductImageURL": "https://lh3.googleusercontent.com/TMOtFhRVZ53_tX8vfVK17NDcAhcYkW-U_XgL21t_KYQwPgkE-ddTPwurMlfQe2x-dYFPA5dkJEqWQfgoPNz-=w2736-h1616",
"ProductComments": "",
"ProductCustomField1": "",
"ProductCustomField2": "",
"ProductCustomField3": "",
"ProductCustomField4": "",
"ProductCustomField5": "",
"ProductCustomField6": "",
"ProductCustomField7": "",
"ProductCustomField8": "",
"ProductCustomField9": "",
"ProductCustomField10": "",
"ProductCustomField11": "",
"ProductCustomField12": "",
"ProductCustomField13": "",
"ProductCustomField14": "",
"ProductCustomField15": "",
"ProductCustomField16": "",
"ProductCustomField17": "",
"ProductCustomField18": "",
"ProductCustomField19": "",
"ProductCustomField20": "",
"ProductOption1": "",
"ProductOption2": "",
"ProductOption3": "",
"ProductOption4": "",
"ProductOption5": "",
"ProductOption6": "",
"ProductOption7": "",
"ProductOption8": "",
"ProductOption9": "",
"ProductOption10": "",
"ProductMainSupplierID": 5361,
"ProductMainSupplierPrice": 5,
"ProductMainSupplierSKU": "",
"ProductMainSupplierDescription": "",
"ProductCreationDate": "/Date(1519499361953-0000)/",
"IsInventorySerialised": false,
"IsBatchNumbersEnabled": false,
"SerialNumberPrefix": "",
"SerialNumberLength": 11,
"IsPurchasable": true,
"PurchasableStartDate": "/Date(1519499361953-0000)/",
"PurchasableEndDate": "/Date(1519499361953-0000)/",
"IsSellable": true,
"SellableStartDate": "/Date(1519499361953-0000)/",
"SellableEndDate": "/Date(1519499361953-0000)/",
"DefaultSalesQuantity": 1,
"DefaultPurchaseQuantity": 1,
"MinimumSalesQuantity": 1,
"MinimumPurchaseQuantity": 1,
"MaximumSalesQuantity": 10,
"MaximumPurchaseQuantity": 100
}
],
"ResponseStatus": {
"ErrorCode": "0"
}
}
|