API & Developers

Archives for February 2023

"Too Many Requests" and Workflows gone
When I tried to access Smartsheets this morning I keep getting a "too many requests" notification and it will not allow me access my workspaces. On the off chance I get to access my workspaces I select one of my sheets to manage my workflows and they are gone. It shows I have 0 automations when in fact I know I have many…
API Query for new Row
Hi. I would like to add a new row to an existing sheet. I need to create a query to pass into the API so the items I want to add, goes into each of the row columns in the sheet. Can I have a sample or idea of how I can do that? I would like to pass a JSON query. I couldn't find the right inputs. Do I have to be an admin to…
Callback URL in Smarsheet
Hello, I need to integrate smartsheet into other software, please let me know how I can find the URL. I tried to use inbound utility workflow URL but it is not working.
How to create webhook for sheet as third party?
Hi Smartsheet Community, Our startup has fairly simple use case to update our backend systems when a third party Smartsheet document is updated that we have view access to. Based on our research, I understand that as a third party, the only way to receive webhook notification updates is by using a Smartsheet WorkApp which…
Dynamic View update via Smartsheet API
Hello, Does anyone know if it's possible to update Dynamic Views programmatically via Smartsheet API? It's really frustrating that even such basic operation such as change of DV's source sheet requires creating a new DV from scratch. Thanks for any help!
Bridge JavaScript doesn't have Normal JavaScript functions?
I am trying to convert a base64String to binary with the function "atob". However when I run the workflow I get "failed to execute extension module : atob is not defined:". I've had other issues with JavaScript functions as well that seem non existent. Is there something I am missing? @Danielle Wilson do you know? I…
Get Request for Sheet works, get request for column doesn't?
Any idea why this would be happening Use get request in Postman like so, https://api.smartsheet.com/2.0/sheets/{InsertSheetId} That works but any attempt to grab the columns doesn't like so, https://api.smartsheet.com/2.0/sheets/{InsertSheetId}/columns. Instead, I get this message: { "errorCode": 1006,…
Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?
What's the easiest way to grab all specific JSON data from a Smartsheet JSON?
I have a sheet that I have imported. I have a column that I'm trying to grab all the values from and add them to a list in Python what would be the easiest way to go about this from the development end?
Wrong date format while using Power Automate
I went back and forth trying to decide if I should post in a Power Automate Forum or this one so I figured I'd try here first. I have a very simple Power Automate flow. The goal is it grabs employee name and termination date from an email being sent and insert it into a smartsheet row. Everything works as intended minus…

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