-
Why does the API require the row id to add a row?
Hi. I want to add a row with the API. I therefore use the Add row method. This method requires to use the row object. The first attribute of the object is the row's id. What sense does it make to request the row id to add a row? If I attempt to add a row without a row id, I get the following error message: ... "errorCode":…
-
Update Rows via API started to fail recently
I have created an automation in Alteryx to Insert/Update/Delete row data via the API. Everything worked perfectly until sometime this month. The Insert and Delete parts work fine, but when I try to do the Update, I get an "Unable to parse request" message all of a sudden. An example payload I'm sending looks like this:…
-
How to prevent Smartsheet API from converting certain strings to integers
Hi all, I am not sure if Smartsheet recently changed how strings and integers are formatted, but my API script has seemingly randomly began converting certain string values to integers automatically. For example, a string that leads with 0s such as "0450" is now being put into the smartsheet as just 450 and it shows up as…
-
Smartsheet Event Reporting API
Hi All, Does anyone have examples of what Smartsheet's Event Reporting API looks like? Is it prebuild with diagrams, or is it raw data tables? Any insight would be helpful. The documentation online only says what it can do with no examples- but if I missed something please post those links as well!
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle to…
-
Delete Resource Management Bill Rate via API
Allow to delete Project and user specific bill rate via API. Resource Management API documentation currently shows a DELETE endpoint for project and user specific bill rates but it doesn't work. See the attached photo. API returns: HTTP/1.1 405 Method Not Allowed {"message":"cannot delete bill_rates"} Please fix this…
-
"Something went wrong" Error
Our team continues to receive the same error message while working in our SmartSheet throughout the day. Though, when we review the SmartSheet Status page there are no similar issues listed. So, my question is: What does this "Something went wrong" mean if it keeps happening for numerous users for almost a week now? Is…
-
PowerBI Connector has intermittent issues (due to smartsheet network?) - Anyone having similar issue
Hi, Is anyone else having issues with using the Power BI Connector to access Smartsheet data in the last couple of weeks. The network performance seems to be extremely sporadic and is getting worse. Nothing has changed in the configuration of the PowerBI dataflow nor in the amount of data being requested. Errors when they…
-
Last Login details not available for Users with Status - "Active"
I am making an API request to the users endpoint (https://api.smartsheet.com/2.0/users) with the "include=lastLogin" parameter and a Page Size of <=100 to retrieve all our user information. However, the API response does not provide the last login information for certain users, despite their "Active" status being true.
-
Merged: Gantt Timescale Settings
This discussion has been merged.
