Skip to content
Pricefx REST API
/Pricefx API Reference/
/
Add a Product

The Pricefx Backend API

Pricefx REST API Reference

Download OpenAPI description
pricefx-server_openapi.json
pricefx-server_openapi.yaml
Overview
URL
https://www.pricefx.com
Pricefx
documentation@pricefx.com
Languages
Servers
Mock server
https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi
URL:
https://{baseUrl}/pricefx/{partition}

General

Operations

Products

Operations

Upsert a Product

Request

Upserts a product.

  • To add a new product that does not exist, specify the sku parameter in the request.

  • To update an existing product, specify the sku or typedId parameter of the existing product. The /integrate method performs a partial update – it does not delete values from fields that have not been specified in the update request.

    Use the /integrate/{TypeCode}/returnolddata endpoint to return also the data of the previous version in the response.

Please note: This method is intended to be used with one or two objects and it allows you to update particular fields. The request will overwrite the existing data of the record being updated, regardless of other changes. To work with more products in bulk please use the /loaddata/P endpoint.

This operation is particularly useful if the caller does not (and should not) know about typed IDs and other internal data fields, i.e. typically in an integration scenario.

The only mandatory pre-requisite for this operation is that the object's defined business key fields (vary per object type) are present in every request. No typed ID or version fields are required. This also means that no version checking is performed, thus the request will overwrite existing data of that record, regardless of other changes.

Information: You can upsert multiple records using one request. To do so, add multiple data objects into your JSON. See the example below.

[
  {
    "data": {
      "sku": "111111",
      "typedId": "2147501227.P",
      "label": "The New Label",
      "unitOfMeasure": "EA",
      "currency": "USD",
      "formulaName": "priceLogic2",
      "attribute1": "1",
      "attribute2": "2",
      "userGroupEdit": "Administrators",
      "userGroupViewDetails": "PricingManagers"
    }
  },
  {
    "data": {
      "sku": "222222",
      "label": "The New Label 2",
      "unitOfMeasure": "EA",
      "currency": "EUR",
      "formulaName": "priceLogic2",
      "attribute1": "1",
      "attribute2": "2",
      "userGroupEdit": "Administrators",
      "userGroupViewDetails": "PricingManagers"
    }
  }
]
Security
basic or X-PriceFx-jwt
Bodyapplication/json

Either sku or typedId must be specified in order to update an existing product. To insert a new product, specify at least the sku parameter.

Please note: The data sent in your request might be different from our sample request schema. Custom fields (attribute1..attribute30) can be retrieved using the /fetch/PAM operation.

dataobjectrequired

Specify field names and values you want to insert or update.

data.​skustring[ 1 .. 255 ] charactersrequired
data.​typedIdstringnon-empty
data.​labelstring[ 1 .. 255 ] characters
data.​unitOfMeasurestring[ 1 .. 255 ] characters
data.​currencystring[ 1 .. 255 ] characters
data.​formulaNamestring[ 1 .. 255 ] characters
data.​userGroupEditstring[ 1 .. 255 ] characters
data.​userGroupViewDetailsstring[ 1 .. 255 ] characters
data.​attribute1string[ 1 .. 255 ] characters
data.​attribute2string[ 1 .. 255 ] characters
curl -i -X POST \
  -u <username>:<password> \
  https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/integrate/P \
  -H 'Content-Type: application/json' \
  -d '{
    "data": {
      "sku": "123456",
      "typedId": "2147501227.P",
      "label": "The Label",
      "unitOfMeasure": "EA",
      "currency": "USD",
      "formulaName": "PricingFormula01",
      "userGroupEdit": "Administrators",
      "userGroupViewDetails": "PricingManagers",
      "attribute1": "20",
      "attribute2": "10"
    }
  }'

Responses

Returns full record details.

Bodyapplication/json
responseobject
Any of:
Response
application/json
{
  "response": {
    "node": "node",
    "startRow": 0,
    "data": [ … ],
    "endRow": 8,
    "totalRows": 8,
    "status": 0
  }
}

