API & Developers

Help us design API classes that meet your needs

Announcement Maricel Medina 41 views 1 comment 0 points Most recent by Kevin Minkoff 05/06/20

First post 04/19/20,Last post 05/06/20
Hi, We are preparing new courses related to our Smartsheet API, would you take few minutes to let us know what would you like us to offer by submitting this survey: https://tinyurl.com/ycg7arps? https://us.v-cdn.net/6031209/uploads/754/…
API & Developers411
Maricel Medina
Critical path in API differs from UIQuestion

Answered - Pending Review Vladislav Lehelt 40 views 2 comments 0 points Most recent by Genevieve P 05/27/20

First post 05/20/20,Last post 05/27/20
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…
API & Developers402
Vladislav Lehelt
Smartsheet mobile filter bug

Amit Wadhwani 11 views 1 comment 0 points Most recent by Genevieve P 05/27/20

First post 05/26/20,Last post 05/27/20
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! P…
API & Developers111
Amit Wadhwani
Conditional Logic in Smartforms (AKA Cascading Dropdowns)

Richard Rymill SBP 1.1K views 12 comments 0 points Most recent by Richard Rymill SBP 05/27/20

First post 09/10/19,Last post 05/27/20
We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…
API & Developers109412
Richard Rymill SBP
Form Generation_formatting issuesQuestion

Answered - Pending Review Lakshman . 24 views 2 comments 0 points Most recent by Lakshman . 05/26/20

First post 05/21/20,Last post 05/26/20
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? https://us.v-cdn.net/6031209/uploads/EE7L2ADYB5Y7/image.png
API & Developers242
Lakshman .
Can I populate Smartsheet rows from a SQL Database read?Question

Answered - Pending Review Senthil Anandarangan 18 views 3 comments 0 points Most recent by Sean Morgan 05/26/20

First post 05/22/20,Last post 05/26/20
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?
API & Developers183
Senthil Anandarangan
How do I access a published sheet via API? What is the url and ID to access?Question

Answered - Pending Review Hoang Vo 22 views 1 comment 0 points Most recent by Sean Morgan 05/26/20

First post 05/20/20,Last post 05/26/20
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/…
API & Developers221
Hoang Vo
what is the size limit for a file attachment via APIQuestion

Answered - Pending Review Snigdha Singh 15 views 1 comment 0 points Most recent by Genevieve P 05/25/20

First post 05/20/20,Last post 05/25/20
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": {"s…
API & Developers151
Snigdha Singh
Using API: How to list sheets in HOME root folder?Question

Answered - Pending Review Eize Gever 35 views 2 comments 0 points Most recent by Genevieve P 05/21/20

First post 05/17/20,Last post 05/21/20
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…
API & Developers352
Eize Gever
API Demo: Creating a Formatted and Printable View of a Row

leejoramo 437 views 9 comments 0 points Most recent by Lakshman . 05/20/20

First post 04/03/19,Last post 05/20/20
Here is a demonstration of a feature I created using SmartSheet's API. Let's say you want to print all or some content of a row. Or perhaps you want a nicely formatted and easy to read view of the row. The specific use case addressed here…
API & Developers4379
leejoramo
Name comes when auto mail trigger to end userQuestion

Answered - Pending Review Yashwant Singh 27 views 11 comments 0 points Most recent by Andrée Starå 05/20/20

First post 05/20/20,Last post 05/20/20
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. https://us.v-cdn.net/6031209/uploads/NZS5…
API & Developers2711
Yashwant Singh
How to check next day is weekend day or notQuestion

Answered - Pending Review Yashwant Singh 14 views 2 comments 0 points Most recent by Yashwant Singh 05/20/20

First post 05/20/20,Last post 05/20/20
HI team, How to check that next day is Saturday or Sunday. If end date will be come in Saturday or Sunday then processing task will be done by Friday only.. Is this possible using any formulas?
API & Developers142
Yashwant Singh
API 2.0 performance

Pavel Bogatyrev 15 views 0 comments 0 points Started by Pavel Bogatyrev 05/17/20

First post 05/17/20,Last post 05/17/20
I have a large sheet 11K rows x 14 columns, it is smaller than maximim size https://help.smartsheet.com/articles/506775-system-requirements-for-using-smartsheet#filesize Using Java or Python API update for a single cell takes 5-11 second…
API & Developers150
Pavel Bogatyrev
Summing columns from multiple sheetsQuestion

Answered - Pending Review Joshua Medina 17 views 5 comments 0 points Most recent by Andrée Starå 05/14/20

First post 04/20/20,Last post 05/14/20
Hi, I have multiple sheets managing separate projects with similar columns. I would like to sum the data in a particular column across all sheets to get a total number for the dashboard in the Metric Widget. Is this possible?
API & Developers175
Joshua Medina
Tableau Integration with SmartsheetAccepted Answer

Accepted Answer Amit Wadhwani 28 views 2 comments 0 points Most recent by Nathan Lloyd 05/14/20

First post 05/12/20,Last post 05/14/20
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!
API & Developers282
Amit Wadhwani
Adding an Attachment via API (Python)Question

Answered - Pending Review jg124 36 views 1 comment 0 points Most recent by [email protected] 05/13/20

First post 05/06/20,Last post 05/13/20
Hello all, Apologies in advance for what will be a basic question for some, however I am going insane trying to figure this out. Struggling to add an attachment via the API, have been on the Github and the Getting Started resources provi…
API & Developers361
jg124
Form GenerationQuestion

Answered - Pending Review Lakshman . 13 views 3 comments 0 points Most recent by Andrée Starå 05/08/20

