API & Developers

Archives for July 2022

I am unable to create a Developer Smartsheet Account using developer registration portal.
I am unable to create a new developer smartsheet account using the developer registration portal https://developers.smartsheet.com/register/ It throws an error. I have tried multiple times from different browsers or systems. Please help me out here. Thanks in advance.
Decipher Sheet ID from Sheet Permalink
Is there any way to decipher the Sheet ID from the permalink for the sheet? Scenario: Sheet automation triggers an alert to a User. Standard Smartsheet automation sends the sheet URL (permalink) in the body. Whenever that user receives the alert I want to trigger an API call back to Smartsheet but I need the Sheet ID for…
Use API to detect change on ANY sheet?
I know you can use the API to poll for changes on a single sheet or a webhook to send changes whenever an individual sheet is changed. However, is there way to monitor an entire workspace (or the entire account I guess) for any changes that are made to any sheet?
Does SmartSheet back up all their accounts and associated sheets
Good morning, I have a question regarding Smart Sheets back up. If for some reason Smart Sheet was to go down and or crash do you guys keep a backup of all accounts and associated Smart Sheets connected to the accounts that the users can use to restore w.e Smart Sheets they need to recover
Is there a change log for the Smartsheet API Reference?
The Smartsheet API Reference shows that it was updated on 2022-07-13. Is there a way to see what changed?
Power Automate - Cloud Connection to MySQL
Is there a way to establish a connection to a MySQL instance running in the cloud from a Cloud Flow in Power Automate?
Send a form instead of an update request
Is there a way to send a form rather than an update request, but similar to an update request in that it is based on data in a sheet? My use case is that I have n rows in a sheet, and need information for columns in each one of them. I need to use some conditional questions based on responses, so I can't use a simple…
Update row based on cell value
I just wanted to ask if this is true: I am able to insert new rows in the sheet but now I am trying to update existing rows based on the primary column. Basically trying to develop an upsert integration. Looking at the Update Rows api docs, it seems like I will need to get the Row Id first of all the existing data/rows in…
Can I trigger a Data Shuttle using the API?
I'd like to explore putting a button on a web page and even a smartsheet dashboard that will run a data shuttle. Is this possible?
Using Node.js to populate comments
Hi all. Not sure where to start :-( I have a spreadsheet in which we store evidence requirements for audits we do. A control may require evidence of a policy document, plus evidence that the control is actually working (screen shot, register, etc.), and explaining what's needed will make it easier for the customers to fill…

Trending in API & Developers

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
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,

API & Developers

Discussion List