-
Can I populate Smartsheet rows from a SQL Database read?
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
-
Bulk create Sheet from template through smartsheet API
Hello, I've currently been facing an issue regarding the Smartsheet API, a quick breakdown of what i'm trying to do, I require to create 900+ sheets that will all have the same layout (a template is available for that) After skimming through the API discovered the feature of creating sheets based on a template, problem is,…
-
[API] - do not get response when api get, delete and post
Currently, I've built up an API method to add rows in some sheets. However, there are some sheets we can not add data into it and there is no response message when the api method runs. Normal sheets with response for success: Error Sheets without response: Have you guy worked through the similar issue as this one? Thanks!
-
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 :)