---
title: "List All Lookup Tables"
method: POST
path: "/lookuptablemanager.fetch"
tags: ["Lookup Tables / Company Parameters"]
---

# List All Lookup Tables

`POST /lookuptablemanager.fetch`

Retrieves all Lookup Tables / Company Parameter tables.<p>
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`).

## Request body

- object
  - `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.
  - `oldValues` unknown
  - `operationType` string
  - `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
  - `data` object
    - `_constructor` string
    - `operator` string
    - `criteria` object[]
      - `fieldName` string
      - `operator` 'equals' | 'iEquals' | 'notEqual' | 'iNotEqual' | 'isNull' | 'notNull' | 'contains' | 'iContains' | 'containsPattern' | 'iContainsPattern' | 'notContains' | 'iNotContains' | 'startsWith' | 'iStartsWith' | 'notStartsWith' | 'iNotStartsWith' | 'endsWith' | 'iEndsWith' | 'notEndsWith' | 'iNotEndsWith' | 'iBetween' | 'iBetweenInclusive' | 'inSet' | 'notInSet' — Specify an operator of the filter criteria.
      - `value` string
  - `sortBy` unknown[]
    - unknown

## Response `200`

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.

- object
  - `response` object
    - `node` string
    - `csrfToken` string
    - `startRow` number
    - `data` object[]
      - `version` number
      - `typedId` string
      - `uniqueName` string
      - `label` string
      - `validAfter` string
      - `status` string
      - `simulationSet` unknown
      - `type` string
      - `valueType` string
      - `nodeId` unknown
      - `userGroupEdit` unknown
      - `userGroupViewDetails` unknown
      - `hideWarnings` boolean
      - `formatType` unknown
      - `lastUpdateByName` string
      - `createdByName` string
      - `numberOfKeyFields` number
      - `createDate` string
      - `createdBy` number
      - `lastUpdateDate` string
      - `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

---

[API](https://skmtc.net/pricefx/apis/the-pricefx-backend-api.md) · [All operations](https://skmtc.net/pricefx/apis/the-pricefx-backend-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/pricefx/the-pricefx-backend-api/versions/0850b5d6be73/schema)