-
Referencing the Activity Log
Hello, Is there a way to programmatically reference the activity log? My organization is trying to reference the change date of a project status field and we want to track when projects have hit certain milestones (and also when those milestones were hit on past projects tracked within smartsheet). Is there a way to…
-
400 5160 Error Code
I've got a number of GET search sheet requests returning the following error code: REST Connector: The remote server returned an error: (400) Bad Request: { "errorCode" : 5160, "message" : "The characters *, ~, : and \" have special meaning in search. Please ensure that your search contains more than just special…
-
API Token of resigned user
Hi community, We are using API token to integrate Smartsheet with RPA tool. If the user who generated the API token resigns, can we still use his API? Can we transfer APIs from one user to another? Thank you in advance!
-
Date format issue
Hello, Currently we get format like ",,,,,,,,,,,,,,,,1" for date column type. How can we get actual date format like "yyyy-mm-dd"? Or if there is any way to convert format string ",,,,,,,,,,,,,,,,1" to datetime format?
-
Remove ' character
Hi, I'm using make.com to make an API call to update some of our sheets, everything is working fine except for updating the Progress. I'm trying to mark it as 100% but when I send 100% via the API it goes into Smartsheet as '100% How can I get the API to not add the ' Thanks :)
-
directly script the Code and run in SmartSheet
This discussion was created from comments split from: Loading data from excel into Smartsheet API to an existing sheet.
-
How to import an MS EXcel sheet, with embedded links in cells?
How to import an MS EXcel sheet, with embedded links in cells?
-
404 Error - Event data - Smartsheet API
Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the url which is being suggested in the documentation. I tried a few different ways and…
-
ScriptIncl:SmartsheetIntegrationHelper-Failed
We are using ServiceNow to Smartsheet Integration and for one record is throw out an error and error code is : " ScriptIncl:SmartsheetIntegrationHelper-Failed to insert issue table record to the smartsheet sheet " What could be the reason , how I can integrate that record to smartsheet?
-
Timestamps only match selected date format when clicked on
Hello, I am sending data to a Smartsheet via the API. I have been following the requirements for dates to be in isoformat 8601 per the documentation without any issue for over a year. Recently however, the dates are coming in as their raw format instead of the format prescribed for the date column in the sheet itself. Only…
