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
12
votes
4 answers

Error while trying to use an API. java.lang.NoSuchFieldError: INSTANCE

I am trying to connect to the smartsheet api using a java program. Initially I had problems with the site certificate which was resolved by adding it to the java keystore. Now when I am trying to run my code, I get the following error. Exception in…
mahacoder
  • 895
  • 3
  • 14
  • 29
9
votes
6 answers

Require is not defined nodejs

Trying to use this smartsheet api: http://smartsheet-platform.github.io/api-docs/?javascript#node.js-sample-code and its telling me to do this for nodejs: var client = require('smartsheet'); var smartsheet =…
johnnE
  • 169
  • 1
  • 1
  • 11
5
votes
1 answer

Retrieve row data from smartsheet in C#

I am hoping to be able to retrieve rows of data as a list from specific columns within C#. So if there was a column of person heights it would list those heights in a list. Potentially also list x,y values say number of apples on a particular date.…
Danrex
  • 1,657
  • 4
  • 31
  • 44
4
votes
2 answers

How to get the array of sheet ids in a folder with python

When I try to get the id array from the get.folder() call (by using folder = folder.sheets.id), I get the answer: "AttributeError: 'TypedList' object has no attribute 'id'" I'm not sure what function to call in python to get the array of sheet ids…
adamcoolcat
  • 105
  • 7
4
votes
2 answers

How can I call to Smartsheet API using Google Apps script?

I have used Postman and Charles to see if my Smartsheet GET function works, and all is well, I get the data json string back. I have tried running the call from local code and from a Google app script html page. But I get this error from the…
Jason Allshorn
  • 1,625
  • 1
  • 18
  • 27
4
votes
3 answers

Some simple examples of Smartsheet API using the Python SDK

I am newbie to the Smartsheet Python SDK. Using the sample code from the Smartsheets API doc as a starting point: action = smartsheet.Sheets.list_sheets(include_all=True) sheets = action.data This code returns a response just fine. I am now…
jim99
  • 89
  • 1
  • 2
  • 8
4
votes
1 answer

How to get list of rows of selected sheet in Smartsheet using REST?

I'm trying to get list of rows of selected sheet. I went for REST API for rows List of row's related calls but didn't get any resource to get list of rows. How can I get list of rows? or the REST call have not been written yet.
abdulbarik
  • 6,101
  • 5
  • 38
  • 59
4
votes
1 answer

How to send file attachment using smartsheet api sdk

I want to send file attachment from fileupload into smartsheet. I was using sdk, I found a sample code for attachment. This my code for attachment: if (fileUpload.HasFile) { string fileName = fileUpload.PostedFile.FileName; …
Fauzi88
  • 713
  • 3
  • 11
  • 23
3
votes
2 answers

How can I run a python script without using a python editor that includes the smartsheet sdk

One solution I have been trying to convert python scripts into .exe files using things like py2exe and cx_Freeze, but I keep getting errors after running the cmd. Is there any other solutions you guys can think of, or should I just keep trying what…
adamcoolcat
  • 105
  • 7
3
votes
1 answer

How to find a row ID or column ID in smartsheet?

I've been working with and reading the smartsheet API for a few hours now and I notice that in all the requests I have to make, I will need either a row ID or a column ID. I must be missing something easy here, but where do I find these IDs? Are…
A. Cabiness
  • 41
  • 2
  • 4
3
votes
1 answer

List and delete pending update requests in Smartsheet

I've been able to Create Update Request with both Postman and the Smartsheet Python SDK, but I can't find a method in the API documentation to list pending update requests or delete pending update requests. Does anyone know how to do this?
doron
  • 258
  • 2
  • 11
3
votes
1 answer

How to pass query string parameters to Smartsheet API with node.js?

I need to get a list of all columns in one request and manual states that I should pass query string parameter: Most index endpoints default to a page size of 100 results. If you need all results at once, you should specify the includeAll=true…
untitled
  • 1,037
  • 2
  • 12
  • 27
3
votes
1 answer

Error: adding rows with smartsheet API

I can't seem to get a add row(s) to work. I get the following error, but I believe the data is formatted correctly. Thanks in advance! {"errorCode":1008,"message":"Unable to parse request. The following error occurred: Request body must be either a…
itsallgood
  • 33
  • 3
3
votes
0 answers

Smartsheet and Jira with Data Tracker

I'm stuck setting up a Jira instance with Smartsheet. I've followed the Tutorial and I've got to the point where I've got the logs shown below and I'm stuck to know where to go next in trying to get it to work! (I am using python 2.7.6.) I believe…
cbarlow123
  • 217
  • 5
  • 18
3
votes
1 answer

Update cells in smartsheet

I am trying to update some cells in an existing SmartSheet sheet with PHP. It's no problem to add new lines but I can't get the correct JSON for updating. My code at this moment: $ch =…
user3763120
  • 65
  • 7
1
2 3
…
35 36