-
Calendar App Automations (API + SCC Integration)
Would like to utilize Calendar App within Control Center-generated Dashboards (embedded link), however, these need to be manually generated for each provisioned project. Please consider integrating Calendar App within SCC to allow for calendars to be generated and embedded automatically upon provisioning a new project. The…
-
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…
-
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?
-
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…
-
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!
-
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?
-
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,…
-
API Service Account Login
I am extensively using the API to create actions and generate data in sheets and the source of that data always shows up as my user, I would either like the option to make that show up as the smartsheet automation user or as a service account so the ability to generate a username and an API key under my account that will…
-
Can you use the API to call and get just the first row ID?
I have 10,000K line database and I need just the row ID for the first row -- currently I'm grabbing the entire JSON table to then query for the ID, but that takes a bit of time. Is there a re way to just ask for that first row ID? You can do this for columns like this: first_column = []…
-
Integration of interactive maps into Smartsheet.EU
Hello everyone, I hope you are all doing well! We are currently looking for a way to integrate maps into Smartsheet.EU (based on a database of distribution partners managed in Smartsheet). The purpose would be to filter locations (e.g. by postcode) to get a quick overview of possible partners for a given area and to…