-
Confused about API and access levels
Hello, I am trying to perform a workflow where I: Make a request to list all sheets For this step, I am using this endpoint: `https://api.smartsheet.com/2.0/sheets?includeAll=true` Choose a sheet Make a second request to get more information about that sheet using the sheet id from the first step For this step, I am using…
-
Automate Sending Welcome Email to New Smartsheet Users in our Company?
Does anyone know of a way to automate sending a welcome email to new Smartsheet users in our company. Our company has access to the app but their account isn't "created" until they login the first time (Okta/Active DIrectory Authentication) My idea would be to use the Bridge to: Make API call using GET /users Add Row to…
-
Parsing Multi Picklist through API
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…
-
Syntax: Add Row via API for Multi Select Contact Column, MULTI_CONTACT
Dropping this here in the hopes Google picks it up for future developers. At times when you cannot use the SDKs for adding rows via the API with multi-select contact columns (i.e. Bridge), the following body payload syntax is correct for posting new rows to a sheet. [ { "cells": [ { "columnId": 4532552246972292, "value":…
-
Feature Request: API - Ability to Enable+Disable Automations
FEATURE: Add the ability to enable and disable all sheet automations via the Smartsheet API. THE REASON THIS SHOULD BE IMPLEMENTED: When a workspace or sheet is duplicated the automations all remain active. So if "Save as New" is used as a backup method, time-based automations will also duplicate. As a result, if there are…
-
Unable to Upload data using R via the API
Hello. I am not a python programmer and attempted to add rows to a desired sheet in Smartsheets using the R "smartsheetr" package. Please see the code snippet below. I am trying to add rows to a sheet from a dataframe based on the sheet id, and subsequent column id's. When I execute the code below I get the following…
-
Event reporting API Enhancements: “to” parameter and Email ID
4/21/2025 Smartsheet has added two key improvements to the Event Reporting API. First, you can now use a “to” parameter to define an end time for your query, making it easier to pull data from a specific timeframe. Second, event responses now include the user’s email address, helping teams identify who performed each…
-
Regression in Create Webhooks API?
Hello in the past 36-ish hours, the response to the Create Webhooks API (POST /2.0/Webhooks) appears to have suffered a regression. Prior to the change, this API (and all other POST and PUT Smartsheet APIs we have been using) would accept the following as the Content-Type header for the HTTP Request: Content-Type:…
-
Return proper error codes
I was updating a row in a sheet by impersonating another user. But the api was sending me an error code 1006 which means 404 not found. The issue was I was impersonating a user who does not have access (shared with) to that sheet. It would be great if the API return the proper error response by saying the user does not…
-
Remove User API enhancements now generally available!
April 30th, 2025 SysAdmins using the Remove User API can now leverage enhanced API functionality to align with the updated Smartsheet governance framework. These updates ensure that removal of users adheres to plan-level security controls, reducing administrative complexity and improving compliance. Removing users from the…