Add a Product

Request

Inserts a product to the Master Data - Products table.

Security
basic or X-PriceFx-jwt
Bodyapplication/json
dataobjectrequired
data.​skustringnon-emptyrequired
data.​labelstringnon-empty
data.​unitOfMeasurestringnon-empty
data.​currencystringnon-empty
data.​formulaNamestringnon-empty
data.​attribute1stringnon-empty
data.​attribute2stringnon-empty
data.​attribute3number
data.​userGroupEditstringnon-empty
data.​userGroupViewDetailsstringnon-empty
operationstringnon-emptyrequired
curl -i -X POST \
  -u <username>:<password> \
  https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/add/P \
  -H 'Content-Type: application/json' \
  -d '{
    "data": {
      "sku": "p2398759575012555",
      "label": "Smoked Tofu",
      "unitOfMeasure": "ea",
      "currency": "USD",
      "formulaName": "PriceList",
      "attribute1": "2",
      "attribute2": "PG1",
      "attribute3": 1,
      "userGroupEdit": "PricingManagers,Administrators",
      "userGroupViewDetails": "PricingManagers"
    },
    "operation": "add"
  }'

Responses

Returns full record details.

Bodyapplication/json
responseobject
Any of:
Response
application/json
{
  "response": {
    "node": "node",
    "startRow": 0,
    "data": [ … ],
    "endRow": 8,
    "totalRows": 8,
    "status": 0
  }
}

Update a Product

Request

Updates an existing product.

Security
basic or X-PriceFx-jwt
Bodyapplication/json

Updates specified fields of the record. Only one record can be updated per request (unless batched).

Please note: The update request should contain all old values in the oldValues property (especially the typedId and the version) and all values (along the typedId) you want to update in the data property.

Apart from the version checks, additional integrity checks are performed. E.g. if fields that are part of the business key are changed then it is checked that no other object is already defined with those key(s).

dataobjectrequired

Enter new field values. Multiple values can be updated. In our example the unitOfMeasure and label properties were updated.

data.​unitOfMeasurestring[ 1 .. 255 ] characters
data.​typedIdstringnon-emptyrequired
data.​labelstring[ 1 .. 255 ] characters
oldValuesobjectrequired
oldValues.​versionnumberrequired
oldValues.​typedIdstringnon-emptyrequired
oldValues.​skustring[ 1 .. 255 ] characters
oldValues.​labelstring[ 1 .. 255 ] characters
oldValues.​unitOfMeasurestring[ 1 .. 255 ] characters
oldValues.​userGroupEditstring or null[ 1 .. 255 ] characters
oldValues.​userGroupViewDetailsstring or null[ 1 .. 255 ] characters
oldValues.​currencystring[ 1 .. 255 ] characters
oldValues.​formulaNameany
oldValues.​imageany
oldValues.​createDatestringnon-empty
oldValues.​createdBynumber
oldValues.​lastUpdateDatestringnon-empty
oldValues.​lastUpdateBynumber
oldValues.​attribute1any
oldValues.​attribute2any
oldValues.​attribute3any
oldValues.​attribute4any
oldValues.​attribute5any
oldValues.​attribute6any
oldValues.​attribute7any
oldValues.​attribute8any
oldValues.​attribute9any
oldValues.​attribute10any
oldValues.​attribute11any
oldValues.​attribute12any
oldValues.​attribute13any
oldValues.​attribute14any
oldValues.​attribute15any
oldValues.​attribute16any
oldValues.​attribute17any
oldValues.​attribute18any
oldValues.​attribute19any
oldValues.​attribute20any
oldValues.​attribute21any
oldValues.​attribute22any
oldValues.​attribute23any
oldValues.​attribute24any
oldValues.​attribute25any
oldValues.​attribute26any
oldValues.​attribute27any
oldValues.​attribute28any
oldValues.​attribute29any
oldValues.​attribute30any
operationTypestringnon-empty

