Pricefx REST API Reference
Pricefx REST API
/Pricefx API Reference/- Delete Column Values (Matrix only)
Upsert a Lookup Table Value
Update a Lookup Table Value
Delete a Lookup Table Value
Mass Delete Lookup Table Values
Add a Lookup Table Value
List All Lookup Table Values
List All Lookup Tables
Add a Lookup Table
Delete a Lookup Table
Insert Bulk Data to Lookup Table
Copy a Lookup Table
Update a Lookup Table
Get Logic References
Mass Edit
Delete Column Values (Mat...
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 a Lookup Table specified by typedId.
| Required Permission | Roles with the Required Permission |
|---|---|
| LOOKUPTABLE_REMOVE | Administer Price Parameters (PB_PARAMETERS), Administer Plasma (PLASMA) |
Security
basic or X-PriceFx-jwt
Specify the typedId of the Lookup Table (Company Parameters) you want to delete.
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/lookuptablemanager.delete
- URL:https://companynode.pricefx.com/pricefx/companypartition/lookuptablemanager.delete
- 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/lookuptablemanager.delete \
-H 'Content-Type: application/json' \
-d '{
"data": {
"typedId": "2147484036.LT"
}
}'Response
application/json
{ "response": { "node": "<node>", "data": [ … ], "status": 0 } }
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/lookuptablemanager.resetcolumn/{tableId}/{columnName}
- URL:https://companynode.pricefx.com/pricefx/companypartition/lookuptablemanager.resetcolumn/{tableId}/{columnName}
- 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/lookuptablemanager.resetcolumn/{tableId}/{columnName}'Request
Inserts multiple records to the specified Lookup Table.
The /loaddata operation is a very efficient and quick way to insert bulk data. The main advantage is its greater speed when loading thousands of records (compared to e.g. /integrate).
Security
basic or X-PriceFx-jwt
We used /lookuptablemanager.loaddata/MLTV in the request example to insert bulk data to Matrix Lookup Table. Notice that the lookupTable is used in the header section and then ID of the Lookup Table in the data section
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/lookuptablemanager.loaddata/{TypeCode}
- URL:https://companynode.pricefx.com/pricefx/companypartition/lookuptablemanager.loaddata/{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/lookuptablemanager.loaddata/MLTV \
-H 'Content-Type: application/json' \
-d '{
"data": {
"header": [
"attribute1",
"lookupTable"
],
"data": [
[
"att1-1",
"2147484051"
],
[
"att1-2",
"2147484051"
],
[
"att1-3",
"2147484051"
]
]
}
}'Response
application/json
{ "response": { "node": "string", "csrfToken": "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