API & Developers

Connect with other developers using the Smartsheet API.

Discussion List

  • Sync to Googlesheets via API?
    In API & Developers
    Hey, 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 …
    349 1
    349 views 1 comment Most recent by Andrée Starå
  • SSIS package to read Smartsheet data to export the data into SQL database
    In API & Developers
    I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.
    886 1
    886 views 1 comment Most recent by Andrée Starå
  • Getting last login information via API call
    In API & Developers
    I 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…
    167 1
    167 views 1 comment Most recent by dAVE Inden
  • Column Type difference between API and GUI
    In API & Developers
    Hi 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…
    54 2
    54 views 2 comments Most recent by NotSoSmartSheet
  • Python API
    In API & Developers
    Greetings 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 =…
    786 1
    786 views 1 comment Most recent by dAVE Inden
  • API for linking MS Excel to SMARTSHEET
    In API & Developers
    Greetings 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…
    2605 6
    2.6K views 6 comments Most recent by Richard Rymill SBP
  • C# SDK - A strongly-named assembly is required
    In API & Developers
    Edit - 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 …
    1835 2
    1.8K views 2 comments Most recent by dAVE Inden
  • Usage metrics
    In API & Developers
    Hi 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. …
    272 3
    272 views 3 comments Most recent by amitk
  • % allocation and duration aren't linked. Will they ever be?
    In API & Developers
    Hi 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
    12 1
    12 views 1 comment Most recent by Andrée Starå
  • Bulk Report Update
    In API & Developers
    Has 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 …
    171 6
    171 views 6 comments Most recent by Paul Newcome