-
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!
-
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.
-
Sheet Access Report via API
As we are automating our process to manage users and sheets we are looking for a way to automate pulling the data that is contained in the Sheet Access Report. As an admin using the admin token, I am able to pull a list of sheets and then able to use the API to gather some information on the sheets but am unable to gather…
-
How to enable Google Maps - "Distance Matrix API" on Smartsheet?
Hi - I don't want to spend money on the vendor/partner that Smartsheet are using for mapping. Does anyone have a working setup they can share which leverages the Google Maps "Distance Matrix API" ? Similar to this article -…
-
Customer add/edit sheet rows
I need customers to be able to add rows of information to a smart sheet, and later be able to edit those rows. A scrolling table view interface would work better than a form so users can see multiple records at a time. The sheet needs to be secure so that customers can only see/edit their information, and not be able to…