API & Developers

Archives for January 2021

copy_folder doesn't copy automation rules via rest api
currently I run a copy_folder by API then found that the automation rules of the sheet under the folder is not copied. I tried to create that automation rule by rest api, after copying the folder, but found that create_automation_rule is not available. Is there a good way to do this fully via rest?
Request for enhancement: Add functionality to deactivate workflows
Dear community, I sent an enhancement request today and hope you can help to push this onto the roadmap. Here is the story. Situation: A third party tool is used (access via API) to regularly backup items with 100% functionality (incl. workflows). Some of the sheets have many workflows and some are not simple "trigger ->…
Hello All, We Are Looking For Help
I'm looking for someone that could help us model & setup our business workflow using the core and more advanced features of Smartsheets/Workapps. We are a roofing contractor that needs our workflow better automated and customer experience/engagement enhanced. We have been using Smartsheets poorly to track basic customer…
Link directly to a single card in card view
I would like to share a link with coworkers which opens a Smartsheet in card view, and opens the card view popup for a single card which was specified by the URL. Is this possible? I am already using the API, so I could stitch the URL together myself based on the back end Sheet ID and Row ID if that is helpful.
How to get published sheet's readOnlyFullUrl
Hey Smartsheet Community! I'd like to get Publish Link from a published sheet by Python. Thanks Roy
Issue in using Smartsheet CSharp SDK in SSIS Package
Hi, I am using Smartsheet CSharp SDK in SSIS Script Task. I added it by nuget package, but getting error as below : Error CS0246 The type or namespace name 'Smartsheet' could not be found (are you missing a using directive or an assembly reference?) Then, I downloaded Smartsheet CSharp SDK and added reference to the dll…
How do I add linkInFromCell by REST API?
using Python SDK. If I use add_row it will tell me that this is not allowed. If I use update_row, and with a random value (if value != null), it will return the following error. "errorCode": 1110, "message": "cell.value must be null if cell.linkInFromCell is non-null." If I use update_row, and with a value:null it will…
Can we create webhook on Reports like we do for Sheets
We can update the reports manually and since its bidirectional it updates the underlying sheet and vice versa. My question is whether we can create webhook on Reports or not like we create webhook for Smartsheets. If the webhook can be triggered on Reports it would be helpful for me. Please share your thoughts on this.…
API Rename attachment
Good day. I see attachment renaming has been added to the smartsheet GUI. Maybe I'm missing something, but I can't find a way to rename an attachment via the api. Is this possible ? Thanks in advance Rousseau
Can we plot address info from Smartsheet live on to google maps?
Looking to create a live map (Ideally google maps) that updates with Smartsheet address info (Postcodes)

Trending in API & Developers

Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…

API & Developers

Discussion List