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

How to update a row of cells in Smartsheet API 2.0

I recently wrote a program using the API 1.1 to automatically update a sheet and it uses the line smartsheet.rows().updateCells(rowId, cells); to update a row of cells in the sheet. In the 2.0 version rows() has been deprecated but I still can't…
T A
  • 63
  • 1
  • 6
0
votes
1 answer

Smartsheet Java SDK - AssertionError: "Primary Column" has null Id

I'm having an issue getting column IDs back for a sheet. Below is my unit test that is failing. Any thoughts about what I'm doing wrong? It doesn't look like the ID is getting into the Column model. It is failing with: java.lang.AssertionError:…
Brett
  • 2,502
  • 19
  • 30
0
votes
1 answer

Smartsheet 2.0 api return all sheets in your account

Just started making a program to upload data into a smartsheet. Problem is i am getting the error "Invalid Accept header. Media type not supported. " its happening here connection = (HttpURLConnection) new URL(GET_SHEETS_URL).openConnection();…
Bryan
  • 55
  • 1
  • 8
0
votes
1 answer

How to reference array from HTTP GET request?

I'm making a script for my hubot that's supposed to print out all of the items of a column in a Smartsheet document. Unfortunately, one cannot simply print all elements of a column, as the cells are primarily stored in rows. In order to reference a…
jwilso48
  • 1
  • 2
0
votes
2 answers

C# SDK Not Showing the Smartsheet-API namespace as an available reference

I'm having a problem understanding how to use the API 1.1 in Visual Studio 2010 Professional. Image 1 below proves the install of the SDK was successful. This is the good news. My problem is I can't reference the Smartsheet.API namespace. When…
Ken
  • 11
  • 1
0
votes
0 answers

Having trouble with HTTP request from Smartsheet API in CoffeeScript

Preface: It's been a while (2 years) since I was in AP Comp Sci, and I've never worked with CoffeeScript, hubot, HTTP requests, or an API before last week. Pls be gentle. At my job, I've been making a bot (implementing GitHub's hubot) for our Slack…
0
votes
1 answer

folder.getSheets() returning null?

I'm trying to go through and entire workspace and list each element in a treeview, but when I attempt to grab the sheets in the found folders the getSheets() method in the Folder class always returns null. Am I doing something wrong? …
0
votes
1 answer

Creating reminders and alerts with Smartsheet API

I'm wondering how to create new reminders via the Java Smartsheet API. I haven't been able to find anything related to that. I thought it might be in the Row or RowResources class. Here is a quote from the launch of the API claiming that it can be…
0
votes
1 answer

Smartsheet data into Gridview

I am quite new to Smartsheet and programming using c#. Mostly a beginner and trying to use visual studio 2013 to integrate my web application with Smartsheet. I am currently struggling with getting a gridview control to populate with the returned…
Nayshil
  • 53
  • 4
0
votes
2 answers

Retrieve all rows in a SmartSheet using Python SDK

I am trying to retrieve all rows in a smartsheet via the python sdk using this function: for row in range(1,sheet.totalRowCount+1): print sheet[row][0] This works well in a test sheet with sample data. However, when I run the same exact lines of…
AME
  • 5,234
  • 23
  • 71
  • 81
0
votes
2 answers

Finding a column value where columnID equals xxxx in JSON using C#

I am using C# to grab values from a JSON file and put them into a database. I am new to JSON and so don't really know too much of how to work with it. I will do my best to explain the structure I have and what I am trying to do. But to sum up I am…
Danrex
  • 1,657
  • 4
  • 31
  • 44
0
votes
1 answer

How to get the attachment url from smartsheet api

I am trying to get the attachment url in $getAttachmentURL so it is possible to download the file. I get the error code 1006 - not found.
0
votes
1 answer

Missing SDK but it's there?

I have created a webform that runs an executable. The executable accesses smartsheets, downloads that information to excel, and then adds info from excel into an SQL database. It then removes that smartsheet and replaces it with a blank template for…
Danrex
  • 1,657
  • 4
  • 31
  • 44
0
votes
1 answer

Connect Excel to Smartsheet via Power Query

I have been trying to pull data from one of my Sheets in Smartsheet using Power Query without no luck. I generated an API token from Smartsheet that I used in the Power Query Wizard but still failed.
Ivan Oboth
  • 41
  • 6
0
votes
3 answers

How to retrieve only the newest rows via the Smartsheet API

I need to be able to retrieve only the newest (most recently modified) rows via the Smartsheet API. The only way to get a sheet's rows seems to be via the Get Sheet call here: http://www.smartsheet.com/developers/api-documentation#h.4930jur8qsvs I…
ryeager
  • 90
  • 4