Issue with Smartsheet Update Row Activity - "Unable to Parse Request"
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"
}
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!
Answers
-
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:
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 servicesCheers,
GenevieveNeed more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives