Pricefx REST API Reference
- Update a Compensation Record
The Pricefx Backend API
ID of the CompensationRecordSet into which this Compensation Record belongs. By default it belongs to "Default" CompensationRecordSet, but you can change it when you create the Compensation Record. This can be useful if you create different "kinds" of Compensation Records which will be used to calculate different results at different times.
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/compensationrecord.fetch/{compensationRecordSetId}
- URL:https://companynode.pricefx.com/pricefx/companypartition/compensationrecord.fetch/{compensationRecordSetId}
- 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/compensationrecord.fetch/{compensationRecordSetId}' \
-H 'Content-Type: application/json' \
-d '{
"endRow": 300,
"oldValues": null,
"operationType": "fetch",
"startRow": 0,
"textMatchStyle": "exact",
"data": {
"_constructor": "AdvancedCriteria",
"operator": "and",
"criteria": [
{
"fieldName": "sourceId",
"operator": "equals",
"value": "CO-158"
}
]
}
}'- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/compensationrecord.update
- URL:https://companynode.pricefx.com/pricefx/companypartition/compensationrecord.update
- 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/compensationrecord.update \
-H 'Content-Type: application/json' \
-d '{
"data": {
"typedId": "string",
"resultPrice": 0,
"endDate": null,
"workflowStatus": "DRAFT",
"intgStatus": "string",
"payoutDate": null,
"priceChangePct": 0,
"attribute83": "string",
"attribute82": "string",
"intgStatusDetails": "string",
"attribute81": "string",
"attribute80": "string",
"sourceIdNoRev": "string",
"rank": 0,
"attribute89": "string",
"attribute88": "string",
"sku": "string",
"attribute87": "string",
"attribute86": "string",
"calculationResults": [
{
"resultName": "string",
"resultLabel": "string",
"result": {},
"excludeFromExport": true,
"warnings": [
"string"
],
"alertMessage": "string",
"alertType": "CRITICAL",
"displayOptions": 0,
"formatType": "NUMERIC",
"suffix": "string",
"resultType": "string",
"cssProperties": "string",
"userGroup": "string",
"resultGroup": "string",
"overrideValueOptions": [
null
],
"overrideAllowEmpty": true,
"labelTranslations": "string",
"overridable": true,
"overridden": true,
"resultDescription": "string"
}
],
"attribute85": "string",
"attribute84": "string",
"unitOfMeasure": "string",
"agreementTerms": {
"Target": "string",
"Compensation": "string",
"Payment Period": "string",
"property1": {},
"property2": {}
},
"targetDate": "2019-08-24T14:15:22Z",
"allowedOverrides": "string",
"version": 0,
"alerts": "string",
"attribute9": "string",
"attribute94": "string",
"attribute8": "string",
"attribute93": "string",
"attribute92": "string",
"attribute91": "string",
"attribute5": "string",
"attribute90": "string",
"attribute4": "string",
"attribute7": "string",
"attribute6": "string",
"attribute1": "string",
"attribute14": "string",
"messages": [
"string"
],
"attribute13": "string",
"userGroupEdit": "string",
"attribute3": "string",
"attribute12": "string",
"attribute2": "string",
"attribute11": "string",
"attribute99": "string",
"attribute10": "string",
"attribute98": "string",
"attribute97": "string",
"startDate": "2019-08-24T14:15:22Z",
"attribute96": "string",
"status": "DRAFT",
"attribute95": "string",
"formulaName": "string",
"itemExtensions": {},
"agreementClass": "string",
"attribute19": "string",
"attribute18": "string",
"attribute17": "string",
"attribute16": "string",
"attribute15": "string",
"sellerName": "string",
"manual": true,
"calculationDate": "2019-08-24T14:15:22Z",
"manualOverrides": "string",
"calculationBaseAsAdvancedFilterCriteria": {
"_constructor": "string",
"property1": {},
"property2": {}
},
"parentTypedId": "string",
"attribute25": "string",
"submittedByName": "string",
"attribute24": "string",
"currency": "string",
"attribute23": "string",
"attribute22": "string",
"attribute21": "string",
"attribute20": "string",
"createDate": "2019-08-24T14:15:22Z",
"calculationBase": {
"includedCustomerGroups": [
{}
],
"includedProductGroups": [
{}
],
"includedSellerReferences": [
{}
],
"excludedCustomerGroups": [
{}
],
"excludedproductGroups": [
{}
],
"excludedSellerReferences": [
{}
],
"includedTimePeriods": [
{
"timeUnit": "DAY",
"startDate": "2019-08-24T14:15:22Z",
"endDate": "2019-08-24T14:15:22Z",
"single": true
}
],
"excludedTimePeriods": [
{}
],
"otherFilters": [
"string"
],
"dateDimFieldName": "string"
},
"approvalRequiredEmailAttachments": [
null
],
"attribute29": "string",
"compensationStatus": "DRAFT",
"attribute28": "string",
"attribute27": "string",
"attribute26": "string",
"lineId": "string",
"completeResultsAvailable": "s",
"attribute36": "string",
"attribute35": "string",
"attribute34": "string",
"attribute33": "string",
"attribute32": "string",
"attribute31": "string",
"intgStatusErpReference": "string",
"attribute30": "string",
"sourceId": "string",
"seller": {
"sellerId": "string",
"sellerName": "string"
},
"key2": "string",
"attribute39": "string",
"inputs": [
{
"name": "string",
"label": "string",
"lookupTableId": "string",
"url": "string",
"type": "string",
"value": {},
"valueHint": "string",
"readOnly": true,
"filter": {
"property1": {},
"property2": {}
},
"parameterGroup": "string",
"required": true,
"labelTranslations": "string",
"addUnknownValues": true,
"typedId": "string",
"alwaysEditable": true,
"inputs": [
{}
],
"parameterConfig": {
"property1": {},
"property2": {}
},
"formattingOptions": {
"property1": {},
"property2": {}
},
"valueOptions": [
"string"
]
}
],
"lastUpdateDate": "2019-08-24T14:15:22Z",
"attribute38": "string",
"attribute37": "string",
"compensationHeaderType": "string",
"compensationRecordSetLabel": "string",
"deniedByName": "string",
"attribute47": "string",
"attribute46": "string",
"userGroupViewDetails": "string",
"approvedByName": "string",
"attribute45": "string",
"attribute44": "string",
"attribute43": "string",
"attribute42": "string",
"attribute41": "string",
"attribute40": "string",
"priceChange": 0,
"agreementInputs": [
{}
],
"customerGroup": {
"label": "string",
"customerFieldName": "string",
"customerFieldLabel": "string",
"customerFieldValue": "string",
"customerFilterCriteria": {
"property1": {},
"property2": {}
}
},
"attribute49": "string",
"attribute48": "string",
"attribute50": "string",
"attribute100": "string",
"uniqueName": "string",
"calculatedResultPrice": 0,
"name": "string",
"attribute58": "string",
"attribute57": "string",
"attribute56": "string",
"attribute55": "string",
"productFilterString": "string",
"hasWorkflowHistory": true,
"attribute54": "string",
"attribute53": "string",
"attribute52": "string",
"allCalculationResults": [
{
"property1": {},
"property2": {}
}
],
"attribute51": "string",
"calculationBaseJson": "string",
"approvalDate": "2019-08-24T14:15:22Z",
"recordSetLabel": "string",
"attribute59": "string",
"description": "string",
"compensationRecordSetId": 0,
"attribute61": "string",
"attribute60": "string",
"customerFilterString": "string",
"previousPrice": 0,
"attribute69": "string",
"formulaElementGroup": "string",
"attribute68": "string",
"attribute67": "string",
"calculatedWithErrorsMsg": "SUCCESS",
"attribute66": "string",
"attribute65": "string",
"attribute64": "string",
"attribute63": "string",
"attribute62": "string",
"workStatus": "string",
"manualResultPrice": 0,
"compensationConditionType": "string",
"comments": "string",
"warnings": "string",
"approvalState": "NOT_APPROVED",
"label": "string",
"calculatedMsg": "SUCCESS",
"agreementInputsAsMap": {
"property1": {},
"property2": {}
},
"attribute72": "string",
"attribute71": "string",
"attribute70": "string",
"productGroup": {
"label": "string",
"productFieldName": "string",
"productFieldLabel": "string",
"productFieldValue": "string",
"productFilterCriteria": {
"property1": {},
"property2": {}
}
},
"createdBy": 0,
"calculationStatus": 0,
"attribute79": "string",
"attribute78": "string",
"attribute77": "string",
"attribute76": "string",
"attribute75": "string",
"attribute74": "string",
"lastUpdateBy": 0,
"attribute73": "string"
}
}'{ "response": { "node": "string", "data": [ … ], "status": 0 } }
Request
The Revoke action is available only for approved records. This action is useful when the Compensation Record was approved in Pricefx, integration did not happen yet and there is nothing to reverse in ERP. When this action is used, the record changes its status to Revoked.
The Administer Compensation Records user role is needed to perform the Revoke action.
- Mock serverhttps://api.pricefx.com/_mock/openapi/reference/pricefx-server_openapi/compensationrecord.revoke/{typedId}
- URL:https://companynode.pricefx.com/pricefx/companypartition/compensationrecord.revoke/{typedId}
- 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/compensationrecord.revoke/{typedId}'{ "response": { "node": "string", "data": null, "status": 0, "startRow": 0, "endRow": 0 } }
See the Key-Value Database Storage Knowledge Base article for more details.
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