-
python api proxy issue
I am new to this. Trying to write a basic python script that uses the smartsheet api. It runs fine from my home desktop, via python for windows. However, when I run it at work on my laptop, I am encountering the '[WinError 10061] No connection could be made because the target machine actively refused it' error. I am…
-
using CURL and windows batch file to POST many rows at once
Hi guys, So I’ve been playing on & off with Smartsheet API and have been able to post a row on a sheet succesfully using CURL on Windows via a batch file. Now I need to do the same but for multiple rows from a CSV file. I read that I could do so if I insert an array variable per column within the json part of the CURL…
-
Does SmartSheet support any CURL to get the total row count in a sheet?
I am using curl with REST to access Smartshets in my C# running on WIN CE. My application is supposed to dump some data on smartsheet periodically. Before I write to a sheet, I would like to know the total row count in the sheet so that I don't exceed 5000 rows per sheet. I am looking for an API that would return just row…
-
Automated App Integration Platform
Hi All, We have been using Azuqua to automate our data connection between Smartsheet and our other cloud software platforms. The Smartsheet recommendations such as Zapier are too simplistic for our needs. Since Azuqua was recently purchased, it will no longer exist in a year. Does anyone have recommendations for…
-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
-
What does smartsheet.models.duration.Duration().elapsed do ?
Hello, My question is in the title. I've been trying to play with that but it does not seem to have any impact on duration behaviour, whether it is in the duration column or as a lag for a predecessor. Thank you
-
Using smartsheets as a CRM
Hi everyone, In Smartsheets, I am trying to create a contact data base with a status trigger from a drop down menu... when "Lead Status" changes from "Lead" to "Opportunity" it triggers a bunch of actions I have set up through Zapier to set up the next steps, files, folders, etc. in Smartsheets and GSuite. Does anyone know…
-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
How to empty objectValue ?
Hello, I'm using the API to change the predecessors of rows, mostly delete some entries to the predecessors field so I can then safely delete the row that was a predecessor to others. I assume it works for rows to update them with a new objectValue field that contains the same predecessors as before minus the one I want to…
-
Calculate/Compute the duration between two dates in working days
Hello, I'm back for more need in API tricks. Here's my case : because we can't edit the finish date of a task from the API, I need to find a way to make a task end at the date I want. For this, I either have the beginning date of my task, so I just need to find the duration to put in the corresponding field to have my task…
