Product questions?
Ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Sync to Googlesheets via API?
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 making that happen. Thanks,
SSIS package to read Smartsheet data to export the data into SQL database
I need to bring data from Smart sheet data into sql server using ssis. can anyone suggest the steps.
Column Type difference between API and GUI
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 through the API results in a success returned, however the subsequent re-query returns…
Python API
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 = os.path.dirname(os.path.abspath(__file__)) # The API identifies columns by Id, but it's…
C# SDK - A strongly-named assembly is required
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 1.0 deprecation on 3/31. I updated the SDK to to the newest version using the NuGet manager…
Usage metrics
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. Webhooks is one way (not exactly), but that also we can create per sheet (not all the…
% allocation and duration aren't linked. Will they ever be?
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
Bulk Report Update
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 report and attach the new sheet. This is tedious and time consuming. I've even tried to…
Integration with SAP
Hi all, Purely out of interest at this stage, but has anybody built any integrations between Smartsheet and SAP, just like there are for Netsuite, Salesforce etc ? If so, which integrations have you built and how did it go? I'd also be interested to hear if this is on the roadmap at all. Thanks! Maarten
Can Smartsheets make API calls to external APIs
I'm working on a project at the moment to create and edit smartsheets from an external application, however can Smartsheet do the reverse and retrieve data from external APIs?

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List

Categories

Popular Tags