API & Developers
Connect with other developers using the Smartsheet API.
Discussion List
-
Sync to Googlesheets via API?In API & DevelopersHey, has anyone successfully created a sync from Smartsheets into GoogleSheets to sync data from Smartsheets into Google Sheets? I am looking for some samples or for someone to say they have done it and point me in the right direction for …
-
SSIS package to read Smartsheet data to export the data into SQL databaseIn API & DevelopersI need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.
-
Getting last login information via API callIn API & DevelopersI am hitting the users endpoint(https://api.smartsheet.com/2.0/users) to get all of our user information. I am trying to find out inactive users based on last login date. The API call doesn't return me the last login information for any us…
-
Column Type difference between API and GUIIn API & DevelopersHi All, I have a somewhat confusing issue within a sheet where the API is reporting a different column type to the interactive gui. Attempting to force the column shown by the API from TEXT_NUMBER to MULTI_CONTACT as per the GUI th…
-
Python APIIn API & DevelopersGreetings I am trying to execute the sample API code on GITHUB, in python for me to read and write sheets. I don't understand the use of the following line of codes. Do I need to replace _file_ ? and what do I replace it with ? _dir =…
-
API for linking MS Excel to SMARTSHEETIn API & DevelopersGreetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to up…
-
C# SDK - A strongly-named assembly is requiredIn API & DevelopersEdit - I started from scratch rebuilding it, and that solved whatever bug was causing the issue. I still have no idea what was wrong. I'm using Visual studio/C# to make a dll for Office/VBA automation. This was working until the TLS …
-
Usage metricsIn API & DevelopersHi Smartsheet community, I am trying to create an app that fetches usage statistics/metrics for a given smartsheet account (like number of sheets or items created, edited, opened, etc), but couldn't find any API which could do the same. …
-
% allocation and duration aren't linked. Will they ever be?In API & DevelopersHi does anyone know if % allocation and duration will ever be linked? And no, I don't want to create yet another column with a calculation to do it for me. Thank you! Karen
-
Bulk Report UpdateIn API & DevelopersHas anyone come across a way to update the criterial for multiple reports at once? We have several reports that all draw from the same set of sheets. Every time we start a new project (and thus create a new sheet), we have to go to each …