---
title: "Upsert a Lookup Table Value"
method: POST
path: "/lookuptablemanager.integrate/{tableId}"
tags: ["Lookup Tables / Company Parameters"]
---

# Upsert a Lookup Table Value

`POST /lookuptablemanager.integrate/{tableId}`

Creates a new Company Parameter record (LookupTableValue or MatrixLookupTableValue) or updates an existing record (if the specified name of the record already exists).

---

Required Permission| Roles with the Required Permission |
---------|----------|
 LOOKUPTABLEVALUES_INTEGRATE | Data Integration (`DATAINTEGRATION`)

## Request body

- object
  - `data` object, required
    - `name` string, required
    - `value` string, required

## Response `200`

OK

- object
  - `response` object, required
    - `node` string, required
    - `data` object[], required
      - `version` number, required
      - `typedId` string, required
      - `name` string, required
      - `value` string, required
      - `lowerBound` unknown
      - `upperBound` unknown
      - `lastUpdateByName` string, required
      - `createdByName` string, required
      - `tableId` number, required
      - `type` string, required
      - `valueType` string, required
      - `rawValue` string, required
      - `createDate` string, required
      - `createdBy` number, required
      - `lastUpdateDate` string, required
      - `lastUpdateBy` number, required
    - `status` number, required

---

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