# Error when trying to update via API

**URL:** https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975
**Category:** APIs
**Created:** [July 1, 2025, 2:04pm UTC](https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975 "2025-07-01T14:04:37Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![dougmt](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@dougmt](https://community.nocodb.com/u/dougmt)
#### Post date: [July 1, 2025, 2:04pm UTC](https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975/1 "2025-07-01T14:04:37Z")

</div>

After updating my self-hosted NocoDB instance to version `0.263.8`, I’m getting the following error when trying to perform a batch update via the API:

“error”: “DATABASE\_ERROR”,  
“message”: “Invalid data type or value for column ‘unknown’.”,  
“code”: “22P02”

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/1bd7f446c16dc8888c1ee14b2fe39ad5ede7f3cf.png)

**Note:**  
I’ve already tried sending all the fields of the table.  
The `establishment_id` field is the primary key of the table.

---

<div class="post-metadata">

### Author: ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [July 2, 2025, 5:04am UTC](https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975/2 "2025-07-02T05:04:18Z")

</div>

@dougmt Welcome to NocoDB community!

To help you out, we would need more details about your schema. If its feasible, send us entire payload when it fails.

cc @fendy

---

<div class="post-metadata">

### Author: ![dougmt](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@dougmt](https://community.nocodb.com/u/dougmt)
#### Post date: [July 15, 2025, 11:46am UTC](https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975/3 "2025-07-15T11:46:54Z")

</div>

![Screenshot_2](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/e86518bacc477a417ed5f734282b184bddca1e15.png)

Even when testing through Swagger or Postman, the error persists.  
Attached, I’m sending two images to show the table schema and the test.

Note: Even after recreating another table, the error remains the same.

---

<div class="post-metadata">

### Author: ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [July 21, 2025, 4:55am UTC](https://community.nocodb.com/t/error-when-trying-to-update-via-api/1975/5 "2025-07-21T04:55:19Z")

</div>

Worked fine when I tried it out. We would need more details about your setup to help with this. Are you connecting to external data source?

 ![Screenshot_2025-07-21_at_10_22_48 AM](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/5d69322e9e148f6a2195c0796ba7becd6e505e44.png)