API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

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?
Sheet Access via API
I've looked through all of the documentation for the API but have been unable to find out if there was a way to see Collaborators and Permissions for each sheet. I had seen previous posts of people asking for this and had it recommended as a future feature. Is there an update on this? Was this done and I'm just missing the…
Can you automate the one-way Salesforce Connector workflow
Hello. I have created a one-way - manual run Salesforce Connector workflow. It is running fine, but I have to run this manually every time I want data from Salesforce to populate my Smartsheet grid file. Is there a way to make this one-way (I do not want to change this to a two-way workflow, since I do not need it to…
Python API - How do I transfer a date-time value from a Pandas data frame to a new row?
Hi! This is my first question in the forum, so please let me know if I'm doing something wrong. I have some data in an excel csv file, and I have copied it into a Pandas data frame. One of the fields in the csv has this format: "3/17/2022 10:59:00 AM" and when transferred to the data frame it shows '3/17/2022 10:59'. So I…
Why HttpClientException is thrown from time to time while using Proxy?
Hi, When I'm using a proxy, I experience a bug that is not always reproducible: HttpClientException is thrown while calling ObtainNewToken from OAuthFlow. AutherizationResult parameter that is sent is always the same. Exception is thrown with message: "There was an issue connecting." Please help in finding a solution.…
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…
Debugging Webforms and webhooks
My client has been complaining data some registration data has been lost that was supposed to be sent over one of my webforms. The problem is that I cannot reproduce the problem and the data is inserted to Smartsheet as expected. Is there a possibility to debug webforms as well webhooks.
Will Smartsheets Webhooks introduce more authentication methods for callbacks? Or any workarounds?
The Smartsheets webhooks are great ideas, but without even basic authentication they require an exposed endpoint to use since the only way to authenticate is by receiving and examining the payload. Having an exposed endpoint is not an option for most enterprise solutions, where at the very least Basic Auth is necessary.…
Can I force a specific row to copy to a sheet if the automation failed?
I have a formula that triggers a row to copy over if a certain condition is met; the submission for this particular row was not met and the cell that was wrong had to be updated. Our team has updated this cell; however, the row did not copy to the next sheet. Can I force just this row's automation to have it flow to the…
API search/get multiple rows in a sheet
I need some help formulating an API call to retrieve multiple rows of data in a sheet that have a specific key word. I can successfully use the /2.0/search/sheets/xxxxxx?query="A2" query to get a list of rows however I don't know how to continue this query to then pull all the rows of data that match the query.

Popular Tags

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

Is it possible to use api to edit sheet from other organization which shared edit permission to me?
I am currently evaluating Smartsheet for my organization. We are considering a Business plan to streamline our collaboration with external partners. Specifically, I need to confirm if the Smartsheet API allows us to programmatically edit sheets owned by another organization, provided they have granted us "editor with…
List folder children
I am attempting to use the Python example for Listing Folder Children from the API Reference Docs. No matter what I do I get the following error message: {'errorCode': 1006, 'message': 'Not Found', 'refId': 'qgsta7'} =======CODE======= import requests import os from dotenv import load_dotenv from dotenv import…
I'm embarrassed to ask: How do you write an API
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…

API & Developers

Discussion List

Categories

Popular Tags