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

Python SDK API to add rows with Multi Columns to Smartsheet
I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…
Smartsheet IP Addresses for Network Restrictions
Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?
Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :

API & Developers

Discussion List