-
Do Smartsheet Support an API to fetch header names of a template?
I want to make an API call to fetch the column names and respective datatypes of a user-created-templates.
-
How to select a row's position using Azure Logic Apps.
I need to be able to add a row wherever I want by connecting a logic app to the built in connector to Smart Sheets. I've got the package formatted correctly to actually insert the row into the correct sheet with the correct information, but it adds it to a random row. How can I dictate which row it gets inserted into using…
-
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…