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 to retrieve the Predecessor or PredecessorList Object from Smartsheet Python SDK

I'm trying to retrieve the ObjectValue attribute from the Cell object so I can get to either the Predecessor object or the PredecessorList object. I've tried adding include="object_value" or include="ObjectValue" or various other spellings to…
J. Craig Williams
  • 380
  • 1
  • 2
  • 18
1
vote
1 answer

How do I get the ID of a new folder/sheet that I have created from a copy?

When I make a copy of a folder in smartsheet, is there a way to get the ID of the new folder? What I have tried so far is this: inc_list = ['all'] # you can add other parameters here, separated by a comma response = ss_client.Folders.copy_folder( …
adamcoolcat
  • 105
  • 7
1
vote
1 answer

Copy A Sheet in Smartsheet using Python API

I was attempting to copy a sheet with the python API, but every time I do so, it only includes the formatting (column names and number of rows), but I would like it to include the data. Is there any way I can do this? I have tried it with a template…
adamcoolcat
  • 105
  • 7
1
vote
1 answer

Why does Smartsheet's updateRowsAllowPartialSuccess return a "Success" in its message when the rows on the sheet aren't updated?

I have an arrayList of Row objects and am using smartsheet's api to update the rows as shown below: ArrayList updatingRows = new ArrayList(); /* Logic to add desired rows */ PartialRowUpdateResult updatedRows =…
ImInfinite313
  • 125
  • 7
1
vote
2 answers

Is there a way to get SmartSheet Forms using the REST API?

Using the SmartSheet REST API, is there any way to get the Forms associated with a Sheet (and their - the forms' - definition/metadata, such as questions, etc.)? There doesn't appear to be anything in the documentation, but I didn't know if I'm just…
JKubecki
  • 579
  • 5
  • 8
1
vote
1 answer

Rows version history

I'm starting to play around with the smartsheet api. I've been ask to retrieve the version history of the different rows of a sheet. I can see that the api return a version number with the row, but I can't find any documentation on how to retrieve…
tolrahC
  • 135
  • 1
  • 8
1
vote
1 answer

Filling in an allocation % column and have it display nicely

As part of my ongoing project of filling in project sheets programmatically with python, I am filling the % Allocated column (which is a column with the TAG 'GANTT_ALLOCATION'). I have been sending my values as floats, which works for the resource…
Erwan Leroy
  • 160
  • 10
1
vote
1 answer

Building whole sheet programmatically with Python SDK

I'm trying to build a whole sheet from scratch, and stay efficient while doing it. For that purpose, I am trying to rely on bulk operations. I can build a massive list of rows and add them easily using add_rows(). However, I need some rows to be…
Erwan Leroy
  • 160
  • 10
1
vote
1 answer

What is the most efficient way to automate data fetching from smartsheet to excel?

There is not too much data so considering keeping it in an excel workbook, but can also do it with SQL whichever could work better. Thanks!
Panthersfball234
  • 95
  • 2
  • 10
1
vote
2 answers

How to delete tasks using smartsheet api and google apps script

I'm developing a small script for operational tasks, and I need to delete rows from smartsheet using the API but I don't know what I am exactly doing wrong. This is my code: function deleteRow(rowId){ var url =…
jotarami92
  • 13
  • 5
1
vote
1 answer

smartsheet API cell values from specific Column

trying to get all cell values (using Cell.Displayvalue) from a specific column in my sheet. I have already used the GetSheet method to pick specific column in sheet. I am not sure how to loop through this specific column and obtain the cell…
Valentin
  • 21
  • 1
  • 6
1
vote
1 answer

C# SDK Smartsheet Post w/ API

Morning all, Using the c# sdk to write a program to post/update smartsheet with information from a database. I am in need of an explanation on how to post to both a checkbox and contact list field in smartsheet. ie - checkbox shows as boolean…
Jazzkatt
  • 65
  • 2
  • 8
1
vote
1 answer

Insert into smartsheet api dropdown cell with API

I am trying to use the Smartsheet api (Python sdk) to insert values from a text file into individual cells in the Smartsheet. Is it possible to insert a value into a cell with drop downs and choose the desired value of the dropdown (and leave the…
Ian Macintosh
  • 13
  • 6
1
vote
2 answers

InvalidRowLocation Smartsheet C#

Can't seem to set indentation level of a row to 1. AddRows results in an InvalidRowLocation exception. static string[] DeserializeJson(string json) { try { SortedDictionary values =…
user7340830
1
vote
1 answer

How To Retrieve Folder Tree With Smartsheets API Python

I'm trying to retrieve sheets with Users.list_org_sheets(include_all=True) from the Python SDK API. With That I can see all the things I need : lstorg = ss.Users.list_org_sheets(include_all=True) for entry in lstorg.data: print(entry.id) …
Death The Kid
  • 11
  • 2
1 2 3
…
35 36