SmartSheetAPI PUT

Hawaii

Hello,

I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman:

PUT

Request URL:

https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId}

Request Body (JSON):

{

"value": "test",

"displayValue": "test"

}

However, I'm getting a "status: 404 NotFound" error, and I receive the following response:

{

"errorCode": 1006,

"message": "Not Found",

"refId": "XXXX"

}

Could someone please tell me the cause of this issue and how to resolve it? I apologize if my English is not natural.

Genevieve P.

Hi @Hawaii

What I would do here through Postman is have Cells be in the Body so that you can use an array to identify the columns/cells to update:

Request URL:

https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}

Request Body (JSON):

{ "cells": [
    {
      "columnId": xxxx,
      "value": "test"
    },
    {
      "columnId": xxxx,
      "value": "test"
    }
            ]}

Here's the API Documentation for Update Rows.

Cheers,

Genevieve