API & Developers

Archives for September 2021

How to update the value of a summary field if it's text?
We introduced a new process where our team needs to fill in a bunch of summary fields for every smartsheet. I'm trying to update the data for summary fields using APIs for existing smartsheets as a backfill. I have all the data in a google sheet. I'm using Zapier to make the API call for every row in the google sheet. I…
Loop back to the start of a Bridge Workflow
I am trying to build a help chatbot that our team members can use to quickly find help docs on various topics/processes. For example the chat would look something like this - If you answer yes I want the chatbot to loop back to the very start and clear any history from the previous questions/answers, and if you answer no…
Setting Up Webhooks
I'm looking for assistance on how to set up webhooks. Nobody in Smartsheet seems to have any idea how to set it up. I was passed from one person to another. I'm no developer and that's why I was hoping Smartsheet can point me in the right direction. But nada. Anyone here who knows how? The webhook is from the RingCentral…
Can anybody help to connect Smart Sheet with Access Data
Trying to use Visual Studio to connect Smart Sheet to Access Database but proving very difficult. Needs to be a live connection. Any better ideas? please let me know thanks in advance.
Database, Infrastructure, Coding
What database is Smartsheet running on? (SQL serves, MongoDB, Proprietary, etc.) What cloud infrastructure is Smartsheet using? What programming languages can I use? (HMTL, JavaScript, CSS, JQuery, SQL expressions, etc) Are there built-in functions as well? Hope someone can help! Thanks!
Python SDK - 'Field "null" was of unexpected type' when creating a webhook
I'm trying to create a webhook using the smartsheet-python-sdk (2.105.1): webhook = Smartsheet.models.webhook.Webhook( props={ "name": "[redacted]", "callbackUrl": "[redacted]", "scope": "sheet", "scopeObjectId":"[redacted]" "events": ["[*.*]"], "version": 1 } ) print(webhooks.create_webhook(webhook)) I'm getting the…
Find out who is using a sheet via the api.....
Does anyone have a solution for finding out who is currently accessing a sheet? Probably the functionality that displays the coloured user badge within Smartsheet when someone else has accessed the sheet you are viewing. Thanks Brian
Want to hire a developer for Smartsheet
We are apparel manufacturing in Delhi NCR. We want to shift to Smartsheet. Can someone help?
GetReport not working with Node.js
Hello, I get an error when calling getReport ( or getReportAsCSV ). { statusCode: 404, errorCode: 1006, message: 'Not Found', refId: 'lrrf81wvdugg' } The id exists ( I have double checked by calling ss.sheets.listSheets ) Here is the code I am using ( node.js ) var client = require('smartsheet'); var fs = require("fs") //…
Add Row with a CONTACT_LIST column [ANSWERED]
Hello, We have a sheet with a column of type CONTACT_LIST. We have a form that populates this field with a name the user enters, rather than an email. The form populates the sheet even if the name doesn't exist in our contacts list. We want to use an API call to insert a new row into the sheet in the same way the form…

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