-
Search Sheet SMartsheet Api not finding values
I am developing a Power Automate workflow that needs to search a sheet for particular values. I used the "query" portion to search for a "Project Name", "User", "Date of Entry", and "Phase" however, it will not produce any results. Testing further, I can get the search to work for "Project Name" and "User" but the "Date of…
-
Simple row update via API/Powershell
Just getting started with the API. Just want to show a proof of concept of updating a cell. I'm able to authenticate and get sheet, row and column details. I'm getting the error: Invoke-RestMethod : { "errorCode" : 1008, "message" : "Unable to parse request. The following error occurred: Unrecognized token 'value': was…
-
Smartsheet is adding a leading apostrophe when writing numeric data.
I am using Python to copy excel data to the Smartsheet. I have an excel column that can be either a number or text/string, and I want to ensure that numeric values are not automatically formatted with a leading apostrophe in Smartsheet. I noticed that when using the value attribute instead of object_value, the leading…
-
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,
-
webhook suddenly stopped working.
I created a Smartsheet webhook last month, and it was working fine. However, from yesterday it stopped working. I faced the same problem before, so I created a new webhook, but now, even the second webhook stopped working. Can you help me understand the reason for this issue?..
-
Smartsheet API - Post
Hello Team, I am using Postman to write an API to POST data into Smartsheet. I am looking for examples of a script, which uses the POST method to update specific columns in Smartsheet. Many Thanks.
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Get multiple pages of data in Bridge
Hi all I just wanted to pass along a pro-tip that I got from the Technical Engineering group at ENGAGE 23. If you need to deal with paged data in Bridge, it's not immediately obvious how to do that. At least not to me :-) So I asked. For example, if you do a List Sheets in Bridge, you may get some of the data back on page…
-
/reports api response should have createdAt and modifiedAt fields like /sheets call
/reports api response should have createdAt and modifiedAt fields like /sheets call Hi, As of now createdAt and modifiedAt date fields are present in /sheets and /sights how ever these 2 fields are not present in /reports call. https://smartsheet.redoc.ly/tag/reports documentation says that these 2 fields should be part of…
-
API needed to see deleted/sheets/sights/reports for any specific user
Hi, This request is related with case#06467692. There is no api as of now that returns the details of deleted smart sheet objects hence API needed to see deleted/sheets/sights/reports for any specific user. please implement and let us know.
