Update a Calculation Grid Item

post/calculationgridmanager.update/{id}

Allows you to perform a manual override of the specified Calculation Grid Item (CGI). Returns the updated CGIx object.

Securitybasic or X-PriceFx-jwt
Request
path Parameters
id
required
string

id of the Calculation Grid Item you want to update.

Example: 6
Request Body schema: application/json
required
object
typedId
required
string
key6
string
object (CalculationGridItem6Key)

The type code is CGI6.

alerts
string or null
Array of objects
Array
property name*
additional property
object
allowedOverrides
string or null <= 1300 characters
attribute1
string or null <= 70 characters
attribute2
string or null <= 70 characters
attribute3
string or null <= 70 characters
attribute4
string or null <= 70 characters
attribute5
string or null <= 70 characters
attribute6
string or null <= 70 characters
attribute7
string or null <= 70 characters
attribute8
string or null <= 70 characters
attribute9
string or null <= 70 characters
attribute10
string or null <= 70 characters
attribute11
string or null <= 70 characters
attribute12
string or null <= 70 characters
attribute13
string or null <= 70 characters
attribute14
string or null <= 70 characters
attribute15
string or null <= 70 characters
attribute16
string or null <= 70 characters
attribute17
string or null <= 70 characters
attribute18
string or null <= 70 characters
attribute19
string or null <= 70 characters
attribute20
string or null <= 70 characters
attribute21
string or null <= 70 characters
attribute22
string or null <= 70 characters
attribute23
string or null <= 70 characters
attribute24
string or null <= 70 characters
attribute25
string or null <= 70 characters
attribute26
string or null <= 70 characters
attribute27
string or null <= 70 characters
attribute28
string or null <= 70 characters
attribute29
string or null <= 70 characters
attribute30
string or null <= 70 characters
attribute31
string or null <= 70 characters
attribute32
string or null <= 70 characters
attribute33
string or null <= 70 characters
attribute34
string or null <= 70 characters
attribute35
string or null <= 70 characters
attribute36
string or null <= 70 characters
attribute37
string or null <= 70 characters
attribute38
string or null <= 70 characters
attribute39
string or null <= 70 characters
attribute40
string or null <= 70 characters
attribute41
string or null <= 70 characters
attribute42
string or null <= 70 characters
attribute43
string or null <= 70 characters
attribute44
string or null <= 70 characters
attribute45
string or null <= 70 characters
attribute46
string or null <= 70 characters
attribute47
string or null <= 70 characters
attribute48
string or null <= 70 characters
attribute49
string or null <= 70 characters
attribute50
string or null <= 70 characters
attribute51
string or null <= 70 characters
attribute52
string or null <= 70 characters
attribute53
string or null <= 70 characters
attribute54
string or null <= 70 characters
attribute55
string or null <= 70 characters
attribute56
string or null <= 70 characters
attribute57
string or null <= 70 characters
attribute58
string or null <= 70 characters
attribute59
string or null <= 70 characters
attribute60
string or null <= 70 characters
attribute61
string or null <= 70 characters
attribute62
string or null <= 70 characters
attribute63
string or null <= 70 characters
attribute64
string or null <= 70 characters
attribute65
string or null <= 70 characters
attribute66
string or null <= 70 characters
attribute67
string or null <= 70 characters
attribute68
string or null <= 70 characters
attribute69
string or null <= 70 characters
attribute70
string or null <= 70 characters
attribute71
string or null <= 70 characters
attribute72
string or null <= 70 characters
attribute73
string or null <= 70 characters
attribute74
string or null <= 70 characters
attribute75
string or null <= 70 characters
attribute76
string or null <= 70 characters
attribute77
string or null <= 70 characters
attribute78
string or null <= 70 characters
attribute79
string or null <= 70 characters
attribute80
string or null <= 70 characters
attribute81
string or null <= 70 characters
attribute82
string or null <= 70 characters
attribute83
string or null <= 70 characters
attribute84
string or null <= 70 characters
attribute85
string or null <= 70 characters
attribute86
string or null <= 70 characters
attribute87
string or null <= 70 characters
attribute88
string or null <= 70 characters
attribute89
string or null <= 70 characters
attribute90
string or null <= 70 characters
attribute91
string or null <= 70 characters
attribute92
string or null <= 70 characters
attribute93
string or null <= 70 characters
attribute94
string or null <= 70 characters
attribute95
string or null <= 70 characters
attribute96
string or null <= 70 characters
attribute97
string or null <= 70 characters
attribute98
string or null <= 70 characters
attribute99
string or null <= 70 characters
attribute100
string or null <= 70 characters
calculatedResultSignificantValue
number or null
calculationGridId
integer
Array of objects
Array
alertMessage
string
alertType
string
Possible values: "CRITICAL" "RED" "YELLOW"
cssProperties
string
displayOptions
integer
excludeFromExport
boolean
formatType
string
Possible values: "NUMERIC" "NUMERIC_LONG" "MONEY" "PERCENT" "TEXT" "MONEY_EUR" "MONEY_USD" "MONEY_GBP" "MONEY_JPY" "MONEY_CHF" "MONEY_PLN" "DATETIME" "DATE" "INTEGER" "LINK" "COMPLEX" "SPARKLINE"
labelTranslations
string
overridable
boolean
overridden
boolean
overrideAllowEmpty
boolean
overrideValueOptions
Array of any
result
object
resultDescription
string
resultGroup
string
resultLabel
string
resultName
string
resultType
string
suffix
string
userGroup
string
warnings
Array of strings
comments
string or null <= 255 characters
completeResultsAvailable
boolean
createDate
string <date-time>
createdBy
integer
itemExtensions
object or null
key1
string
key2
string
key3
string
key4
string
key5
string
key6
string
label
string or null <= 255 characters
lastUpdateBy
integer
lastUpdateDate
string <date-time>
manualEditUser
integer or null
manualEditVersion
integer
manualOverrides
string or null
manualResultSignificantValue
number or null
name
string
previousSignificantValue
number or null
resultSignificantValue
number or null
significantValueChange
number or null
significantValueChangePct
number or null
tableId
integer or null
typedId
string
version
integer
warnings
string or null
workStatus
string or null <= 15 characters
operationType
string
textMatchStyle
string
Responses
200

