Mass Edit

post/lookuptablemanager.massedit/{tableId}

Performs a mass edit action on LookupTableValue or MatrixLookupTableValue objects. Updates LTV or MLTV columns to specified values.

Required Permission Roles with the Required Permission
LOOKUPTABLE_UPDATE Administer Price Parameters (PB_PARAMETERS), Administer Plasma (PLASMA)
Securitybasic or X-PriceFx-jwt
Request
path Parameters
tableId
required
string

The ID of the Lookup Table whose values you want to update.

Request Body schema: application/json
required
object
required
object
_constructor
required
string non-empty
operator
required
string non-empty
required
Array of objects non-empty unique
Array (non-empty)
fieldName
required
string non-empty
operator
required
string non-empty
value
Array of strings

TypedId of rows whose columns you want to update.

_constructor
required
string non-empty
required
Array of objects non-empty unique
Array (non-empty)
fieldName
required
string non-empty
massEditOperator
required
string non-empty

Can be either one of these valid operators: +, -, *. If omitted, the provided value is set (= operator). Otherwise the specified operation is applied.

fieldValue
required
string non-empty

The new value of the field (column).

precision
any
Responses
200

OK - The response contains the number of modifed objects.

Response Schema: application/json
object
node
string non-empty
data
Array of strings

A single item array with a string that represents the number of rows changed.

status
number

A status code.

Request samples
application/json
{
  • "data": {
    • "filterCriteria": {
      • "_constructor": "AdvancedCriteria",
      • "operator": "and",
      • "criteria": [
        • {
          }
        ]
      },
    • "massEditRecords": [
      • {
        • "fieldName": "attribute1",
        • "massEditOperator": "=",
        • "fieldValue": "1",
        • "precision": null
        },
      • {
        • "fieldName": "attribute2",
        • "massEditOperator": "=",
        • "fieldValue": "2",
        • "precision": null
        },
      • {
        • "fieldName": "attribute3",
        • "massEditOperator": "=",
        • "fieldValue": "3",
        • "precision": null
        }
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "<node>",
    • "data": [
      • "3"
      ],
    • "status": 0
    }
}