Product Price Ext

Interface

It allows you:

• to get the selling price ext of product

• to write/update selling prices ext of one product

• to delete a seling price ext of one product

This API Method is recommended to use when you have  particular price list defined per customer. 

Prerequisites:

In order to use this API Method  there must be accomplished the following requirements in SocrateCloud:

• to have  the product created in SocrateCloud

Columns that can be used as filters:

• Product (value)

• PriceList

• PriceListVersion

• Active

Mandatory Parameters when inserting product prices:

• Product Value

Actions can be done:

• list

• create

• update

• delete

API Methods:

List:

URL: https://api.socratecloud.com/sprc/rest/product/price/ext/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}&Product={productValue}

Method: GET

Return: JSON object with next format:

{

    "data": [

        {

            "Organization": "*",

            "Created": "2015-06-17 09:06:37+0300",

            "CreatedBy": "TESTBEBE_Admin",

            "Updated": "2015-06-17 09:06:37+0300",

            "UpdatedBy": "TESTBEBE_Admin",

            "Active": true,

            "Product": "HRM-000",

            "ProductName": "Ore Servicii Proactive",

            "PriceList": "RON VNZ",

            "PriceListVersion": "RON VNZ 2014",

            "Price1": 320,

            "Threshold1": 10,

            "Price2": 310,

            "Threshold2": 20,

            "Price3": 300,

            "Threshold3": 30,

            "Price4": 290,

            "Threshold4": 50,

            "Price5": 280,

            "Threshold5": 100,

            "Price6": null,

            "Threshold6": null,

            "Price7": null,

            "Threshold7": null,

            "Price8": null,

            "Threshold8": null,

            "Price9": null,

            "Threshold9": null,

            "Price10": null,

            "Threshold10": null,

            "Price11": null,

            "Threshold11": null,

            "Price12": null,

            "Threshold12": null,

            "PriceLimit": 270

        }

    ],

    "totalRows": 1

}

Create:

URL: https://api.socratecloud.com/sprc/rest/product/price/ext/create/{version}?accessToken={access_token}&Product={product_value}&PriceList={price_list}&PriceListVersion={price_list_version}

Method: POST

Return: 'productValue_priceListVersion' for success or error message (start with "ERROR: ")

Data format:

        {

            "Active": true,

            "Price1": 320,

            "Threshold1": 10,

            "Price2": 310,

            "Threshold2": 20,

            "Price3": 300,

            "Threshold3": 30,

            "Price4": 290,

            "Threshold4": 50,

            "Price5": 280,

            "Threshold5": 100,

            "Price6": null,

            "Threshold6": null,

            "Price7": null,

            "Threshold7": null,

            "Price8": null,

            "Threshold8": null,

            "Price9": null,

            "Threshold9": null,

            "Price10": null,

            "Threshold10": null,

            "Price11": null,

            "Threshold11": null,

            "Price12": null,

            "Threshold12": null,

            "PriceLimit": 270

        }

Update:

URL: https://api.socratecloud.com/sprc/rest/product/price/ext/update/{version}?accessToken={access_token}&Product={product_value}&PriceList={price_list}&PriceListVersion={price_list_version}

Method: POST

Return: 'productValue_priceListVersion' for success or error message (start with "ERROR: ")

Data format:

        {

            "Active": true,

            "Price1": 320,

            "Threshold1": 10,

            "Price2": 310,

            "Threshold2": 20,

            "Price3": 300,

            "Threshold3": 30,

            "Price4": 290,

            "Threshold4": 50,

            "Price5": 280,

            "Threshold5": 100,

            "Price6": null,

            "Threshold6": null,

            "Price7": null,

            "Threshold7": null,

            "Price8": null,

            "Threshold8": null,

            "Price9": null,

            "Threshold9": null,

            "Price10": null,

            "Threshold10": null,

            "Price11": null,

            "Threshold11": null,

            "Price12": null,

            "Threshold12": null,

            "PriceLimit": 270

        }

Delete:

URL: https://api.socratecloud.com/sprc/rest/product/price/ext/delete/{version}?accessToken={access_token}&Product={product_value}&PriceList={price_list}&PriceListVersion={price_list_version}

Method: POST

Return: 'Deleted' for success or error message (start with "ERROR: ")