Retreive a list of products from your administration. A maximum of 100 products will be returned at once. Use offset and limit parameters to retrieve more products over multiple calls. It is also possible to retreive just one specific product by adding the ArticleNumber or EAN request parameter.
- Request
- Response
Parameters
Category
String
Details
An optional parameter to only retreive products from one specific category
ArticleNumber
String
Details
An optional parameter to retreive only the product with exactly this articlenumber. The result will never be more than one item.
EAN
String
Details
An optional parameter to retrieve only the product with exactly this EAN code. The result will never be more than one item.
ChangedSince
String
Details
(optional) An UNIX timestamp in seconds. Will return only relations that are changed since the specified timestamp.
CreatedSince
String
Details
(optional) An UNIX timestamp in seconds. Will return only relations that are created since the specified timestamp.
Limit
Integer
Details
Defines the limit of items to retreive
Offset
Integer
Details
Defines the offset for the retreive
IncludeArchived
Boolean (true|false)
Details
Whether to include archived products (true) or not (false). Defaults to false.
IncludeStockPositions
Boolean (true|false)
Details
Whether to include information about stock positions (dutch: "Voorraadposities"). For example stock per warehouse / shelf / batch. Defaults to false.
CURL Example
1 |
curl -X GET -H "Content-Type: application/json" -H "ApiKey: b7d343Bnhd436f3ec3bd3504582" -H "Username: [email protected]" "https://rest-api.silvasoft.nl/rest/listproducts?category=Electronics&Limit=10" |
Parameters
Name
String
More info
The product name
ArticleNumber
String
More info
The article number (not nessecarily numeric)
Category
String
More info
Category name for this product
EAN
String
More info
Product EAN code
Description
String
More info
Product description, limited to 400 characters
StockQty
Float
More info
The actual stock quantity
PurchasePrice
Float
More info
The latest purchase price
Price
Float
More info
The default sale price excluding VAT
VATPercentage
Float
More info
The VAT percentage
Unit
String
More info
The product unit (example: 'piece' or 'hour')
MinimalStockQty
Float
More info
The minimal amount of stock for this product as specified in Silvasoft.
QtyInSalesOrder
String
More info
The stock quantity currently reserved by sales orders
QtyInPurchaseOrder
String
More info
The stock quantity currently expected by purchase orders
QtySalable
String
More info
The 'salable' stock quantity which is the actual quantity PLUS QtyInPurchaseOrder MINUS QtyInSalesOrder
SupplierArticleNumber
String
More info
The articlenumber of the default supplier for this article.
CreatedOn
Long
More info
An UNIX timestamp in seconds reflecting the date and time of creation.
ChangedOn
Long
More info
An UNIX timestamp in seconds reflecting the date and time of last change.
ProductOrService
String
More info
Whether the article is marked as 'Product' or as 'Service' in Silvasoft.
DeliveryPeriod
String
More info
The delivery period (in days) as configured for this product
Archived
Boolean (true|false)
More info
Whether the product is archived or not.
ProductResponse_CustomField
Array
More info
An array of custom fields and their values for this product
ProductResponse_CustomField > Label
String
More info
The custom field name / label
ProductResponse_CustomField > DataType
String
More info
The datatype of this custom field. Can be used to determine which value field is needed. Possible data types: Decimal, Boolean, String, Integer, DateTime
ProductResponse_CustomField > DateTimeValue
String Date (dd-MM-yyyy)
More info
The date value of the custom field
ProductResponse_CustomField > DecimalValue
Float
More info
The decimal value of the custom field
ProductResponse_CustomField
Boolean (true|false)
More info
The boolean value of the custom field
ProductResponse_CustomField > StringValue
String
More info
The string value of the custom field
ProductResponse_CustomField > IntValue
Integer
More info
The integer value of the custom field
ProductResponse_CustomField > FieldType
String
More info
The field type as specified in Sivasoft. Possible field types: Integer, Date, Decimal, TextSmall, TextLarge, Hyperlink, Checkbox, List
Product_StockPosition
Array
More info
An array of stock positions for this product
Product_StockPosition > Warehouse
String
More info
If the position is associated to a warehouse this will show the warehouse name
Product_StockPosition > Shelf
String
More info
If the position is associated to a shelf this will show the shelf name
Product_StockPosition > Batch
String
More info
If the position is associated to a batch this will show the batch name / number
Product_StockPosition > MinimalStockQty
Float
More info
The minimal stock quantity for this position as configured in Silvasoft
Product_StockPosition > StockQty
Float
More info
The actual stock quantity for this position
Product_StockPosition > QtyInSalesOrder
Float
More info
The stock quantity currently reserved by sales orders
Product_StockPosition > QtyInPurchaseOrder
Float
More info
The stock quantity currently expected by purchase orders
Product_StockPosition > QtySalable
Float
More info
The 'salable' stock quantity which is the actual quantity PLUS QtyInPurchaseOrder MINUS QtyInSalesOrder
IsCombinationProduct
Boolean (true|false)
More info
Whether the product is a combined/grouped product ("Verzamelproduct in Silvasoft")
Products_SubProduct
Array
More info
An array of subproducts associated with this product. Only filled if "IsCombinationProduct" = true and if there are subproducts associated in Silvasoft
Products_SubProduct > Name
String
More info
The name of the sub product
Products_SubProduct > ArticleNumber
String
More info
The articlenumber of the sub product
Products_SubProduct > Quantity
Float
More info
The quantity with which this sub product is associated with the combined/grouped product
Response JSON Example
The response order can vary from the parameter order above
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 |
[ { "Category":"Electronics", "EAN":"123456789120", "Description":"Product description", "StockQty":0, "Price":110, "ArticleNumber":"1204", "PurchasePrice":101.95, "VATPercentage":19, "Name":"BENQ Monitor 24 inch", "Unit":"Piece", "MinimalStockQty":"50", "SupplierArticleNumber":"Han16-AC", "CreatedOn":1598340866, "ChangedOn":1599849807, "ProductOrService":"Service", "ProductResponse_CustomField":[ { "DateTimeValue":null, "DecimalValue":"0.0", "BooleanValue":false, "Label":"Weight", "DataType":"Integer", "StringValue":null, "IntValue":25, "FieldType":"Integer" }, { "DateTimeValue":null, "DecimalValue":"0.0", "BooleanValue":false, "Label":"Description Spanish", "DataType":"String", "StringValue":"Buenos Dias", "IntValue":0, "FieldType":"TextSmall" } ], "Product_StockPosition": [ { "Warehouse": "Warehouse Amsterdam", "StockQty": "355.00000000", "Batch": "", "MinimalStockQty": "15.00000000", "Shelf": "1A" }, { "Warehouse": "Warehouse Berlin", "StockQty": "40.00000000", "Batch": "", "MinimalStockQty": "15.00000000", "Shelf": "10C" } ], "IsCombinationProduct":true, "Products_SubProduct":[ { "Name":"Product 1", "ArticleNumber":"sku-1", "Quantity":8, }, { "Name":"Product 4", "ArticleNumber":"sku-4", "Quantity":2, } ], }, { "Category":"Electronics", "EAN":"123456789130", "Description":"Product description", ...... } ] |