# Updating the table with many to many relations \[May 18\]

**URL:** <https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 9:48am UTC](https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464 "2022-11-03T09:48:57Z")\
**Posts on this page:** 6\
**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:48am UTC](https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464/1 "2022-11-03T09:48:57Z")

</div>

> 🙋‍♂️ **AK** _asked_

## I have table with relation column (many to many) and I need to clean the data from the rest api. How can I do it? I tried to make an update request (PATCH request) to the table but it’s seems like the column isn’t recognized. I tried to update it from the related table but also - column isn’t recognized. Am I’m missing something?

---

<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:48am UTC](https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464/2 "2022-11-03T09:48:59Z")

</div>

> 💁 **o1lab** _replied_

#### Please provide more details/steps on this.

#

---

<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:49am UTC](https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464/3 "2022-11-03T09:49:00Z")

</div>

> 🙋‍♂️ **AK** _replied_

#### Likw what? Let me know what info you want / need and I’ll give you 😀

#

---

<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:49am UTC](https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464/4 "2022-11-03T09:49:02Z")

</div>

> 💁 **o1lab** _replied_

#### Like steps and errors pls

#

---

<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:49am UTC](https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464/5 "2022-11-03T09:49:03Z")

</div>

> 🙋‍♂️ **AK** _replied_

#### Steps:

#### Making api request to update row and empty the data in the related column from the table have the relation column.

#### 

#### Making api request to update row and empty the data in the related column from the related table

#### (When you make relation it’s making column in the related table)

#### Tried to fetch the table to see what the name of the column to make sure I’m correct, I saw also a system column so I tried update it.

#### Errors:

#### If I will try to update only this column it will say the request data is empty (means not recognizing the column)

#### Not only the relation one, not the system one and not the one in the related table. Error codr 400. If you want me to get the exect err msg I will get it.

#

---

<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:49am UTC](https://community.nocodb.com/t/updating-the-table-with-many-to-many-relations-may-18/464/6 "2022-11-03T09:49:04Z")

</div>

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

* * *

#### 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/)