# Update values into a MULTI SELECT Column..

**URL:** <https://community.hubspot.com/t/update-values-into-a-multi-select-column/128745>\
**Category:** APIs & Integrations\
**Tags:** professional\
**Created:** [March 26, 2025, 10:41pm UTC](https://community.hubspot.com/t/update-values-into-a-multi-select-column/128745 "2025-03-26T22:41:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MVaidheeswara](https://avatars.discourse-cdn.com/v4/letter/m/7ba0ec/32.png) [@MVaidheeswara](https://community.hubspot.com/u/MVaidheeswara)\
**Post date:** [March 26, 2025, 10:41pm UTC](https://community.hubspot.com/t/update-values-into-a-multi-select-column/128745/1 "2025-03-26T22:41:47Z")

</div>

I’m trying to update a multiselect column in hubDB using API.

I have been told to use the PATCH Method - unfortunately this is not working as expected. can anyone please help with the exact URL - and JSON format to use to update teh multiselect column ?

Is there a documentation available that would show how this is done ?

Note : I’m able to add rows and add selected items within the multiselect column by specifying the Multiselect list ID’s. But need to have the multiselect list populated first before I can do this.. logically.

---

<div class="post-metadata">

**Author:** ![evaldas](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/evaldas/32/69160_2.png) [@evaldas](https://community.hubspot.com/u/evaldas)\
**Post date:** [March 27, 2025, 1:45am UTC](https://community.hubspot.com/t/update-values-into-a-multi-select-column/128745/2 "2025-03-27T01:45:14Z")

</div>

Hi @MVaidheeswara,

In order to update the options for the multi-select column, you would need to make a call to the PATCH end point

`https://api.hubapi.com/cms/v3/hubdb/tables/YOUR_TABLE_ID/draft`

For the body, the key would be to make sure you find the correct column ID that you want to edit and make sure to include all of the options, as excluding an option would remove it from the column (if you already had some existing ones).

Assuming you have a column called “Occupations”, the JSON would look something like this:

```lia-code-sample
{
"columns": [
 {
 "id": 3,
 "name": "occupations",
 "type": "MULTISELECT",
 "label": "Occupations",
 "options": [
 {
 "id": "1",
 "name": "advertisers",
 "label": "Advertisers",
 "type": "option"
 },
 {
 "id": "2",
 "name": "publishers",
 "label": "Publishers",
 "type": "option"
 },
 {
 "id": "3",
 "name": "managers",
 "label": "Managers",
 "type": "option"
 }
 ]
 }
 ]
}

```

Hope this helps!

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [March 31, 2025, 3:17pm UTC](https://community.hubspot.com/t/update-values-into-a-multi-select-column/128745/3 "2025-03-31T15:17:54Z")

</div>

Thanks @evaldas 🙌 — Jaycee

---

<div class="post-metadata">

**Author:** ![GRajput](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/grajput/32/102020_2.png) [@GRajput](https://community.hubspot.com/u/GRajput)\
**Post date:** [April 4, 2025, 10:57am UTC](https://community.hubspot.com/t/update-values-into-a-multi-select-column/128745/4 "2025-04-04T10:57:39Z")

</div>

Hi @MVaidheeswara

The way to do this is to include the complete set of multi-select options in your JSON payload and call the PATCH endpoint for the particular column you want to alter.  
URL PATCH

[https://api.hubapi.com/cms/v3/hubdb/tables/{tableId}/columns/{columnId}?hapikey=your\_api\_key](https://api.hubapi.com/cms/v3/hubdb/tables/%7BtableId%7D/columns/%7BcolumnId%7D?hapikey=your_api_key)

```lia-code-sample
{
 "label": "Multiselect Column Name",
 "columnType": "MULTISELECT",
 "options": [
 { "label": "Option", "value": "value" },
 { "label": "Option ", "value": "value" },
 { "label": "Option ", "value": "value" }
 ]
}

```

I hope this will help you out. Please mark it as **Solution Accepted and upvote** to help another Community member.  
Thanks!