Must be 'update' or null or omitted.

textMatchStylestringnon-empty
noEventstring

Set to true when this operation should NOT trigger an update event (where applicable).

curl -i -X POST \
  -u <username>:<password> \
  https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/update/P \
  -H 'Content-Type: application/json' \
  -d '{
    "data": {
      "currency": "EUR",
      "typedId": "2147501222.P"
    },
    "oldValues": {
      "version": 5,
      "typedId": "2147501222.P",
      "sku": "33333",
      "label": "Label Three",
      "unitOfMeasure": "EA",
      "userGroupEdit": "admin",
      "userGroupViewDetails": null,
      "currency": "CZK",
      "formulaName": "PriceList",
      "image": null,
      "createDate": "2021-09-16T09:43:59",
      "createdBy": 2147490696,
      "lastUpdateDate": "2021-11-04T18:33:16",
      "lastUpdateBy": 2147490696,
      "attribute1": "56",
      "attribute2": "3rd",
      "attribute3": 4,
      "attribute4": null,
      "attribute5": null,
      "attribute6": null,
      "attribute7": null,
      "attribute8": null,
      "attribute9": null,
      "attribute10": null,
      "attribute11": null,
      "attribute12": null,
      "attribute13": null,
      "attribute14": null,
      "attribute15": null,
      "attribute16": null,
      "attribute17": null,
      "attribute18": null,
      "attribute19": null,
      "attribute20": null,
      "attribute21": null,
      "attribute22": null,
      "attribute23": null,
      "attribute24": null,
      "attribute25": null,
      "attribute26": null,
      "attribute27": null,
      "attribute28": null,
      "attribute29": null,
      "attribute30": null
    },
    "operationType": "update",
    "textMatchStyle": "exact"
  }'

Responses

Returns full record details.

Bodyapplication/json
responseobject
Any of:
Response
application/json
{
  "response": {
    "node": "node",
    "startRow": 0,
    "data": [ … ],
    "endRow": 8,
    "totalRows": 8,
    "status": 0
  }
}

Product Extensions

Operations

Product Image

Operations

Customers

Operations

Customer Extensions

Operations

Sellers

Operations

Seller Extensions

Operations

Condition Records

Operations

Competition Data

Operations

Imports

Operations

Data Change Requests

Operations

Lookup Tables / Company Parameters

Operations

User Admin

Operations

Authentication

Operations

Admin Tools

Operations

Logics

Operations

Logs

Operations

Custom Forms

Operations

Calculated Field Sets

Operations

Jobs & Tasks

Operations

Data Manager

Operations

Actions

Operations

Action Types

Operations

Price Lists

Operations

Manual Price Lists

Operations

Live Price Grids

Operations

Calculation Grids

Operations

Visual Configuration

Operations

Quotes

Operations

Contracts (Agreements & Promotions)

Operations

Visual Configuration

Operations

Rebate Agreements

Operations

Rebate Calculations

Operations

Rebate Record Group

Operations

Sales Compensations

Operations

Claim Types

Operations

Claims

Operations

Optimization

Operations

Workflow

Operations

Workflow Delegation

Operations

Attachments

To upload a file you need to perform the following actions using endpoints in this category:

  1. Create an Upload Slot
  2. Upload a File
  3. Delete an Upload Slot
Operations

Product Image

Operations

Configuration

Operations

Internationalization

Operations

Metadata

Operations

Clicmanager

Clicmanager (CLIC = "Calculable Line Item Collection") endpoints are used in the REACT version to manipulate Quote/Agreements & Promotions (Contract)/Rebate Agreement/Compensation Plan objects.

Operations

Comments

Operations

Notifications

Operations

Heartbeat

Operations

Key-Value Store

See the Key-Value Database Storage Knowledge Base article for more details.

Operations

Entities

Here you can find all fields of the corresponding entity (represented by the type code).
Use the /metadata.describe endpoint to find out the correct data type of the field that is used in your partition.

otherSchemas

Schemas