Pricefx REST API Reference
Pricefx REST API
/Pricefx API Reference/- Create an Object
Insert Bulk Data
Insert Bulk Data From a File
Insert Bulk Data From a File (async)
Upsert an Object
Upsert an Object (and return old data)
Update an Object (and return old data)
Update an Object
Delete an Object
Mass Update
Delete Column Values
Delete Objects
Get an Object
List Objects
List Type Codes
Create an Object
The Pricefx Backend API
Download OpenAPI description
Overview
URL
Pricefx
Languages
Servers
Mock server
https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi
URL:
https://{baseUrl}/pricefx/{partition}
Request
Deletes multiple objects based on filter settings.
Please Note: Invalid filter clauses are ignored. This could potentially lead to a full table truncate (the whole type without filter is deleted)! Use the forcefilter variant to enforce a filter in all cases!
Security
basic or X-PriceFx-jwt
Path
Bodyapplication/jsonThe object's type code. See the list of Type Codes.
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/delete/{TypeCode}/batch/forcefilter
- URL:https://companynode.pricefx.com/pricefx/companypartition/delete/{TypeCode}/batch/forcefilter
- curl
- JavaScript
- Node.js
- Python
- Java
- C#
- PHP
- Go
- Ruby
- R
- Payload
curl -i -X POST \
-u <username>:<password> \
'https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/delete/{TypeCode}/batch/forcefilter' \
-H 'Content-Type: application/json' \
-d '{
"data": {
"filterCriteria": {
"_constructor": "AdvancedCriteria",
"operator": "and",
"criteria": [
{
"fieldName": "currency",
"operator": "iEquals",
"value": "EUR"
}
]
}
}
}'Response
application/json
{ "response": { "node": "string", "data": [ … ], "status": 0 } }
Request
Creates an object. Only one object can be added per request (unless batched).
Information: Some object types may be blocked from being added by the update command as special processing is done by a dedicated manager command.
Security
basic or X-PriceFx-jwt
Path
Bodyapplication/jsonThe object's type code. See the list of Type Codes.
The initial values of the object. The request needs to contain all fields that are part of the business key for that object and all non-nullable fields.
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/add/{TypeCode}
- URL:https://companynode.pricefx.com/pricefx/companypartition/add/{TypeCode}
- curl
- JavaScript
- Node.js
- Python
- Java
- C#
- PHP
- Go
- Ruby
- R
- Payload
curl -i -X POST \
-u <username>:<password> \
'https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/add/{TypeCode}' \
-H 'Content-Type: application/json' \
-d '{
"data": {
"sku": "product001",
"label": "The Label 99",
"currency": "USD",
"formulaName": "PriceList",
"attribute1": "123",
"attribute2": "2"
},
"operation": "add"
}'Request
Retrieves details of the specified object.
Note: Certain data elements (e.g. lookup table values of any table, including JSON lookup tables / pricing params) should NOT be retrieved with the general fetch commands (/fetch/{TypeCode}). Always use the "...manager.fetch" API endpoints where they are available. The same applies to update/delete/integrate commands.
Information: The following entities can intentionally be fetched by any user without any particular user role: CN, BR, CS, CLLIAM, CTAM, CTT, CTTAM, C, CAM, CXAM, DMDC, DMF, DMDL, DMDS, DM, DMM, DMR, DMT, DCRAM, FN, IE, JST, JLTVM, MPLIT, MPLAM, MLTVM, MRAM, MT, PYRAM, PGIM, PRAM, PLIM, P, PAM, PXAM, QAM, RBAAM, RRAM, RRS, RRSC, RBT, RBTAM, SC, SCN, SCNAM, SIM, SIAM, UG.
Security
basic or X-PriceFx-jwt
Path
The object's type code. See the list of Type Codes.
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/fetch/{TypeCode}/{id}
- URL:https://companynode.pricefx.com/pricefx/companypartition/fetch/{TypeCode}/{id}
- curl
- JavaScript
- Node.js
- Python
- Java
- C#
- PHP
- Go
- Ruby
- R
- Payload
curl -i -X POST \
-u <username>:<password> \
'https://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/fetch/{TypeCode}/{id}'Response
application/json
{ "response": { "node": "string", "data": [ … ], "status": 0 } }
See the Key-Value Database Storage Knowledge Base article for more details.
Operations
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.
Comments