Issue with Smartsheet Update Row Activity - "Unable to Parse Request"

Shital

Hi Everyone,

I am facing an issue with the Update Row activity in UiPath Smartsheet integration. While attempting to update a specific cell's value in a row, I am encountering the following error:

Update Row: Bad Request - Often due to a missing request parameter  RequestId: 677d5817e4b0f00701dcae17  ProviderMessage: refId - 8afd2420-e57e-4fac-b2b6-eacb5d1a7ee1, errorCode - 1008, message - Unable to parse request.

Here are some key details:

• The Sheet ID and Row ID are passed correctly.
• The Result (CellItem) is generated using an Invoke Code activity.
• My connection is working because other Smartsheet activities (e.g., reading data, downloading attachments) are functioning as expected.

Code Used to Create CellItem:

' Step 1: Create the cell item

Dim cellItem As New Sheets_rowsCellsArrayItemRef With {   
.ColumnId = 6249262680958852,   
.DisplayValue = "Test",   
.Strict = False,   
.Value = "Test"
}

Result = cellItem

' Step 2: Create Sheets_rowsCells
Dim cells As New UiPath.Smartsheet.IntegrationService.Client.Sheets_rowsCells From { Result }

' Step 3: Serialize and Log the Resulting Object
Dim jsonString As String = Newtonsoft.Json.JsonConvert.SerializeObject(cells)Console.WriteLine(jsonString)

Logs:

Serialized JSON:
[{"columnId":6249262680958852,"displayValue":"Test","strict":false,"value":"Test"}]

Result Object:
Sheets_rowsCellsArrayItemRef {    
AdditionalProperties = Dictionary<string, object>(0) { },    
ColumnId = 6249262680958852,    
ColumnType = null,    
ConditionalFormat = null,    
DisplayValue = "Test",    
Format = null,    
Formula = null,    
Hyperlink = null,    
Image = null,    
LinkInFromCell = null,    
LinksOutToCells = null,    
ObjectValue = null,    
OverrideValidation = null,    
Strict = false,    
Value = "Test"
}

Screenshot 2025-01-07 221144.png

I’ve attached a screenshot for reference. If anyone has experienced this issue or knows how to resolve it, your help would be greatly appreciated!
Thank you!

Genevieve P.

Hi @Shital

The 1008 error is the Smartsheet API error noting that it's unable to read your request from UiPath. I'm not familiar with UiPath at all so I won't be able to help configure your Update Row module, as the formatting is different than what I've used before.

I found the UiPath Documentation on how UiPath has configured their Update Row module:
https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-update-rows

Since you state that the RowID and ColumnID are correct, I would double check the Row Data portion of your request.

Normally I'd recommend posting in the UiPath Community, but I can see that you've already done this, here! This is the better place to ask your question as it's more likely that the members in that forum are familiar with UiPath's set-up.

Here are some other related threads I found in the UiPath forum that may help:
- SmartSheeet Integration / update existing rows in smartsheet
- Updating smartsheet rows using integration services

Cheers,
Genevieve

prime_nathaniel

Shital,

You are sending an awful lot of information to just update the text of a cell. The SMAR api only requires,

sheet id // in url
row id // in object
column id // in object
value // in object

PUT https://api.smartsheet.com/2.0/sheets/{{sheet_id}}/rows
Body Object:
{ "cells": [{"columnId": someColumnID, "value": "ABC"        }    ],    "id": someRowID}

It will also require that you have content-type header set correctly to application/json

I recommend generate your update object and then run the PUT request via curl. Remove parameters one by one till you find the offending syntax.

Which I don't think you meant this literally but obviously

{
AdditionalProperties = Dictionary < string, object > (0)
{},
ColumnId = 6249262680958852,
ColumnType = null,
ConditionalFormat = null,
DisplayValue = "Test",
Format = null,
Formula = null,
Hyperlink = null,
Image = null,
LinkInFromCell = null,
LinksOutToCells = null,
ObjectValue = null,
OverrideValidation = null,
Strict = false,
Value = "Test"
}

Is not in JSON which is key-value, ie "key":"value" paired.