List Calculation Grids

post/fetch/CG

Retrieves Calculation Grids. A filter can be applied.

Securitybasic or X-PriceFx-jwt
Request
Request Body schema: application/json
object (listCalculationGridsRequest)
Responses
200

OK

Response Schema: application/json
object
node
string
startRow
integer
Array of objects (CalculationGrid)
Array
lastUpdateByName
string or null <= 255 characters
createdByName
string or null <= 255 characters
updateDate
string or null <date>
typedId
string
configuration
string
relativeTargetDateDays
integer or null
lastUpdateDate
string <date-time>
numberOfSubmittedItems
integer
numberOfAutoApprovedItems
integer
locale
string or null <= 255 characters
numberOfDeniedItems
integer
calculationDate
string or null <date-time>
keyGenerationType
string <= 255 characters
Possible values: "DATA_DRIVEN" "LOGIC_DRIVEN" "MANUAL"
writeOnlyChangedItems
boolean
userGroupViewDetails
string or null <= 255 characters
id
integer
calculationGridType
string or null <= 255 characters
Possible values: "CG1" "CG2" "CG3" "CG4" "CG5" "CG6" null
createDate
string <date-time>
calculationMessages
string or null
updatedBy
integer
numberOfApprovedItems
integer
keySize
integer
targetDate
string <date>
label
string <= 255 characters
version
integer
partialCalculationDate
string or null <date-time>
numberOfOpenItems
integer
createdBy
integer
numberOfItems
integer
userGroupEdit
string or null <= 255 characters
nodeId
integer or null
keepManualOverrides
boolean
calculationStartDate
string or null <date-time>
lastUpdateBy
integer
status
string <= 255 characters
Possible values: "DRAFT" "PENDING" "SCHEDULED" "PROCESSING" "SCHEDULED_DIRTY" "ERROR" "READY" "CANCELLED"
approvalLevel
string <= 255 characters
Value: "LINE_ITEM"
endRow
integer
totalRows
integer
status
integer
Request samples
application/json
{
  • "endRow": 300,
  • "operationType": "fetch",
  • "startRow": 0,
  • "textMatchStyle": "exact",
  • "data": {
    • "_constructor": "AdvancedCriteria",
    • "operator": "and",
    • "criteria": [
      • {
        • "fieldName": "status",
        • "operator": "equals",
        • "value": "SCHEDULED"
        }
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "pricefx-cluster-app-frontend-5459985ccb-cwdn6",
    • "startRow": 0,
    • "data": [
      • {
        • "version": 0,
        • "typedId": "2.CG",
        • "label": "Testing",
        • "numberOfItems": 0,
        • "keepManualOverrides": false,
        • "writeOnlyChangedItems": false,
        • "configuration": "{\"logicDriven\":{\"keyGenerationLogic\":\"SampleFlexibleCalculationGridKeyLogic\",\"keyLogicElement\":\"Static2Keys\"},\"keyHandlingMode\":\"add-only\",\"calculationLogic\":\"CalculationGridBasic\",\"elementNames\":[],\"hiddenElementNames\":[],\"approvalTriggerFields\":[],\"approvalMappings\":{}}",
        • "numberOfApprovedItems": 0,
        • "numberOfOpenItems": 0,
        • "numberOfDeniedItems": 0,
        • "numberOfSubmittedItems": 0,
        • "numberOfAutoApprovedItems": 0,
        • "keySize": 0,
        • "createdByName": "vinh.nguyen",
        • "lastUpdateByName": "vinh.nguyen",
        • "keyGenerationType": "LOGIC_DRIVEN",
        • "updateDate": "2022-11-23",
        • "updatedBy": 2147484789,
        • "createDate": "2022-11-23T07:47:15",
        • "createdBy": 2147484789,
        • "lastUpdateDate": "2022-11-23T07:47:15",
        • "lastUpdateBy": 2147484789,
        • "status": "DRAFT",
        • "id": 2
        },
      • {
        • "version": 0,
        • "typedId": "3.CG",
        • "targetDate": "2022-11-23",
        • "label": "CGtest",
        • "numberOfItems": 0,
        • "keepManualOverrides": false,
        • "writeOnlyChangedItems": false,
        • "configuration": "{\"logicDriven\":{\"keyGenerationLogic\":\"KeyLogic_CalculationGrid\",\"keyLogicElement\":\"KeyList_1Keys\"},\"keyHandlingMode\":\"auto\",\"calculationLogic\":\"SampleFlexibleCalculationGridLogic\",\"elementNames\":[\"KeySize\",\"Warning\",\"NumericLongResult\",\"DateResult\",\"MatrixResult\",\"PercentResult\",\"PXSearch\"],\"hiddenElementNames\":[],\"approvalTriggerFields\":[],\"approvalMappings\":{}}",
        • "numberOfApprovedItems": 0,
        • "numberOfOpenItems": 0,
        • "numberOfDeniedItems": 0,
        • "numberOfSubmittedItems": 0,
        • "numberOfAutoApprovedItems": 0,
        • "keySize": 0,
        • "keyGenerationType": "LOGIC_DRIVEN",
        • "updateDate": "2022-11-23",
        • "updatedBy": 2147490187,
        • "createDate": "2022-11-23T10:26:52",
        • "createdBy": 2147490187,
        • "lastUpdateDate": "2022-11-23T10:26:52",
        • "lastUpdateBy": 2147490187,
        • "status": "DRAFT",
        • "id": 3
        }
      ],
    • "endRow": 2,
    • "totalRows": 2,
    • "status": 0
    }
}