-
API adding blank row instead of data sent in the code
This is odd. I have a script that adds one row to top of a new/blank sheet for testing purposes. There are two fields and I have the column ID's as well as the sheet ID correct. When I run the script, I get a SUCCESS result. When I go to the sheet, it says it has been changed, and I need to refresh. But, there is no data.…
-
API issue to add columns to a sheet
This discussion was created from comments split from: Add_Row Data Format.
-
Smartsheet login not working with email and code
Hi, I've observed that the new login feature, which involves receiving an email with a code, is not functioning in the Webview2 runtime (Smartsheet OAuth2) and Microsoft Edge browser. FYI: It works perfectly in Google Chrome. Here are the steps to reproduce the issue: 1. Open the Microsoft Edge browser. 2. Enter the…
-
custom button calling rest api
Hi, I have a smart sheet with ids and status. I want to call a rest api, send the IDs and get the current status of those ids. I have already written code which reads the ids list and gets the status and updates the status. All i need is some way to call this api from the sheet itself. Can i create a custom button, which…
-
Darshan Hiranandani - How can I handle errors and exceptions gracefully in APIs?
Hi, I'm Darshan Hiranandani - How can I handle errors and exceptions gracefully in APIs? I'd love to hear your suggestions on effectively managing errors in API development! Regards Darshan Hiranandani
-
ServiceNow SaaS licensing integration with Smartsheet
Hello Community, We have successfully established the connection with ServiceNow. However, when attempting to pull user subscriptions from Smartsheet, we encountered an issue where only some users' subscriptions were retrieved, not all. Subsequently, an error occurred indicating:{"errorCode":1013,"message":"The operation…
-
Shared mailbox does not receive notifications from requests submitted via smartsheet request form
Hi Team, Hope you are doing good. We have built a request form in smartsheet for stakeholders to submit requests to us. When testing, we noticed that when the request is submitted from a shared mailbox (within the company), the mailbox does not receive notifications about request changes/comments added to the request. Many…
-
Having Difficulty with Smartsheet API in Excel
I'm looking for examples of calling the Smartsheet API from Excel. I can't seem to get the syntax right.
-
Automatically creating new columns when import data from API
When using API to fetch data from other platforms and import into SmartSheet, how to automatically create new columns, if there are more columns in the data than the target sheet on SmartSheet (right now, importing data from API to SmartSheet need to specify column ID, but when we have a dataset with many columns, this…
-
Add Retry Logic to Bridge API
Bridge doesn't have a mechanism to retry a workflow when it's stopped by error. Smartsheet should improve Bridge, so that a workflow which is stopped because of either a timeout or sheet lock is retried until successful. This can happen when you have competing processes (e.g. DataMesh, Pivot, Automations) which temporarily…