API & Developers

Archives for May 2020

Smartsheet mobile filter bug
Hello Developers, I was recently using Smartsheet on my mobile phone and found this really frustrating bug, I hope you guys fix it soon or if I'm doing something wrong and there is already way to fix this, then please please let me know! Please see attached pdf
Can I populate Smartsheet rows from a SQL Database read?
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
Form Generation_formatting issues
I am trying to generate a report based on the responses, but when i map those answers in the PDF. I am getting populated as below. does any one has a solution for this?
How do I access a published sheet via API? What is the url and ID to access?
If I have a link such as the one below. How do I access a published sheet via API? What is the url and sheet ID to access? https://app.smartsheet.com/b/publish?EQBCT=xxxxx I gave this a try and it didn't work. https://api.smartsheet.com/2.0/sheets/
what is the size limit for a file attachment via API
I have build a webpage that uploads attachments to a row in smartsheet. It works fine for 12 MB file. But I have been trying to upload a file which is 100MB via API to a row, but everytime I get below error: {"response": {"statusCode": 500, "reason": "Internal Server Error", "content": "<< text/html;charset=UTF-8 content…
Critical path in API differs from UI
differs = do not work Project: https://app.smartsheet.com/b/publish?EQBCT=f76e6458a3f64d7d8186be3ed70674ce In UI critical path contains more then 20 rows. For example #6,#7,#8,#9, etc. In API I see only two elements. #44 and #45. I checked my other project. Behavior is the same. In UI critical path is correct, in API is…
Name comes when auto mail trigger to end user
Hi team, I have developed smartsheet project and create workflow for auto alerts mails. when mail trigger automatically in every mail my name will be appear because i have developed this project. this project is developed for some other Team so how to remove my name in top off the mail.
API 2.0 performance
I have a large sheet 11K rows x 14 columns, it is smaller than maximim size Using Java or Python API update for a single cell takes 5-11 seconds with only 1-100 rows x 14 columns the same update takes only 600ms Why performance is not constant? Pavel.
Using API: How to list sheets in HOME root folder?
Hi guys, I would like to retrieve only the sheets in the HOME (root folder). Using /home I can fetch all of of the data under HOME folder but this call may return a lot of data which I don't need (Workspaces, Folders). How can I fetch only the Sheets in Home's top-level folder ? Thanks! Aviv.
Tableau Integration with Smartsheet
Hi Smartsheet Community! I know there is LiveDataConnector available to pull Smartsheet Data into Tableau, but is the reverse possible? I want to pull Tableau data into Smartsheet for one of my Project. Any help appreciated!

Trending in API & Developers

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?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…

API & Developers

Discussion List