-
Auto Sort sheet using API - Python
I have a code that should work to auto-sort my sheet, but I keep getting the message below. Others have used this script with no problem. Any advice would be greatly appreciated. Error sorting sheet. Status code: 405 "errorCode" : 1122, "message" : "Requested URL does not support this method: PUT", Here is the script I…
-
Move a row to a new sheet based on an entry on a separate sheet
Hello, My company has a sheet titled active employee roster which has every employee in the company. We are trying to create a new Offboarding sheet that will then find the employee on the Active Employee roster sheet and then move them to a 3rd sheet labeled Offboarding Archive. I am struggling to create a solution for…
-
How to eliminate leading apostrophe from values when updating columns via API
Hi, I currently have a C# application that updates a few smartsheets and am struggling with leading apostrophes in most columns I'm updating. All of the columns are marked as Numeric/Text, and all data types of values being pushed are varchar/strings. However it seems that if the value being pushed does not contain any…
-
Sharing Dynamic view on MS teams Tab
I recently created a dynamic view that I wanted to share within my Microsoft Teams Tab after attaching it showed me this I decided to add it to a dashboard and then bring it to MS Teams Tab but I got the same response. I am trying to figure out a way my team can have access to their views and make changes through MS Teams…
-
Connect WordPress form to Smartsheet for Record Keeping
Is there a way I can populate a Smartsheet with entries from a WordPress form? We use the Gravity Forms Addon
-
Can I change the email that Smartsheet sends emails from using the API
I have a Bridge workflow set up and I'm calling the Send Rows API call to email out what I need. The problem I'm running in to is I don't want the emails coming from my email address. I've tried to save it using a service account to see if it would send from there instead but still shows mine. Any ideas how to change that?
-
Row Link Column
Inside Row Properties, with the API, and with Bridge, you can extract the row specific URL. It would be very helpful if that was just a system column like created or modified.
-
Are others having sporadic API issues? An unexpected error has occurred
In the past couple of days, we've had API processes that have ran fine for months, start to have issues. The error we seem to be most commonly seeing is error code 4000, "An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assistance." We're starting to sporadically…
-
Why does the API require the row id to add a row?
Hi. I want to add a row with the API. I therefore use the Add row method. This method requires to use the row object. The first attribute of the object is the row's id. What sense does it make to request the row id to add a row? If I attempt to add a row without a row id, I get the following error message: ... "errorCode":…
-
Update Rows via API started to fail recently
I have created an automation in Alteryx to Insert/Update/Delete row data via the API. Everything worked perfectly until sometime this month. The Insert and Delete parts work fine, but when I try to do the Update, I get an "Unable to parse request" message all of a sudden. An example payload I'm sending looks like this:…