-
API VB EXAMPLES??
Why are there no VB examples shown in your "Smartsheet API 2.0" documentation when you have a VB example by the name of "vb-read-write-sheet"?? It would be VERY helpful if you included VB example code along with all the other languages you provide. Please tell me if you intend to add this?? Thanks David
-
Using Google Calendar shared with me
Hi, I've tried and successfully implemented the feature of publishing to Google Calendar. However, it requires that the target Google calendar be a calendar that I own, rather than one that is shared with me even though the shared calendar grants me editor rights. Is there a work around?
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
-
Allow multiple sheets to be selected for the same new Alert
Allow the same new Alert to be created for several selected sheets at the same time. When starting a new project, I take a workspace and Save As New to get the sheets, reports, and folders. It would save time to be able to set up all the new Alerts on the new sheets at once. This would not be needed (for this use case, but…
-
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…
