-
Bridge: Variables Passing Through to Child as Text, Not a Value. "{{variable}}" instead of 123124932
WORKFLOW PURPOSE: first it gathers and populates our entire users list to a sheet. This child workflow is supposed to use /users/{{userId}} to populate the DETAILS of each user onto the matching row that was just populated. But… I can't get Smartsheet Bridge to pass-through the variables I've set to the Child Workflow.…
-
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…