-
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:…
-
How to determine the workspace ID & Name and folder name if I only have the sheetID?
Hi, I am using the Smartsheet API for Python. I can determine the workspace names and IDs. I can determine the Sheet name and ID. However, I need to know which workspace (ID & Name) and under which folder of that workspace a specific sheet (per sheetID) resides. How do I do that using python, please? Thank you.
-
How to prevent Smartsheet API from converting certain strings to integers
Hi all, I am not sure if Smartsheet recently changed how strings and integers are formatted, but my API script has seemingly randomly began converting certain string values to integers automatically. For example, a string that leads with 0s such as "0450" is now being put into the smartsheet as just 450 and it shows up as…