# Update a value in a single column using the API \[May 03\]

**URL:** <https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412 "2022-11-03T09:30:09Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/1 "2022-11-03T09:30:09Z")

</div>

> 🙋‍♂️ **Shard** _asked_

## How do I update a value in a single column using the API? DB Query equivalent: `UPDATE table_name SET "column_B" = true WHERE "column_A" = "example_value"`

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/2 "2022-11-03T09:30:10Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### u can use bulk update

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/3 "2022-11-03T09:30:11Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### with where clause specfied

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/4 "2022-11-03T09:30:13Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### How would a call like that look? or where can I see some examples?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/5 "2022-11-03T09:30:14Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### curl -X ‘PATCH’ \

#### [http://localhost:8080/api/v1/db/data/bulk/noco/sakila/testApi/all?where=(Id,gt,7)](http://localhost:8080/api/v1/db/data/bulk/noco/sakila/testApi/all?where=(Id,gt,7)) \

#### -H “Content-Type: application/json” \

#### -H ‘accept: application/json’ \

#### -H ‘xc-auth: ’ \

#### –data ‘{ “Title”: “Updated” }’

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/6 "2022-11-03T09:30:15Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### the url is `/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}/`

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/7 "2022-11-03T09:30:16Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### u may create a dummy table n use swagger ui to try

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/8 "2022-11-03T09:30:17Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Using that I get: `invalid input syntax for type integer: "all"`

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/9 "2022-11-03T09:30:18Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### nevermind, I figured it out 🙂

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/10 "2022-11-03T09:30:19Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Thanks!

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/update-a-value-in-a-single-column-using-the-api-may-03/412/11 "2022-11-03T09:30:20Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/970618616011718658)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)