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

How do I get a list of discussions for a row using the Smartsheet REST API?

I need to access all discussions for a Smartsheet row via the REST API. Is there a way to do this? Calling https://api.smartsheet.com/1.1/row/{ID}/discussions, which isn't documented, doesn't work.
ryeager
  • 90
  • 4
2
votes
1 answer

How can I pass data to a Smartsheet Web Form?

I have a html link which opens a Smartsheet form in new window so our online customers can fill out the form. I would like to pass the value of a TextField (product name or product code) in my existing form to my smartsheet form. This would help my…
user3264403
  • 23
  • 1
  • 4
2
votes
1 answer

Bug in C# SDK when executing POSTs

I'm using the C# SDK and it seems that there is a bug when executing any POST. The post body is serialized as the string "System.IO.StringReader". This seems to be because of line 127 in Internal/Http/DefaultHttpClient.cs I changed the code…
2
votes
1 answer

Smartsheet - Download Sheet as Excel File using API

I am trying to use the Smartsheet API to download a sheet as an excel file. I am really struggling to put together the correct code to do this. Can you provide a basic code example that will download an excel file using the Smartsheet API?
1
vote
1 answer

Use Smartsheet API to create an image/screenshot of a Smartsheet dashboard

My team manages the digital signage program for my company. This consists of large flatscreen displays in building lobbies/offices for news and other info. I'm able to retrieve a basic Smartsheet doc using the API. I can use the signage software to…
mindmischief
  • 271
  • 1
  • 12
1
vote
0 answers

how to implement the Smartsheet API client-side code using Browserify?

"Could you please guide me on how to implement the Smartsheet API client-side code using Browserify? I am trying to use the Smartsheet API in my web application, and I am not sure how to proceed with the client-side implementation. Any help or…
1
vote
1 answer

How to use Alteryx SQL Editor statement into Smartsheet API call?

Currently, I am using Alteryx Designer to connect with Smartsheet API and on Alteryx there is the "Choose Table or Specify Query" box which has "SQL Editor" where we have the following code: SELECT * FROM "Proj PAGE 1__1234567891234567s_" as AM…
floss
  • 2,603
  • 2
  • 20
  • 37
1
vote
1 answer

How to use API token to access SmartsheetGov by Smartsheet API Python

I am wondering if you could provide your solution on how to connect my agency's SmartsheetGov by using Smartsheet API with python. I have tried to connect to our agency's SmartsheetGov by Smartsheet API with Python. However all I got is the response…
1
vote
1 answer

Method get_cell_history (Smartsheet API) works in Python file but doesn't work in exe file

lst_Incor = [] for i in range(250): if get_cell_value_by_column_id(sheet_Source.rows[i],450382123898xxxx) == 'Incorporating US Markup': response = smart.Cells.get_cell_history( SheetId_Source, # sheet_id …
Kyle
  • 15
  • 3
1
vote
1 answer

how to use os.listdir() in smartsheet?

I would like to get all the folder that are in a specific folder in smartsheet I wanted to use os.listdir but I am not sure on how to use it on smartsheet any idea ? any idea on how to implement that without os.listdir ?
Ben2pop
  • 746
  • 1
  • 10
  • 26
1
vote
1 answer

Push a python dataframe to Smartsheet using Smartsheet API

I have a python script where I'm trying to fetch data from meraki dashboard through its API. Now the data is stored in a dataframe which needs to be pushed to a Smartsheet using the Smartsheet API integration. I've tried searching the Smartsheet API…
1
vote
1 answer

unable to install Smartsheet python sdk

I am not able to install the sdk for smartsheets, i get the following error when i execute the command $pip install smartsheet-python-sdk error: Could not find a version that satisifies the requirement smartsheet-python-sdk error: No matching…
1
vote
1 answer

Why can import smartsheet not be resolved?

I have installed the smartsheet python sdk with pip3 install smartsheet-python-sdk (using Python 3.10.5). I believe it was successful because if I do it again, or even try to upgrade, I see "Requirement already satisfied" for all the requirements.…
1
vote
1 answer

Using smartsheet-python-sdk to put data back into Smartsheet

I used the smartsheet-python-sdk (with a unique API key from Smartsheet) to automatically pull data from Smartsheet into my Python script along with other data sources (from Tableau) to create new feature-engineered columns. I now want to put these…
beans333
  • 11
  • 1
1
vote
1 answer

Remove formula from column with python

I am trying to remove the formula from a column in a existing sheet with python. I tryed to set my formula to None using the column object (column.formula = None) It does not work and my column object remains unchanged. Anyone have inputs to solve…
JayP
  • 13
  • 2