API & Developers

Archives for April 2020

Error 1012: 'Required object attribute(s) are missing from your request: values.'
I'm having difficulties with the AddRows method in Smartsheet's C# SDK. I have been getting the error code 1012 with the message 'Required object attribute(s) are missing from your request: values." I have seen others post similar issues but with 'cell.value' as the missing attribute. In my case, what is 'values' supposed…
Would it be possible to add multiple request approvals in one approval request?
This would greatly reduce the number of automation work flows for a given sheet. I want to do this (instead on multiple work flows) so I can get and see individual responses in separate columns.
Summing columns from multiple sheets
Hi, I have multiple sheets managing separate projects with similar columns. I would like to sum the data in a particular column across all sheets to get a total number for the dashboard in the Metric Widget. Is this possible?
Can I show Smartsheet data inside Confluence page for free?
It would be perfect if I cuold simply show the Smartsheet information inside of Confluence. No need for further fancy Jira/Confluence integration which I know costs a lot of money.
Help us design API classes that meet your needs
Hi, We are preparing new courses related to our Smartsheet API, would you take few minutes to let us know what would you like us to offer by submitting this survey: https://tinyurl.com/ycg7arps?
Delete a Sent Update Request
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. The problem I'm having is that the delete update request call fails every time. It fails…
Error Code 4000 "Unexpected Error"
I am getting error 4000 when trying to write to a sheet using python. All it says is "An unexpected error has occurred. Please contact Smartsheet support at api@smartsheet.com for assistance." I have successfully written to other smartsheets using the same code so I do not think it's something I am doing wrong on my end.…
CopySheet Include Automated WorkFlow & Alert Options
Is it possible to include the Automation setting from a "template" to the new target smart sheet using the "smartsheet.SheetResources.CopySheet" function? Dim newCopiedSheet As Sheet = smartsheet.SheetResources.CopySheet(TemplateSheetId, destination, New SheetCopyInclusion() { SheetCopyInclusion.ATTACHMENTS,…
Jira connector with tracking Epic % complete by epic name
I'm trying to show the % complete for epics that are in progress but having trouble getting this to work. I have the Jira connector already setup, mapped to a summary sheet with formulas, and finally to an executive dashboard. My ask is how can I pull in the epic name field from the source sheet connected to Jira, onto the…
Donut Graphic / View
Is there a way to fix this? Sometimes you can have lines (separators) from the numbers; but this is a jumbled mess. Even if I changed the chart type, I would need to adjust the axis to start the numbers at a lower point, so that views, correctly.

Trending in API & Developers

Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?
Creating Webhook with subscope
Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { "callbackUrl": "https://www.myApp.com/webhooks", "enabled": true, "events": [ "*.*" ], "name": "Webhook for Sheet Creation", "version": 1,…

API & Developers

Discussion List