API & Developers

Archives for October 2019

Drag & Drop Emails from Outlook to Smartsheet in Chrome & Email is Deleted from Outlook
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook. * Windows 10 Pro for…
Unable to update a Summary field of type DATE using the C# SDK
Hi Smartsheet Community! This is my first post and I hope not to scare you away. I've been finding the community amazingly helpful in everything I've been doing so far. Now I'm blocked and I hope someone can give me a hand . I'm trying to set a Summary field "Project Due Date" across multiple sheets.This Summary field is…
Add Image (via binary not file) as attachment (and in cell)
Hi, I am using the C# API to interface to Smartsheet.... I can see how to add attachments and images in cells but these only accept a file name as a parameter. My images are stored in a database, is there a way to upload the images binaries instead of from a file name ? thanks Dave
Integrate with Bank Feed
Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
Document Management Systems
Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their implementations. (how well it integrates with SS, potential problems). It doesn't have…
[PYTHON API] Adding an new row with date column
Using the python SDK, I'm having trouble adding a new row to a sheet where one of the columns is a DATE column. For ex, doing: cell.value = datetime.datetime.now() with the column type as DATE doesn't assign anything to the column, and the request comes back with an error since the cell.value is empty. If online I switch…
Live Tracking User Metrics Using Power BI
Hello smartsheet Community, I want to track company smartsheet user metrics such as the number of users, number of sheets, user types, etc. automatically using Power BI. Currently, I am exporting the user and sheet access reports and having to combine them into a single view before displaying the data in a meaningful way.…
LastLogin is Null when pulled through Smartsheet API
I'm using C#. After authenticating, the following code returns null for all LastLogins. It works for other fields I'm pulling such as Id, Name, Email, SheetsOwned, etc. Is there an issue with that particular field coming through the API? Since it is a date field, does it need to be treated differently, though I am only…
New Comments window
The other day our comments pop up box went to the classic pop up square box in the middle of the page to a slide out from the left side. Terrible Idea now it cover a third of the page and I am constantly opening and closing to see the date behind it . The pop up box was better because it could be moved around the page to…

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

unable to move a row in Python
I use Smartsheet to govern a project that does ~10k tasks per year so automating as much of the project is extremely helpful. I have multiple python scripts that are updating sheets and grabbing data form sheets but this is the first time i have tried to move data in a sheet. I am trying to move a row below another row…
Snowflake Data into Smartsheet?
Hey everyone, Do you know if there is a way to connect Snowflake data into Smartsheet using the API? I have found many resources on getting Smartsheet data into Snowflake but nothing on the other way around. We are trying to either do something native within Smartsheet or use an open-source software such as Airbyte.
Parsing Multi Picklist through API
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…

API & Developers

Discussion List