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
3
votes
1 answer

What is the expected semantics of the Sheet data? Should null values be returned?

I have a sheet with 18 columns and 137 rows. Some of the columns are empty. When I make the get sheets call (I'm using the C# SDK) the data returned has the following structure which seems anomalous to me ... Columns --- 19 (the RowID is tacked on…
3
votes
1 answer

Smartsheet-API: Populating data and formulas in a sheet

UPDATE 2022-12-01 This question is now obsolete. Smartsheet API now supports the requested feature. The accepted answer contains more details on the update. CONTEXT A developer wishes to populate an existing smartsheet worksheet using the smartsheet…
dreftymac
  • 31,404
  • 26
  • 119
  • 182
3
votes
1 answer

Does Smartsheet API support standard OAuth 2.0 for third-party auth?

I am working on a web app which will need to implement the three-legged OAuth 2.0 flow. The Smartsheet API docs http://smartsheet.com/developers/api-documentation say that the API supports standard OAuth 2.0 flow. On closer inspection, however, I…
2
votes
3 answers

Attribute error: module 'collections' has no attribute 'MutableSequence' PYTHON/SMARTSHEET SDK

I installed the Smartsheet Python sdk, imported the smartsheet module but am getting an error when I want to run the script. The error is localized to the smartsheet module and says that collections module is missing Mutable Sequence. I have already…
jhorvath
  • 21
  • 1
  • 3
2
votes
2 answers

Set Finish Project Column via API

When I attempt to set the Finish column on a row in a sheet via the SmartSheet API, I get the following message: { "errorCode": 1080, "message": "End Dates on dependency-enabled sheets cannot be created/updated. Please update either the…
2
votes
2 answers

Smart Sheet API 2.0 - Error code 1004 on accessing user/me

New to SmartSheet API. I tried to use the example in the API document to access API using my access token curl -s https://api.smartsheet.com/2.0/users/me -H "Authorization: Bearer some-token" I received an error code 1004. { "errorCode" : 1004, …
Mark
  • 31
  • 2
2
votes
4 answers

Python - How to create a pandas Dataframe directly from Smartsheets?

I don't understand how to import a Smartsheet and convert it to a pandas dataframe. I want to manipulate the data from smartsheets, currently I go to smartsheets export to csv and import csv in python but want to eliminate this step so that it can…
2
votes
1 answer

What would be a logical way to put this Smartsheet data in a DataFrame?

My goal is to use the Smartsheet API to take data that is structured just like the data shown below and place it in a pandas.DataFrame object. The issue is that the data has several layers, creating an inconsistent hierarchy. Task …
2
votes
1 answer

Python for Smartsheet - Getting _ipython_canary_method_should_not_exist_

All - I am getting this error when loading the Smartsheet Client I loaded all dependencies as per requirements. What should I fix? ImportError! Could not load api or model class _ipython_canary_method_should_not_exist_ ImportError! Could not load…
2
votes
1 answer

Issue finding "Column IDs" inside report

I want to be able to send a row, from a report, via email with only specific columns via the API. The API docs clearly show you how to send a row via email however, I'm unable to get the column ids inside the report in order to send those specific…
William.Avery
  • 60
  • 1
  • 7
2
votes
2 answers

Using Smartsheet API 2.0 how to get ONLY the 'modifiedAt' property of a specific sheet

I need to get the last modified timestamp property of a sheet using Smartsheet API 2.0 (preferably Python SDK). Ref: https://smartsheet-platform.github.io/api-docs/ https://github.com/smartsheet-platform/smartsheet-python-sdk Using…
Raunak
  • 3,314
  • 1
  • 22
  • 28
2
votes
1 answer

What is the Smartsheet Date format?

Smartsheet.Api.InvalidRequestException: 'The value for cell in column 324579127256964, 19/04/2018, did not conform to the strict requirements for type DATE.' I'm receiving the above error trying to insert 19/04/2018 into a column programmatically…
luigivampa
  • 377
  • 7
  • 22
2
votes
4 answers

Indent rows with Smartsheet API with Java

I am trying to write a simple program in Java using the Smartsheet API that goes through a fairly large sheet, and indents certain rows. Here is some code similar to what I'm using. Smartsheet smartsheet = new SmartsheetBuilder().setAccessToken("[My…
2
votes
1 answer

Updating cell format using Smartsheet API (Python SDK)

I'm trying to write both values and display formatting to a smartsheet. I access the sheet with: import os import re import logging import smartsheet file_pssw = open('path2accesstoken/smsht.txt','r') aux = file_pssw.readlines() access_token =…
C. Zak
  • 23
  • 3
2
votes
1 answer

Auto populate rows in smartsheet from SQL Server

Is it possible to use Smartsheet's API to auto-populate data from SQL Server? I'd like to extract data from SQL Server to Smartsheet. I have 5 columns ITEMID, Name, Type, Cost, Location. If I enter an Itemid, the code should look in the database…
Jay
  • 23
  • 3
1
2
3
35 36