API & Developers

Archives for November 2018

Smartsheet API Request Limit
Hi there, I'm hoping you guys can help me understand a problem I'm having, and maybe help me figure out a solution to it! I'm using Zapier to input some data in to a smartsheet. The problem I'm having is that every so often it will try to input about 100 data points at once, at which point I get a tonne of emails telling…
View Pictures on Mobile App
I love the ease of uploading photos to my SmartSheets. Viewing these photos is perfect from my laptop, it opens another tab and I can zoom or download the image. I'm looking for similar features in the Mobile App. I run Android. I cannot seem to open pictures beyond a thumbnail. Any advice?
C# API Media type not supported - Error 1124
Hi Guys, Trying API for first time. I am able to do GET sheet details successfully. But when i post to create new row/column i am getting the following error "Invalid Content-Type header. Media type not supported" for the below code var client = new RestClient("https://api.smartsheet.com/2.0/sheets/239613.../columns"); var…
Processing Limitations: List of formulas in order by relative processing power required?
Hey Community! One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere. My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical volumes as often as…
Revert to older version
Can I revert to an older version of a sheet from last night? In the history I don't see where someone sorted the rows, so I'm not sure what happened? I thought there was a way to revert to a certain time of day? I don't know anything about a back up so this information would be helpful too?
Smartsheet connection with Alteryx workflow
Hi, Someone facing an issue to connect data from Smartsheet into workflow in Alteryx? I have an Alteryx with data connected from Smartsheet that always worked well, but last friday the alteryx wont able to connect with Smartsheet, the message in Alteryx is "No valid Fileds were selected. This connection between Alteryx and…
Project Settings API
Does anyone see how to set the project date range in the project settings through the API? I need to create a trigger that changes the dates that respond to the predecessors from one set of dates to another set of dates.
Add row with multiple values in cell using c# sdk
One of columns has 'Contact List' type with checked 'Allow multiple contacts per cell' see example. I tried to add row using smartsheet-csharp-sdk(v2.3). Cell object: new Cell { ColumnId = 111111, Value = "Test@test.com", Strict = false } and I got the next error: { "errorCode": 1235, "message": "Value is not supported for…
Dashboard Widget
Hi, Is it possible to create a dashboard widget that contains an <iframe> with contents from another external site? // Leif
ODBC Connections and Outside Apps
Hi all, Hoping i can find some recommendations that can assist with an app development. I am creating a simple VS2010 Visual Basic app and report that will create purchase orders using smartsheet as the database back end. I have unlocked the smartsheet potential in ODBC connection but I am wondering if anyone has…

Trending in API & Developers

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…
Smartsheet Bridge special characters not encoding in endpoint URL
Has anyone ran into this issue? I would like to parse an ISO formatted time into the endpoint URL, but it's not encoding "+" to %2B. My particular use case is getting the latest CVEs from Vulnerability APIs (nist.gov) The endpoint should be formatted as such:…

API & Developers

Discussion List