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

# List All Lookup Table Values

`POST /lookuptablemanager.fetch/{tableId}`

Retrieves all Company Parameter records for the specified Company Parameter table (LookupTable).<p>
Export the table to the Excel file (XLSX) using the `output=xls` URL query parameter. When exporting to the file, specify fields (within the `resultFields` property) you want to include in the output table.<p>
Example:
```json
{
   "data":{
      "criteria":[

      ],
      "operator":"and"
   },
   "resultFields":[
      "key1",
      "key2",
      "key3",
      "attribute1",
      "attribute2",
      "attribute3"
   ],
   "valueFields":[

   ]
}
```

## Query parameters

- `output` 'json' | 'xls' | 'csv' | 'pdf'
- `useColumnNames` 'true' | 'false'

## 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
  - `sortBy` object[]

## Response `200`

OK

- object
  - `response` object
    - `status` number
    - `startRow` number
    - `node` string
    - `csrfToken` string
    - `data` object[]
      - `version` number, required
      - `typedId` string, required
      - `name` string, required
      - `value` string, required
      - `lowerBound` unknown
      - `upperBound` unknown
      - `lastUpdateByName` string, required
      - `createdByName` string, required
      - `tableId` unknown
      - `valueType` string, required
      - `type` string, required
      - `rawValue` string, required
      - `createDate` string, required
      - `createdBy` number, required
      - `lastUpdateDate` string, required
      - `lastUpdateBy` number, required
    - `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.

---

[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)