List Calculation Grid Items

post/fetch/CGI{keyNumber}

Retrieves all Calculation Grid Items for the specified Calculation Grid.

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

Use CGI1..CGI6 in the path, where numbers from 1 to 6 refer to Calculation Grid Item keys.

Possible values: "1" "2" "3" "4" "5" "6"
Request Body schema: application/json
endRow
integer
oldValues
object or null
operationType
string
startRow
integer
textMatchStyle
string
required
object
calculationGridId
required
string

id of the Calculation Grid you want to retrieve Calculation Grid Items for.

Responses
200

OK

Response Schema: application/json
object
node
string
startRow
integer
Array of CalculationGridItem1Key (object) or CalculationGridItem2Key (object) or CalculationGridItem3Key (object) or CalculationGridItem4Key (object) or CalculationGridItem5Key (object) or CalculationGridItem6Key (object)
Array
Any of:

The type code is CGI1.

alerts
string
Array of objects
allowedOverrides
string <= 1300 characters
attribute1
string <= 70 characters
attribute2
string <= 70 characters
attribute3
string <= 70 characters
attribute4
string <= 70 characters
attribute5
string <= 70 characters
attribute6
string <= 70 characters
attribute7
string <= 70 characters
attribute8
string <= 70 characters
attribute9
string <= 70 characters
attribute10
string <= 70 characters
attribute11
string <= 70 characters
attribute12
string <= 70 characters
attribute13
string <= 70 characters
attribute14
string <= 70 characters
attribute15
string <= 70 characters
attribute16
string <= 70 characters
attribute17
string <= 70 characters
attribute18
string <= 70 characters
attribute19
string <= 70 characters
attribute20
string <= 70 characters
attribute21
string <= 70 characters
attribute22
string <= 70 characters
attribute23
string <= 70 characters
attribute24
string <= 70 characters
attribute25
string <= 70 characters
attribute26
string <= 70 characters
attribute27
string <= 70 characters
attribute28
string <= 70 characters
attribute29
string <= 70 characters
attribute30
string <= 70 characters
attribute31
string <= 70 characters
attribute32
string <= 70 characters
attribute33
string <= 70 characters
attribute34
string <= 70 characters
attribute35
string <= 70 characters
attribute36
string <= 70 characters
attribute37
string <= 70 characters
attribute38
string <= 70 characters
attribute39
string <= 70 characters
attribute40
string <= 70 characters
attribute41
string <= 70 characters
attribute42
string <= 70 characters
attribute43
string <= 70 characters
attribute44
string <= 70 characters
attribute45
string <= 70 characters
attribute46
string <= 70 characters
attribute47
string <= 70 characters
attribute48
string <= 70 characters
attribute49
string <= 70 characters
attribute50
string <= 70 characters
attribute51
string <= 70 characters
attribute52
string <= 70 characters
attribute53
string <= 70 characters
attribute54
string <= 70 characters
attribute55
string <= 70 characters
attribute56
string <= 70 characters
attribute57
string <= 70 characters
attribute58
string <= 70 characters
attribute59
string <= 70 characters
attribute60
string <= 70 characters
attribute61
string <= 70 characters
attribute62
string <= 70 characters
attribute63
string <= 70 characters
attribute64
string <= 70 characters
attribute65
string <= 70 characters
attribute66
string <= 70 characters
attribute67
string <= 70 characters
attribute68
string <= 70 characters
attribute69
string <= 70 characters
attribute70
string <= 70 characters
attribute71
string <= 70 characters
attribute72
string <= 70 characters
attribute73
string <= 70 characters
attribute74
string <= 70 characters
attribute75
string <= 70 characters
attribute76
string <= 70 characters
attribute77
string <= 70 characters
attribute78
string <= 70 characters
attribute79
string <= 70 characters
attribute80
string <= 70 characters
attribute81
string <= 70 characters
attribute82
string <= 70 characters
attribute83
string <= 70 characters
attribute84
string <= 70 characters
attribute85
string <= 70 characters
attribute86
string <= 70 characters
attribute87
string <= 70 characters
attribute88
string <= 70 characters
attribute89
string <= 70 characters
attribute90
string <= 70 characters
attribute91
string <= 70 characters
attribute92
string <= 70 characters
attribute93
string <= 70 characters
attribute94
string <= 70 characters
attribute95
string <= 70 characters
attribute96
string <= 70 characters
attribute97
string <= 70 characters
attribute98
string <= 70 characters
attribute99
string <= 70 characters
attribute100
string <= 70 characters
calculatedResultSignificantValue
number
calculationGridId
integer
Array of objects
comments
string <= 255 characters
completeResultsAvailable
string <= 1 characters
createDate
string <date-time>
createdBy
integer
itemExtensions
string
key1
string <= 255 characters
label
string <= 255 characters
lastUpdateBy
integer
lastUpdateDate
string <date-time>
manualEditUser
integer
manualEditVersion
integer
manualOverrides
string
manualResultSignificantValue
number
name
string
previousSignificantValue
number
resultSignificantValue
number
significantValueChange
number
significantValueChangePct
number
tableId
integer
typedId
string
version
integer
warnings
string
workStatus
string <= 15 characters
endRow
integer
totalRows
integer
status
integer
Request samples
application/json
{
  • "endRow": 300,
  • "oldValues": null,
  • "operationType": "fetch",
  • "startRow": 0,
  • "textMatchStyle": "exact",
  • "data": {
    • "calculationGridId": "7"
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "string",
    • "startRow": 0,
    • "data": [
      • {
        • "alerts": "string",
        • "allCalculationResults": [
          ],
        • "allowedOverrides": "string",
        • "attribute1": "string",
        • "attribute2": "string",
        • "attribute3": "string",
        • "attribute4": "string",
        • "attribute5": "string",
        • "attribute6": "string",
        • "attribute7": "string",
        • "attribute8": "string",
        • "attribute9": "string",
        • "attribute10": "string",
        • "attribute11": "string",
        • "attribute12": "string",
        • "attribute13": "string",
        • "attribute14": "string",
        • "attribute15": "string",
        • "attribute16": "string",
        • "attribute17": "string",
        • "attribute18": "string",
        • "attribute19": "string",
        • "attribute20": "string",
        • "attribute21": "string",
        • "attribute22": "string",
        • "attribute23": "string",
        • "attribute24": "string",
        • "attribute25": "string",
        • "attribute26": "string",
        • "attribute27": "string",
        • "attribute28": "string",
        • "attribute29": "string",
        • "attribute30": "string",
        • "attribute31": "string",
        • "attribute32": "string",
        • "attribute33": "string",
        • "attribute34": "string",
        • "attribute35": "string",
        • "attribute36": "string",
        • "attribute37": "string",
        • "attribute38": "string",
        • "attribute39": "string",
        • "attribute40": "string",
        • "attribute41": "string",
        • "attribute42": "string",
        • "attribute43": "string",
        • "attribute44": "string",
        • "attribute45": "string",
        • "attribute46": "string",
        • "attribute47": "string",
        • "attribute48": "string",
        • "attribute49": "string",
        • "attribute50": "string",
        • "attribute51": "string",
        • "attribute52": "string",
        • "attribute53": "string",
        • "attribute54": "string",
        • "attribute55": "string",
        • "attribute56": "string",
        • "attribute57": "string",
        • "attribute58": "string",
        • "attribute59": "string",
        • "attribute60": "string",
        • "attribute61": "string",
        • "attribute62": "string",
        • "attribute63": "string",
        • "attribute64": "string",
        • "attribute65": "string",
        • "attribute66": "string",
        • "attribute67": "string",
        • "attribute68": "string",
        • "attribute69": "string",
        • "attribute70": "string",
        • "attribute71": "string",
        • "attribute72": "string",
        • "attribute73": "string",
        • "attribute74": "string",
        • "attribute75": "string",
        • "attribute76": "string",
        • "attribute77": "string",
        • "attribute78": "string",
        • "attribute79": "string",
        • "attribute80": "string",
        • "attribute81": "string",
        • "attribute82": "string",
        • "attribute83": "string",
        • "attribute84": "string",
        • "attribute85": "string",
        • "attribute86": "string",
        • "attribute87": "string",
        • "attribute88": "string",
        • "attribute89": "string",
        • "attribute90": "string",
        • "attribute91": "string",
        • "attribute92": "string",
        • "attribute93": "string",
        • "attribute94": "string",
        • "attribute95": "string",
        • "attribute96": "string",
        • "attribute97": "string",
        • "attribute98": "string",
        • "attribute99": "string",
        • "attribute100": "string",
        • "calculatedResultSignificantValue": 0,
        • "calculationGridId": 0,
        • "calculationResults": [
          ],
        • "comments": "string",
        • "completeResultsAvailable": "s",
        • "createDate": "2019-08-24T14:15:22Z",
        • "createdBy": 0,
        • "itemExtensions": "string",
        • "key1": "string",
        • "label": "string",
        • "lastUpdateBy": 0,
        • "lastUpdateDate": "2019-08-24T14:15:22Z",
        • "manualEditUser": 0,
        • "manualEditVersion": 0,
        • "manualOverrides": "string",
        • "manualResultSignificantValue": 0,
        • "name": "string",
        • "previousSignificantValue": 0,
        • "resultSignificantValue": 0,
        • "significantValueChange": 0,
        • "significantValueChangePct": 0,
        • "tableId": 0,
        • "typedId": "string",
        • "version": 0,
        • "warnings": "string",
        • "workStatus": "string"
        }
      ],
    • "endRow": 0,
    • "totalRows": 0,
    • "status": 0
    }
}