Stack Overflow
Stack Overflow

Questions tagged [smartsheet-api-1.1]

34 questions
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

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

What is the expected semantics of the Sheet data? Should null values be returned?

I have a sheet with 18 columns and 137 rows. Some of the columns are empty. When I make the get sheets call (I'm using the C# SDK) the data returned has the following structure which seems anomalous to me ... Columns --- 19 (the RowID is tacked on…
Praveen Seshadri
  • 67
  • 5
3
votes
1 answer

Smartsheet-API: Populating data and formulas in a sheet

UPDATE 2022-12-01 This question is now obsolete. Smartsheet API now supports the requested feature. The accepted answer contains more details on the update. CONTEXT A developer wishes to populate an existing smartsheet worksheet using the smartsheet…
dreftymac
  • 31,404
  • 26
  • 119
  • 182
2
votes
1 answer

Python for Smartsheet - Getting _ipython_canary_method_should_not_exist_

All - I am getting this error when loading the Smartsheet Client I loaded all dependencies as per requirements. What should I fix? ImportError! Could not load api or model class _ipython_canary_method_should_not_exist_ ImportError! Could not load…
Leo S.
  • 33
  • 1
  • 6
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
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

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?
user3191778
  • 23
  • 1
  • 3
1
vote
2 answers

Access Smartsheet by column Name instead of Column Id

I am a newbie working with Smartsheet, I am trying to access the values of columns and store them in a list, and I am able to access the values by the index. In my use case, people can delete random columns from the smartsheet and that can cause my…
Shrads
  • 883
  • 19
  • 39
1
vote
1 answer

Curl command works but not pycurl command for smartsheet

I am able to successfully update the smartsheet using Curl Commands: curl https://api.smartsheet.com/2.0/sheets/sheetID/rows \ > -H "Authorization: Bearer token" \ > -H "Content-Type: application/json" \ > -X PUT \ > -d '[{"id": rid, "locked" :…
polyglot
  • 57
  • 11
1
vote
1 answer

Get all columns and attachments from Smartsheet API in PHP

I am working on Smartsheet API but I am not a pro. I need some help to get all the information out a specific sheet. With all information I mean all the columns and all attachments to them. I also need help to make it possible to download the…
user2979664
  • 7
  • 4
1
2 3