First post 05/07/20,Last post 05/08/20
I tried so much but not able to get option to map in the highlighted area, can anyone help? https://us.v-cdn.net/6031209/uploads/068/812R0C2M682V.png
API & Developers133
Lakshman .
To get the contents of a column and apply filter to the contentsQuestion

Answered - Pending Review Manish Choudhary 17 views 1 comment 0 points Most recent by Genevieve P 05/07/20

First post 05/05/20,Last post 05/07/20
Hello, I am new to Smartsheet API. I am using Python API. Is there a way to get the contents of a column in something like list. I can get the Column name/ID but unable to lists out the contents of the column.
API & Developers171
Manish Choudhary
Error 1012: 'Required object attribute(s) are missing from your request: values.'Accepted Answer

Accepted Answer Joe Liotta 26 views 6 comments 0 points Most recent by Genevieve P 05/06/20

First post 04/28/20,Last post 05/06/20
I'm having difficulties with the AddRows method in Smartsheet's C# SDK. I have been getting the error code 1012 with the message 'Required object attribute(s) are missing from your request: values." I have seen others post similar iss…
API & Developers266
Joe Liotta
VBA: Push Button in Webform code

[email protected] 50 views 2 comments 0 points Most recent by [email protected] 05/04/20

First post 01/20/20,Last post 05/04/20
All: this is to share/record a way to push the submit button in a smartsheet webform using vba. I share this because I spent way more time trying different options posted on different websites than I would like to admit. Dim IE As Object …
API & Developers502
[email protected]
Automated emails

twa10028 159 views 3 comments 1 point Most recent by Andrée Starå 04/29/20

First post 02/24/19,Last post 04/29/20
Hi, Is it possible to change the "from" address when sending automated alerts/update requests? Or is it always the default SmartSheet address? Thanks
API & Developers1593
twa10028
Would it be possible to add multiple request approvals in one approval request?Question

Answered - Pending Review Tom Cichoracki 15 views 1 comment 0 points Most recent by Mary_A 04/27/20

First post 04/27/20,Last post 04/27/20
This would greatly reduce the number of automation work flows for a given sheet. I want to do this (instead on multiple work flows) so I can get and see individual responses in separate columns. https://us.v-cdn.net/6031209/uploads/083/21…
API & Developers151
Tom Cichoracki
Jira connector with tracking Epic % complete by epic nameQuestion

Answered - Pending Review jaccorde 26 views 1 comment 0 points Most recent by Nathan Lloyd 04/24/20

First post 04/14/20,Last post 04/24/20
I'm trying to show the % complete for epics that are in progress but having trouble getting this to work. I have the Jira connector already setup, mapped to a summary sheet with formulas, and finally to an executive dashboard. My ask is ho…
API & Developers261
jaccorde
Error Code 4000 "Unexpected Error"Question

Answered - Pending Review Emileah Hiatt 44 views 9 comments 0 points Most recent by Emileah Hiatt 04/22/20

First post 04/17/20,Last post 04/22/20
I am getting error 4000 when trying to write to a sheet using python. All it says is "An unexpected error has occurred. Please contact Smartsheet support at [email protected] for assistance." I have successfully written to other…
API & Developers449
Emileah Hiatt
Delete a Sent Update RequestAccepted Answer

Accepted Answer Sheanon Summers 26 views 4 comments 0 points Most recent by Sheanon Summers 04/20/20

First post 04/18/20,Last post 04/20/20
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. Th…
API & Developers264
Sheanon Summers
Can I show Smartsheet data inside Confluence page for free?Question

Answered - Pending Review beatea 23 views 1 comment 0 points Most recent by Etienne Mermillod 04/20/20

First post 04/19/20,Last post 04/20/20
It would be perfect if I cuold simply show the Smartsheet information inside of Confluence. No need for further fancy Jira/Confluence integration which I know costs a lot of money.
API & Developers231
beatea
CopySheet Include Automated WorkFlow & Alert OptionsQuestion

Answered - Pending Review 01011010 23 views 1 comment 0 points Most recent by Alejandra 04/15/20

First post 04/14/20,Last post 04/15/20
Is it possible to include the Automation setting from a "template" to the new target smart sheet using the "smartsheet.SheetResources.CopySheet" function? Dim newCopiedSheet As Sheet = smartsheet.SheetResources.CopyShe…
API & Developers231
01011010
Excel VBA Examples

LeeGilbert 237 views 3 comments 0 points Most recent by Ryan Kramer 04/14/20

First post 04/03/19,Last post 04/14/20
Does anyone have any examples of using Excel VBA to run api commands? I had some routines that used CreateObject("WinHttp.WinHttpRequest.5.1") with 1.1 but these don't work anymore, I get error occurred in the secure channel sup…
API & Developers2373
LeeGilbert
Donut Graphic / ViewQuestion

Answered - Pending Review Susan Swisher 13 views 2 comments 0 points Most recent by Susan Swisher 04/13/20

First post 04/10/20,Last post 04/13/20
Is there a way to fix this? Sometimes you can have lines (separators) from the numbers; but this is a jumbled mess. Even if I changed the chart type, I would need to adjust the axis to start the numbers at a lower point, so that views, cor…
API & Developers132
Susan Swisher
Are webhooks a premium feature in Smartsheet?Accepted Answer

Accepted Answer Joe Liotta 15 views 1 comment 0 points Most recent by Andrée Starå 04/09/20

First post 04/09/20,Last post 04/09/20
Hi All, I'm in the process of building an app that utilizes Smartsheet's API and I would like the code to run whenever a change is made to a particular sheet. In the API's documentation, it appears that "Event Reporting" and Webh…
API & Developers151
Joe Liotta

API & Developers

API & Developers

Discussion List