Mass Delete Lookup Table Values

post/lookuptablemanager.delete/{tableId}/batch

Deletes records from the specified Company Parameters table (LookupTable). A filter can be applied (see the request example).

Required Permission Roles with the Required Permission
LOOKUPTABLE_REMOVE Administer Price Parameters (PB_PARAMETERS), Administer Plasma (PLASMA)
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.

query Parameters
dataLocale
string

Specifies localization of data.

Example: dataLocale=en
Request Body schema: application/json
object
object
_constructor
string
operator
string
Array of objects
Array
fieldName
string
operator
string
value
integer
Responses
200

OK

Response Schema: application/json
required
object
node
required
string non-empty
data
required
Array of any non-empty unique

The number of deleted records.

status
required
number
Request samples
application/json
{
  • "data": {
    • "filterCriteria": {
      • "_constructor": "AdvancedCriteria",
      • "operator": "and",
      • "criteria": [
        • {
          }
        ]
      }
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "<node>",
    • "data": [
      • {
        • "version": 12,
        • "typedId": "2147497641.MLTV",
        • "lastUpdateByName": "admin",
        • "createdByName": "admin",
        • "tableId": 2147484036,
        • "type": "MATRIX",
        • "valueType": "MATRIX",
        • "lookupTableTypedId": "2147484036.LT",
        • "createDate": "2021-10-06T10:53:52",
        • "createdBy": 2147490696,
        • "lastUpdateDate": "2021-10-06T14:37:00",
        • "lastUpdateBy": 2147490696,
        • "attribute1": "250",
        • "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,
        • "name": "matrixValue"
        }
      ],
    • "status": 0
    }
}