API & Developers

Archives for July 2023

Deactivate user API not working.
The deactivate user API is not working as expected. When we hit the API, it gives a 200 success response, but the changes aren't reflected in the admin portal, as in the user is not deactivated. Is this a known issue ? Thanks,
How I can obtain a month's name from a date?
Hi folks, Has anyone knows how I can obtain a month's name from a date? It's like a FORMAT([Date]; "MMM") that returns something like June. Regards, J. Morais
Extract List of Unique Values
Hi Is it possible to use Bridge to extract from a column a list of values, run a JS to extract an array of unique values, and then pass this to another sheet and update another column with this unique list?
Harvest (time tracking app) +Smartsheet integration
Hello, Wondering if this has been solved yet? We are looking to integrate Harvest and Smartsheet to run reports on actuals vx. budgeted time. Has anyone created this integration? if so, how? thanks
How to format "row" when inserting record into Smartsheet
Hi - i have a Power App where i am assembling data to insert new row in SmartSheet and continue to receive "unable to parse insert row request payload". I have formatted the row via "Compose" action a few different ways to no avail. Here is latest attempt - note that I am replacing the variables('... using dynamic content…
Why were all SDK GitHub repos archived?
I see that all of the Smartsheet SDK GitHub repos (https://github.com/smartsheet-platform) were archived earlier this year. In GitHub, archiving a repo makes it read-only and indicates that it's no longer being actively maintained. Can you please shed some light on why these repos were archived? Are they being replaced…
Bridge Salesforce API - SF Contact Module
We're looking to pass contact information associated with Salesforce opportunity records into Smartsheet. We have the Smartsheet / Salesforce Connector in place, but following the current structure would explode the number of fields necessary to denote all possible roles associated with each project. Is it possible to…
API PUT and Body help for Cell link from a cell in sheet "a" to sheet "b"
I am having trouble linking a cell from sheet a to b. I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated. PUT: https://api.smartsheet.com/2.0/sheets/4098048888098692/rows/1370574824361860/cells/259016080 Body: { "cells": [ { "linkinFromCell": {…
Report on User Access when Users are not Registered in MY Smartsheet system
We have an application that has been built on Smartsheet. Several of our clients have the users of our system as Licensed (or unlicensed) Users in THEIR Smartsheet system. Because of this - we cannot add them in our Smartsheet system. We would like to get a report that shows the utilization of OUR system by THEIR users.…
Drop Downs - Can a Response Trigger the Cell to Change Color?
Hello, Is there a functionality whereby a cell changes color when someone chooses a drop-down choice? For example, my drop-down choices are: Paid Overdue Sent Is there a way to trigger the cell to change to Green if 'Paid' is chosen, Red if 'overdue' is chosen, and Blue if 'Sent' is chosen? I know there are rules I can…

Trending in API & Developers

When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,
Do you know if you can add a custom code in values (pink rectangle) - Bridge Workflow?
Do you know if you can add a custom code in values (pink rectangle) in this Bridge workflow that is updating a SharePoint list any time changes are being made in the relevant Smartsheet Table? Basically this workflow is working as expected with one issue: for every empty cell, the workflow will update SharePoint with the…

API & Developers

Discussion List