List All Lookup Tables

post/lookuptablemanager.fetch

Retrieves all Lookup Tables / Company Parameter tables.

You can use this endpoint to retrieve the table ID. The tableId can be used in other endpoint URLs that work with Company Parameter Values. Find the table ID in the response under id parameter (e.g. "id": 2147484027).

Securitybasic or X-PriceFx-jwt
Request
Request Body schema:

You can specify the start and end row to limit the number of retrieved Lookup Tables / Company Parameters.

endRow
number
Default: 300

The number of the end row that defines the end of the result set's returned objects. Use this parameter if you want to implement paging for results.

oldValues
any
operationType
string non-empty
startRow
number

The number of the first row that defines the start of the result set's returned objects. Use this parameter if you want to implement paging for results.

textMatchStyle
string non-empty
object
_constructor
string non-empty
operator
string non-empty
Array of objects non-empty unique
Array (non-empty)
fieldName
string non-empty
operator
string non-empty

Specify an operator of the filter criteria.

Possible values: "equals" "iEquals" "notEqual" "iNotEqual" "isNull" "notNull" "contains" "iContains" "containsPattern" "iContainsPattern" "notContains" "iNotContains" "startsWith" "iStartsWith" "notStartsWith" "iNotStartsWith" "endsWith" "iEndsWith" "notEndsWith" "iNotEndsWith" … 4 more
value
string non-empty
sortBy
Array of any
Responses
200

OK

Returns the Company Parameter table / Lookup table fields. The name property is the same as uniqueName if the owner is null. If the owner field is non-null, then the name will be the name of the table (DMT or LT) in the context of the owner.

Response Schema: application/json
object
node
string non-empty
csrfToken
string non-empty
startRow
number
Array of objects non-empty unique
Array (non-empty)
version
number
typedId
string non-empty
uniqueName
string non-empty
label
string non-empty
validAfter
string non-empty
status
string non-empty
simulationSet
any
type
string non-empty
valueType
string non-empty
nodeId
any
userGroupEdit
any
userGroupViewDetails
any
hideWarnings
boolean
formatType
any
lastUpdateByName
string non-empty
createdByName
string non-empty
numberOfKeyFields
number
createDate
string non-empty
createdBy
number
lastUpdateDate
string non-empty
lastUpdateBy
number
id
number
isPlasma
boolean
name
string
endRow
number

The number of the end row that defines the end of the result set's returned objects. Use this parameter if you want to implement paging for results.

totalRows
number
status
number
Request samples
{
  • "endRow": 30,
  • "oldValues": null,
  • "operationType": "fetch",
  • "startRow": 0,
  • "textMatchStyle": "exact",
  • "data": {
    • "_constructor": "AdvancedCriteria",
    • "operator": "and",
    • "criteria": [
      • {
        • "fieldName": "label",
        • "operator": "iEquals",
        • "value": "matrix"
        }
      ]
    },
  • "sortBy": [
    • "uniqueName"
    ]
}
Response samples
application/json
{
  • "response": {
    • "node": "<node>",
    • "csrfToken": "<token>",
    • "startRow": 0,
    • "data": [
      • {
        • "version": 2,
        • "typedId": "2147484027.LT",
        • "uniqueName": "test",
        • "label": "Test2",
        • "validAfter": "2021-09-29",
        • "status": "ACTIVE",
        • "simulationSet": null,
        • "type": "SIMPLE",
        • "valueType": "STRING",
        • "nodeId": null,
        • "userGroupEdit": null,
        • "userGroupViewDetails": null,
        • "hideWarnings": false,
        • "formatType": null,
        • "lastUpdateByName": "admin",
        • "createdByName": "admin",
        • "numberOfKeyFields": 1,
        • "createDate": "2021-09-30T14:43:25",
        • "createdBy": 2147490696,
        • "lastUpdateDate": "2021-10-01T12:05:34",
        • "lastUpdateBy": 2147490696,
        • "id": 2147484027,
        • "isPlasma": false,
        • "name": "test"
        },
      • {
        • "version": 0,
        • "typedId": "2147484036.LT",
        • "uniqueName": "matrix",
        • "label": "matrix",
        • "validAfter": "2021-10-05",
        • "status": "ACTIVE",
        • "simulationSet": null,
        • "type": "MATRIX",
        • "valueType": "MATRIX",
        • "nodeId": null,
        • "userGroupEdit": null,
        • "userGroupViewDetails": null,
        • "hideWarnings": false,
        • "formatType": null,
        • "lastUpdateByName": "admin",
        • "createdByName": "admin",
        • "numberOfKeyFields": 1,
        • "createDate": "2021-10-06T10:53:26",
        • "createdBy": 2147490696,
        • "lastUpdateDate": "2021-10-06T10:53:26",
        • "lastUpdateBy": 2147490696,
        • "id": 2147484036,
        • "isPlasma": false,
        • "name": "matrix"
        }
      ],
    • "endRow": 2,
    • "totalRows": 2,
    • "status": 0
    }
}