API & Developers

Archives for December 2018

API Conditional Formatting
Hi - It sure would be nice to have the ability to update conditional formatting via the API. I see a thread from 2016 - is this something that the dev team could look at? Many Thanks, Sean
API CSV import to active SmartSheet
Hello, I have written a program that utilizes the API from smartsheets; for simplicity, it just takes data from a source and imports it to SmartSheets. Problem is, it can only import it on a new sheet, not an active sheet. I understand that there is a tool that was recently developed: Data…
Datamesh
Good Afternoon Does anyone know how to use Datamesh??? I am having trouble getting it working, any tips??? thanks in advance Michael
API.SmartSheet.Com
I have an application that updates a SmartSheet using the available APIs.. The application uses the C# NuGet packages for Visual Studio (2017) The program has been working flawlessly for over 12months now but as of 1am last night (UK time), I no longer am able to connect getting the very basic error of "There was an issue…
Smartsheet API Webhook options
Recently I created a nice working webhook with "scope" : "sheet" and "events" ["*.*"]. But I discovered that I only need the updates on a specific column. Unfortunately "scope": "column" doesnt work. Are these options hidden in the documentation?

Trending in API & Developers

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
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,