-
Question about error code 4000
Hello Smartsheet Api support team, I've been developing python scripts on Azure function and they've been working without any issues until recently. I keeping got some generic error when attempting to add or update rows. I repeatedly got the error code 4000. {"result": {"code": 4000, "errorCode": 4000, "message": "An…
-
Trying to create a new sheet in a Workspace is throwing an unexpected exception C# SDK
I am trying to create a new Sheet in a specific Workspace using the Smartsheet SDK for C# and I keep getting an unexpected exception The statement above compiles just fine. The Workspace ID (wkspID in the code) is correct. I can create the Sheet just fine locally but the sheet does not have an ID until it is created in…
-
Get hierarchy/parent of sheets
Hi, I came across a blog mentioning that the Sheets folder feature has been deprecated. As SmartSheet users, we now need to migrate our sheet files and folders into workspaces. Additionally, when calling the API to list sheets, it returns all sheets within the account or profile. So, until it will be migrated to a…
-
Smartsheet Tableau Integration, API token for SSO login throw error
In Smartsheet, I generate a token under my personal account settings and paste it into Tableau > More > Other Databases (ODBC) > Driver:Smartsheet Live Data Connector > Connect > Use API token for SSO login. However, the token doesn't work and I am returned with the following error: Your Access Token is invalid". How can I…
-
Severe inconsistencies with token-based pagination in the ListWorkspaces API endpoint
Hello community, I'm experiencing several issues when using token-based pagination (paginationType=token) with the /workspaces API endpoint in Smartsheet: Using the same API Key (so same user), traditional pagination (page and pageSize) correctly returns the full result set (over 300 workspaces) and allows access to all…
-
How to Add a Dynamic Ticking Clock or Timer in Smartsheet Dashboard
Hi Community, I’m trying to include a ticking clock (or timer) in my Smartsheet Dashboard so that users can see the current time as part of the visualization. I’ve already tried using online clock links and embedding them through the Web Content Widget, but Smartsheet doesn’t seem to support those links directly. Is there…
-
Webhook not getting event callback
Hi all, I have been using webhooks in my nodejs application for awhile and sometime I think my webhook is not receiving the event callback. In my sheet I have a column A, (not editable directly) which is a formula that's calculated using column B. When an user updates column B, column A gets updated which triggers the…
-
Potential reasons why my trigger is not resulting an event during run log (Bridge)
I've completed the authentication process, created a trigger and made sure that the trigger has the right source sheet and event type but I am noticing that I can't get any data from the trigger. My goal is to get the row information when new row is added in my sheet so I can copy some of the data over to another sheet.…
-
rowNumber attribute for Row objects not accessible
When accessing the row objects of a Smartsheet, I can get some attributes, like row.id and row.expanded without issue, but when I try row.rowNumber it returns an AttributeError, saying that that attribute does not exist. By my understanding of the row object from the get_row response (Get Row), the attributes 'id',…
-
Why no Move/Copy Methods for Reports
SheetResouces has MoveSheet & CopySheet methods, why are there no MoveReport / CopyReport Methods for ReportResources in the API ??