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

Postman API Invalid Content-Type Header

I'm trying to test and API call for the Smartsheet API in Postman, but I keep receiving the same error. Even though I am defining the correct Content-Type as per the API documentation, the response I get is the error 1124, which is an invalid…
burnsa
  • 17
  • 1
  • 1
  • 4
1
vote
1 answer

Smartsheet SDK (2.0) API - Clearing a cell

At a certain point during the day, I need to reset the data (to NULL) on a Smartsheet via the C# SDK (Nuget package) Here's a prototype code snippet // Connect tp Smartsheet API SmartsheetClient ss = new…
Chris Hammond
  • 2,064
  • 5
  • 27
  • 53
1
vote
1 answer

error when installing smartsheet-python-sdk on mac

I'm getting the following error when installing the smartsheet-python-sdk package on my Mac. Can anyone give me any pointers? > dleclair-mbp:smartsheet dleclair$ sudo pip install > smartsheet-python-sdk >. >. > smartsheet-python-sdk) Collecting…
Denis
  • 1,031
  • 3
  • 11
  • 22
1
vote
1 answer

Receiving errorCode 1004 with /token API endpoint

Do oauth token grants require a paid account? I attempted the following with both a free and trial account. Sending /token POST as documented results in: { "errorCode": 1004, "message": "You are not authorized to perform this action.", …
Damon
  • 826
  • 1
  • 10
  • 25
1
vote
1 answer

Replicate curl command to access Smartsheet in Rails

I am trying to access Smartsheet through API 2.0 in a Ruby-on-Rails app. I can get he following curl command to work curl --request GET https://api.smartsheet.om/2.0/sheets -H "Authorization: Bearer xxxxxxxxxxxxxxxxxxxxxxxxx" All attempts to…
Scott Sarnikowski
  • 1,461
  • 2
  • 14
  • 24
1
vote
1 answer

Smartsheet API create/update reports possible?

Just verifying that Reports can not be created or modified using the API. I'm using Python. Craig
J. Craig Williams
  • 380
  • 1
  • 2
  • 18
1
vote
2 answers

smartsheet api with c#

I am using Smartsheet through C# to insert rows into the existed sheets executing but when come to adding rows to the sheet it giving error like this "You are not authorized to perform this action " please help iam stuck there
1
vote
2 answers

After seaching for smartsheet examples using JSON to add rows to a sheet, cant find a match

I want to use curl and json to send a new row to a SmartSheet. I practiced simpler commands so know my token and sheet id are ok. I cant make the following code run. It would help to see similar code populated with all the variables. The code was…
CJAB
  • 11
  • 3
1
vote
1 answer

Working With SmartSheets API, Loop Through List for Variable of a Function

I have a list of numbers like below stored into a variable. [700000000084, 100000000051652, 8800000000000072, 280000000000004, 680000000000008, 880000000000006] I am trying to loop this through the SmartSheets API to pull all the info I need into…
1
vote
1 answer

How to parse Smartsheet API 2.0 Python SDK error results?

I'm trying to get the update_rows method working (the answers here haven't helped yet: cannot update row using Smartsheet API ) and would like to capture and parse the results results = smartsheet.Sheets.update_rows(test_sheet_id,…
J. Craig Williams
  • 380
  • 1
  • 2
  • 18
1
vote
1 answer

Failed uninstall/install of Smartsheet Python SDK

I ran into some issues with the Python SDK. I figured before opening a bug up I'd see if reinstalling would help with any updates. I ran sudo pip uninstall smartsheet-python-sdk and it failed at about 90% trying to uninstall the python-dateutil…
Tom
  • 11
  • 2
1
vote
1 answer

Using OAuth2 flow within Google Script Library is returning 'Redirect or Missing URI'

I am writing a custom google scripts library for use within multiple google sheets. It uses the Google Script OAuth2 library to manage the OAuth flow with the Smartsheet API. Unfortunately it is returning 'Redirect URI missing or invalid'. I had the…
1
vote
2 answers

Smartsheet API: Cannot update predecessor cell with C#

I have a problem with the Smartsheet API. I'm trying to create an Excel Addin to add multiple rows to Smartsheet. For this reason I need a way to update predecessors. The programming language I'm using is C#. As soon as I want to run an update I get…
1
vote
1 answer

smartsheet cell.getFormat() returns null

I use Java Smartsheet API. According to Smartsheet documentation "Formatting data can optionally be included for columns, rows, and cells by adding the “include=format” query string parameter to any API operation that returns any of those…
andronix
  • 124
  • 9
1
vote
1 answer

can't workout why getting a type error on __init__

Hope someone can help me... Have the following: smartsheet_test.py from pfcms.content import Content def main(): ss = Content() ss.smartsheet() if __name__ == "__main__": main() content.py import smartsheet as ss class Content: …
Alex2134
  • 557
  • 7
  • 22