Stack Overflow
Stack Overflow

Questions tagged [smartsheet-api]

The Smartsheet API provides developer access to Smartsheet features and data

The Smartsheet API provides a REST interface to Smartsheet features and data. The API enables Smartsheet customers to programmatically access and manage their data, and empowers application developers to build solutions on top of Smartsheet.

For more information about the Smartsheet API, please visit and bookmark the Smartsheet Developer Portal. There, you’ll find links to the API Documentation, SDKs and sample apps, and other ways Smartsheet can make your API integration easier.

Repositories of sample projects can also be found on the Smartsheet Platform GitHub page at https://github.com/smartsheet-platform.

Smartsheet, a leading Software as a Service (SaaS) company, offers businesses an intuitive online collaboration tool. The ease of use of the familiar spreadsheet-like interface, coupled with file sharing, work automation and Gantt chart features, have made it a popular and highly functional collaboration and project management tool for nearly 2 million users. Customers include construction companies, consulting firms, schools and universities, utility firms, government entities, healthcare organizations, high-tech firms, non-profits, manufacturing and law firms, among others. Additionally, Smartsheet offers mobile apps, pre-built templates and integrations with leading cloud apps such as Box, Dropbox, Salesforce, Google Drive and Zapier to ensure users are up and running quickly. Visit http://www.smartsheet.com for more details.

530 questions
1
vote
1 answer

How do I write the Smartsheet response to a file?

I'm trying to write some basic code to retrieve the list of workspaces and write the response to a file. I thought that this could be dumped to a JSON file? Thanks for any help/suggestions. I have taken the sample .py file and reworked it to look…
Sean Williams
  • 11
  • 1
1
vote
1 answer

How to get python API to access Smartsheet

I am following the smartsheet API's python-sdk example to do some practice. Below are my steps (using Python 3.4.4 on macOS 10.7.5): installed the SDK package from their GitHub repo installed pip using pip install smartsheet-python-sdk in my …
Maggster
  • 51
  • 6
1
vote
1 answer

How to pass current rowID to CopyOrMoveRowDirective statement using C# and the Smartsheet-API?

I have code in C# that moves a row from one sheet to another, but I can only get it to work when I hard code the row id in the CopyOrMoveRowDirective line. What is the syntax for passing a row id into the statement? I have tried rowm.ID in place…
Mike H
  • 31
  • 3
1
vote
1 answer

How do I send binary buffer in Nock Get request?

Nock version: ^10.0.4 The request below always returns response as String. I need JSON format instead. Right now I cannot get res.data(return undefined), but I can see res as String. How do I get JSON format of the response? Here is my request:…
user1874435
  • 161
  • 13
1
vote
1 answer

Is there a way to access Smartsheets Workspace Attachments via API (not attached to any smartsheets but only to workspace)

I am looking to access attachments at a workspace level of a smartsheet. They are not attached to any smartsheets but attached to the root of a workspace only. Is there a way we can access these objects via API? Thanks
IDS
  • 11
  • 1
1
vote
1 answer

Smartsheet API Set text in date column

Using the C# api, is there any way to set text into a DATE column using the api ? I could not find any example or workaround to set string into a DATE column, and getting this error : Date, did not conform to the strict requirements for type…
Etienne Mermillod
  • 276
  • 1
  • 9
1
vote
1 answer

I can't package my program with Pyinstaller because I have enum34 installed, can't uninstall because a used module needs it. Any suggestions?

So I am trying to package a program I wrote for my job that allows people to add, update, delete the same row/columns over multiple spreadhseets (@ Smartsheets) at the same time. I am using Kivy, and the Smartsheet-Python-SDK When I go to package…
Matthew Palumbo
  • 25
  • 5
1
vote
1 answer

Created System Column Blank In API Call

I am making REST calls against the Reports API endpoint, and pulling that data into a separate application. I am able to pull all of the report columns with its data, with the exception of the Created (System Column), which always returns…
John R
  • 11
  • 1
1
vote
2 answers

Bulk Operations - Adding multiple rows to sheet

I'm attempting to write data from a data table to a sheet via the smartsheet API (using c# SDK). I have looked at the documentation and I see that it supports bulk operations but I'm struggling with finding an example for that functionality. I've…
Channing
  • 129
  • 2
  • 12
1
vote
2 answers

Evernote Zapier

I use Evernote in meetings every day and when I have a task I tag the task with a checkbox. What I would like to do is to use Zapier to read new Evernote notes and if there is a checkbox in a note I would like for the item to appear in my ToDo list…
Donald Davis
  • 13
  • 2
1
vote
1 answer

Smartsheet API Resourcenotfooundexception Creating new sheet

I am creating a new sheet in Smartsheet via the API in Visual Studio 2015 C#. I have followed the code/API Guide from Smartsheet but i get an error at run time when the code fires. The error is as follows: Smartsheet.Api.ResourceNotFoundException…
Andrew Little
  • 27
  • 1
  • 7
1
vote
1 answer

Smartsheet - add row with multiple values in cell using c# sdk

One of columns has 'Contact List' type with checked 'Allow multiple contacts per cell' see example. I tried to add row using smartsheet-csharp-sdk(v2.3). Cell object: new Cell { ColumnId = 111111, Value = "Test@test.com", …
o.jev
  • 13
  • 3
1
vote
1 answer

Is it possible to create a new sheet in Smartsheet API without copying from an existing one

With Smartsheet API, I cannot find an API call to create a new sheet and define its columns directly. Is this possible and if so, how? I'm using the cData FireDac component which is very friendly to SQL. Thanks!
Bill Seven
  • 768
  • 9
  • 27
1
vote
3 answers

Python: Best way to get smartsheet Sheet by name

I'm looking to find a sheet via the Smartsheet api and all I have is the name of the sheet. I'm currently solving it like this sheet_name = 'The sheet I have the name of' sheets = ss_client.Sheets.list_sheets(include_all=True).data sheet_id =…
af3ld
  • 782
  • 8
  • 30
1
vote
3 answers

Add rows in smartsheets using python

How do I take a list of values, iterate through it to create the needed objects then pass that "list" of objects to the API to create multiple rows? I have been successful in adding a new row with a value using the API example. In that example, two…
Tyler Baker
  • 23
  • 1
  • 7
1 2 3
…
35 36