Upsert a Lookup Table Value

post/lookuptablemanager.integrate/{tableId}

Creates a new Company Parameter record (LookupTableValue or MatrixLookupTableValue) or updates an existing record (if the specified name of the record already exists).

Required Permission Roles with the Required Permission
LOOKUPTABLEVALUES_INTEGRATE Data Integration (DATAINTEGRATION)
Securitybasic or X-PriceFx-jwt
Request
path Parameters
tableId
required
string

Enter the ID of the table. The ID can be retrieved using the /lookuptablemanager.fetch method.

Request Body schema: application/json
required
object
name
required
string non-empty
value
required
string non-empty
Responses
200

OK

Response Schema: application/json
required
object
node
required
string non-empty
required
Array of objects non-empty unique
Array (non-empty)
version
required
number
typedId
required
string non-empty
name
required
string non-empty
value
required
string non-empty
lowerBound
any
upperBound
any
lastUpdateByName
required
string non-empty
createdByName
required
string non-empty
tableId
required
number
type
required
string non-empty
valueType
required
string non-empty
rawValue
required
string non-empty
createDate
required
string non-empty
createdBy
required
number
lastUpdateDate
required
string non-empty
lastUpdateBy
required
number
status
required
number
Request samples
application/json
{
  • "data": {
    • "name": "tofu",
    • "value": "0.05"
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "<node>",
    • "data": [
      • {
        • "version": 2,
        • "typedId": "2147489944.LTV",
        • "name": "tofu",
        • "value": "5",
        • "lowerBound": null,
        • "upperBound": null,
        • "lastUpdateByName": "admin",
        • "createdByName": "admin",
        • "tableId": 2147484027,
        • "type": "SIMPLE",
        • "valueType": "STRING",
        • "rawValue": "5",
        • "createDate": "2021-10-01T12:27:48",
        • "createdBy": 2147490696,
        • "lastUpdateDate": "2021-10-01T12:27:48",
        • "lastUpdateBy": 2147490696
        }
      ],
    • "status": 0
    }
}