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

How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…

API & Developers

Discussion List