API & Developers

Archives for January 2019

Smartsheet API Delete Row Function Error
Hi, When I run a code to delete multiple columns in a sheet >500. It run successfully once, the second try gave an error : Response: { status: 414 Request-URI Too Large content: { << text/html; charset=iso-8859-1 content type suppressed >> } JSONDecodeError: Expecting value: line 1 column 1 (char 0) The code below reads a…
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…
Form Search and Auto-populate values
Hello, I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference…
Living Graphing Solutions to Embed in Smartsheet Dasboard
Hello I am looking for advice on the best tool to extract data from Smartsheet to a third party graphing service and then embed the 3rd party graph in a smart sheets dashboard. The two options I can think of are the !. Live Data Connector to Excel or Tableau 2. Power BI desktop Is anyone familiar with these methods or…
Clone sheet and reports between accounts
Hi there, I'd like to take a sheet and some reports that operate on that sheet, and clone them over to a new account programatically. I'm able to share the items, copy them, and then un-share them programatically, but the reports then point to a non-existing sheet. Since I have quite a number of reports I'd ideally like to…
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
Live data in smartsheet
Trying to pull data out of our ERP (epicor) probably .csv format and keep it continuously updated to avoid manual data entry as much as possible. any ideas about how to do this? i am trying to use the data uploader but keep getting this error message. Thank you for any help in advance.
Post api call to import into smartsheets. 502 error
Hi - I have an Excel sheet of data that I' m using to convert into json and then import into smartsheet. It is authenticated and runs fine till it has to actually import the data. It errors out at uploading the data with 502 connection was reset by a peer. I truly appreciate any/all help. Thanks Mythili
UI "Enhancements"
I know I'm not alone in my dislike for the new "hamburger menu" feature. It has resulted in quite a bit of retraining at our facility, across all 3 shifts, sucking time from my already packed day. The additional clicks necessary to access "active" sheets for the day is almost exhausting. While I certainly hope Smartsheet…

Trending in API & Developers

Smartsheet API Documentation unexpectedly asking for login (23 Apr)
I'm unable to log into the smart sheet API Documentation. Till yesterday I was able to access the API documentation did not prompt for login. Kindly help me log in to SmartSheet Official API and SDK Documentation Log in with Redocly
QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…

API & Developers

Discussion List