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
2
votes
2 answers

smartsheet api update rows error 1004. you are not authorized

I am trying to use powershell and the API to update a cell, but I get an error: 1004 You are not authorized to perform this action. I've elided the IDs . . . I have a 30 day trial. Do I need to buy in to some level of support before I can use the…
Josh
  • 23
  • 5
2
votes
1 answer

Live Link Smartsheet Cells to Google Sheet

Looking for a way to sync Smartsheet with a Google Sheet such that they both update in real time. I have written a Google Apps Script for a Google Sheet. Trying to avoid going API route. Im not a developer.
Adam McKinstrie
  • 21
  • 4
2
votes
4 answers

Iterate through all rows Smartsheet API Python

I am trying to iterate through all the rows in a sheet, but it seems that simply using .rows is limited to returning 100 items. for temp_row in inventory.rows: x += 1 print x #X will always return <= 100 No matter how many items I have in…
JHWelch
  • 45
  • 6
2
votes
1 answer

Smart Sheet Row calls not getting information or working

I'm trying to use the row attribute created_by accessing it with the Python SDK and it keeps throwing an error. I'm not sure if I'm missing something. Every time I try to use it I get the error: File…
JHWelch
  • 45
  • 6
2
votes
3 answers

Smartsheet CHECKBOX Cells Always Returned as Empty

Whenever I retrieve a SmartSheet row and loop through the cells within it, all cells of type CHECKBOX always have a displayValue or value of Null, regardless of the status of the checkbox on the sheet. Has anyone else experienced this? (I am using…
condad
  • 1,765
  • 2
  • 12
  • 9
2
votes
2 answers

How do you Get New Access Token for SmartSheet API

I'm having problems with Get New Access Token for Postman and SmartSheet. All URLS are prefixed with https:// but StackOverflow would not allow that. Callback URL: www.getpostman.com/oauth2/callback] Token Name: Test Auth URL: …
David Gilmore
  • 21
  • 1
  • 3
2
votes
1 answer

Copy a sheet in Smartsheet using Java API

I am trying to use the Smartsheet API 2.0 in java to copy an existing sheet to a new sheet in an existing folder. I would like to include the data, attachments and discussions. I have tried setting the include parameter to SheetCopyInclusion.ALL as…
T R
  • 23
  • 2
2
votes
1 answer

cannot write cell values in Smartsheet

I've been able to read sheets, rows, columns, and cells using the Python SDK for Smartsheet, but I haven't been able to actually change/write/update a cell value. I've simplified my code quite a bit and I'm left with this: import smartsheet MySS =…
doron
  • 258
  • 2
  • 11
2
votes
1 answer

Smartsheet-api and Python SDK certificate verify failed

I am having a basic problem with the SmartSheet Python SDK. I am using Python 3.4 Using the following sample code from the SmartSheet docs: import smartsheet smartsheet = smartsheet.Smartsheet(MY_TOKEN_HERE) me =…
jim99
  • 89
  • 1
  • 2
  • 8
2
votes
2 answers

Smartsheet c# SDK Parent-Child

In the Smartsheet c# SDK, the row.ParentRowId is helpful, but I'm not seeing a means to determine what level in the hierarchy a given row is? For example, if I have something like... Project Name Section 1 Task 1 Task 2 Section 2 Task…
Ken
  • 41
  • 3
2
votes
2 answers

Is it possible to import an excel file to smartsheet API?

Are there any functions or methods in smartsheet API 1.1 that allow you to create a new sheet or update an existing sheet based on an csv or xml file?
T A
  • 63
  • 1
  • 6
2
votes
1 answer

Error 1030 when I try to modify a Smartsheet

I have a php page that lists the smartsheet content for different users. It populates a table with information like the name of a job, the start date and delivery date. But I would also like the users to be able to tick a checkbox when the job is…
user2545452
  • 53
  • 3
2
votes
1 answer

Can I detect cell properties such as color in Smartsheets using REST API

I am using a JSON string produced from smartsheets with the intention of selecting specific values and adding them to an sql database. Because this is set up by a user the structure of the smartsheet isn't ideal for putting into an SQL database so I…
Danrex
  • 1,657
  • 4
  • 31
  • 44
2
votes
1 answer

Unable to call an api in JavaScript (cross origin)

I wrote the following JavaScript to call a Smartsheet API: $.get( "https://api.smartsheet.com/1.1/users/sheets", "Authorization: Bearer [My Access token]" ) .done(function( data ) { alert( "Data Loaded: " + data ); }); But this threw the…
raul
  • 1,209
  • 7
  • 20
  • 36
2
votes
1 answer

Save smartsheet as .xls on server (curl / php)

i want to save a smartsheet to my server (as .xls). But i always get an .xls filled with json-code. I get the "file_put error" if i use json_decode(..) and the .xls is completely empty. If i do it via curl on my desktop i get the right .xls filled…
LLLen
  • 23
  • 5
1 2
3
…
35 36