OK

Response Schema: application/json
object
node
string
Array of objects (CalculationGridItem6Key)
Array
alerts
string or null
Array of objects
allowedOverrides
string or null <= 1300 characters
attribute1
string or null <= 70 characters
attribute2
string or null <= 70 characters
attribute3
string or null <= 70 characters
attribute4
string or null <= 70 characters
attribute5
string or null <= 70 characters
attribute6
string or null <= 70 characters
attribute7
string or null <= 70 characters
attribute8
string or null <= 70 characters
attribute9
string or null <= 70 characters
attribute10
string or null <= 70 characters
attribute11
string or null <= 70 characters
attribute12
string or null <= 70 characters
attribute13
string or null <= 70 characters
attribute14
string or null <= 70 characters
attribute15
string or null <= 70 characters
attribute16
string or null <= 70 characters
attribute17
string or null <= 70 characters
attribute18
string or null <= 70 characters
attribute19
string or null <= 70 characters
attribute20
string or null <= 70 characters
attribute21
string or null <= 70 characters
attribute22
string or null <= 70 characters
attribute23
string or null <= 70 characters
attribute24
string or null <= 70 characters
attribute25
string or null <= 70 characters
attribute26
string or null <= 70 characters
attribute27
string or null <= 70 characters
attribute28
string or null <= 70 characters
attribute29
string or null <= 70 characters
attribute30
string or null <= 70 characters
attribute31
string or null <= 70 characters
attribute32
string or null <= 70 characters
attribute33
string or null <= 70 characters
attribute34
string or null <= 70 characters
attribute35
string or null <= 70 characters
attribute36
string or null <= 70 characters
attribute37
string or null <= 70 characters
attribute38
string or null <= 70 characters
attribute39
string or null <= 70 characters
attribute40
string or null <= 70 characters
attribute41
string or null <= 70 characters
attribute42
string or null <= 70 characters
attribute43
string or null <= 70 characters
attribute44
string or null <= 70 characters
attribute45
string or null <= 70 characters
attribute46
string or null <= 70 characters
attribute47
string or null <= 70 characters
attribute48
string or null <= 70 characters
attribute49
string or null <= 70 characters
attribute50
string or null <= 70 characters
attribute51
string or null <= 70 characters
attribute52
string or null <= 70 characters
attribute53
string or null <= 70 characters
attribute54
string or null <= 70 characters
attribute55
string or null <= 70 characters
attribute56
string or null <= 70 characters
attribute57
string or null <= 70 characters
attribute58
string or null <= 70 characters
attribute59
string or null <= 70 characters
attribute60
string or null <= 70 characters
attribute61
string or null <= 70 characters
attribute62
string or null <= 70 characters
attribute63
string or null <= 70 characters
attribute64
string or null <= 70 characters
attribute65
string or null <= 70 characters
attribute66
string or null <= 70 characters
attribute67
string or null <= 70 characters
attribute68
string or null <= 70 characters
attribute69
string or null <= 70 characters
attribute70
string or null <= 70 characters
attribute71
string or null <= 70 characters
attribute72
string or null <= 70 characters
attribute73
string or null <= 70 characters
attribute74
string or null <= 70 characters
attribute75
string or null <= 70 characters
attribute76
string or null <= 70 characters
attribute77
string or null <= 70 characters
attribute78
string or null <= 70 characters
attribute79
string or null <= 70 characters
attribute80
string or null <= 70 characters
attribute81
string or null <= 70 characters
attribute82
string or null <= 70 characters
attribute83
string or null <= 70 characters
attribute84
string or null <= 70 characters
attribute85
string or null <= 70 characters
attribute86
string or null <= 70 characters
attribute87
string or null <= 70 characters
attribute88
string or null <= 70 characters
attribute89
string or null <= 70 characters
attribute90
string or null <= 70 characters
attribute91
string or null <= 70 characters
attribute92
string or null <= 70 characters
attribute93
string or null <= 70 characters
attribute94
string or null <= 70 characters
attribute95
string or null <= 70 characters
attribute96
string or null <= 70 characters
attribute97
string or null <= 70 characters
attribute98
string or null <= 70 characters
attribute99
string or null <= 70 characters
attribute100
string or null <= 70 characters
calculatedResultSignificantValue
number or null
calculationGridId
integer
Array of objects
comments
string or null <= 255 characters
completeResultsAvailable
boolean
createDate
string <date-time>
createdBy
integer
itemExtensions
object or null
key1
string
key2
string
key3
string
key4
string
key5
string
key6
string
label
string or null <= 255 characters
lastUpdateBy
integer
lastUpdateDate
string <date-time>
manualEditUser
integer or null
manualEditVersion
integer
manualOverrides
string or null
manualResultSignificantValue
number or null
name
string
previousSignificantValue
number or null
resultSignificantValue
number or null
significantValueChange
number or null
significantValueChangePct
number or null
tableId
integer or null
typedId
string
version
integer
warnings
string or null
workStatus
string or null <= 15 characters
status
integer
Request samples
application/json
{
  • "data": {
    • "typedId": "4.CGI6",
    • "key6": "newKeyValue"
    },
  • "oldValues": {
    • "version": 3,
    • "typedId": "4.CGI6",
    • "calculationGridId": 7,
    • "manualEditVersion": 0,
    • "name": "2 | q | 2 | aa | w | b",
    • "createDate": "2022-11-30T12:45:54",
    • "createdBy": 2147490187,
    • "lastUpdateDate": "2022-11-30T12:45:54",
    • "lastUpdateBy": 2147490187,
    • "key1": "2",
    • "key2": "q",
    • "key3": "2",
    • "key4": "aa",
    • "key5": "w",
    • "key6": "b",
    • "completeResultsAvailable": false,
    • "itemExtensions": { }
    },
  • "operationType": "update",
  • "textMatchStyle": "exact"
}
Response samples
application/json
{
  • "response": {
    • "node": "e2e-tabasco-node",
    • "data": [
      • {
        • "version": 4,
        • "typedId": "4.CGI6",
        • "label": null,
        • "comments": null,
        • "workStatus": null,
        • "alerts": null,
        • "warnings": null,
        • "allowedOverrides": null,
        • "manualOverrides": null,
        • "resultSignificantValue": null,
        • "previousSignificantValue": null,
        • "significantValueChange": null,
        • "significantValueChangePct": null,
        • "manualResultSignificantValue": null,
        • "calculatedResultSignificantValue": null,
        • "calculationGridId": 7,
        • "manualEditVersion": 0,
        • "tableId": null,
        • "name": "2 | q | 2 | aa | w | newKeyValue",
        • "createDate": "2022-11-30T12:45:54",
        • "createdBy": 2147490187,
        • "lastUpdateDate": "2022-11-30T14:52:47",
        • "lastUpdateBy": 2147490187,
        • "attribute1": null,
        • "attribute2": null,
        • "attribute3": null,
        • "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,
        • "attribute31": null,
        • "attribute32": null,
        • "attribute33": null,
        • "attribute34": null,
        • "attribute35": null,
        • "attribute36": null,
        • "attribute37": null,
        • "attribute38": null,
        • "attribute39": null,
        • "attribute40": null,
        • "attribute41": null,
        • "attribute42": null,
        • "attribute43": null,
        • "attribute44": null,
        • "attribute45": null,
        • "attribute46": null,
        • "attribute47": null,
        • "attribute48": null,
        • "attribute49": null,
        • "attribute50": null,
        • "attribute51": null,
        • "attribute52": null,
        • "attribute53": null,
        • "attribute54": null,
        • "attribute55": null,
        • "attribute56": null,
        • "attribute57": null,
        • "attribute58": null,
        • "attribute59": null,
        • "attribute60": null,
        • "attribute61": null,
        • "attribute62": null,
        • "attribute63": null,
        • "attribute64": null,
        • "attribute65": null,
        • "attribute66": null,
        • "attribute67": null,
        • "attribute68": null,
        • "attribute69": null,
        • "attribute70": null,
        • "attribute71": null,
        • "attribute72": null,
        • "attribute73": null,
        • "attribute74": null,
        • "attribute75": null,
        • "attribute76": null,
        • "attribute77": null,
        • "attribute78": null,
        • "attribute79": null,
        • "attribute80": null,
        • "attribute81": null,
        • "attribute82": null,
        • "attribute83": null,
        • "attribute84": null,
        • "attribute85": null,
        • "attribute86": null,
        • "attribute87": null,
        • "attribute88": null,
        • "attribute89": null,
        • "attribute90": null,
        • "attribute91": null,
        • "attribute92": null,
        • "attribute93": null,
        • "attribute94": null,
        • "attribute95": null,
        • "attribute96": null,
        • "attribute97": null,
        • "attribute98": null,
        • "attribute99": null,
        • "attribute100": null,
        • "manualEditUser": null,
        • "key1": "2",
        • "key2": "q",
        • "key3": "2",
        • "key4": "aa",
        • "key5": "w",
        • "key6": "newKeyValue",
        • "completeResultsAvailable": false,
        • "itemExtensions": { }
        }
      ],
    • "status": 0
    }
}