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

Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
What is the proper Content-Type string for an Excel (xlsx) file row attachment?
Hello, I have an Excel document (xlsx) that I want to upload to a row through the API. My code does successfully upload the file as a row attachment. However, when I download the file through Smartsheet and try to open it, I get an error "Excel cannot open the file 'file_name.xlsx' because the file format or file extension…

API & Developers

Discussion List