Update Multiple Columns with Single API Call in Bridge

I am trying to update multiple columns' properties using a single API module in Bridge.

I am pretty sure my Request Body is formatted properly.

I have used "PUT" and gotten the standard 404 message. I also tried PATCH and got this:

"<!doctype html><html lang="en"><head><title>HTTP Status 501 – Not Implemented</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 501 – Not Implemented</h1><hr class="line" /><p><b>Type</b> Status Report</p><p><b>Message</b> Method [PATCH] is not implemented by this Servlet for this URI</p><p><b>Description</b> The server does not support the functionality required to fulfill the request.</p><hr class="line" /><h3>Apache Tomcat/9.0.85</h3></body></html>"

Is what I am trying to do just not possible, or do I have something set wrong?

Request Body:

[
{
"id": "{{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.1.id}}",
"title": "{{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.1.title}}",
"index": {{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.1.index}},
"type": "{{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.1.type}}",
"options": ["High", "Medium", "Low"]
},
{
"id": "{{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.2.id}}",
"title": "{{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.2.title}}",
"index": {{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.2.index}},
"type": "{{states.Get Target Sheet.smartsheet.get_sheet.sheet.columns.2.type}}",
"options": ["A", "B", "C"]
}
]

Find more posts tagged with

Bridge

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @Paul Newcome

I've never attempted to update multiple columns in a single API call myself, but upon reviewing the documentation, it appears that there is a specific limitation related to columns.

When updating rows, the API allows sending multiple rows with multiple cells together in one PUT /sheets/{sheetId}/rows request — so batching is possible.

However, when updating columns, the API uses PUT /sheets/{sheetId}/columns/{columnId}, which requires the column ID in the URL path. Because of this structure, only one column can be updated per API call. Sending an array of column objects is not supported, which leads to the errors you observed.

Update Column
curl https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} \

-H "Authorization: Bearer JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789" \

-X PUT \

-d '{"title": "New multi-select dropdown column", "index": 0, "type": "MULTI_PICKLIST", "options": ["One", "Two"]}'


Update Rows
curl https://api.smartsheet.com/2.0/sheets/{sheetId}/rows \

-H "Authorization: Bearer JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789" \

-H "Content-Type: application/json" \

-X PUT \

-d '[
 {"id": "6572427401553796", "cells": [{"columnId": 7518312134403972,"image": {"altText": "New Alt Text"},"value": "new value"}, {"columnId": 1888812600190852,"value": "A"}]},
 {"id": "2068827774183300", "cells": [{"columnId": 7518312134403972,"value": "desc_updated"}, {"columnId": 1888812600190852,"value": "B"}, {"columnId": 6552023773538180,"objectValue": {"objectType": "MULTI_CONTACT","values": [{"objectType": "CONTACT","email": "john.doe@smartsheet.com","name": "John Doe"}, {"objectType": "CONTACT","email": "jane.roe@smartsheet.com","name": "Jane Roe"}]}}]}
]'

In short:

Update Rows = multiple updates per request (array allowed)
Update Columns = only one column per request (array not allowed)

Making the call through Bridge, curl, Postman, Python, or any other method does not change this behavior — it is a restriction of the Smartsheet API itself.

Hope this helps confirm it. I always appreciate the depth of knowledge you bring to the community!😀

Paul Newcome

Yeah. I have read through the documentation as well. There are a few things that I have found are possible but are not included in the documentation, so I was hoping that maybe this was one of those cases.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.