API & Developers

API & Developers

 

Discussion List

  • Maricel Medina
    Announcement Maricel Medina 41 views 1 comment Most recent by Kevin Minkoff
    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
  • Vladislav Lehelt
    Answered - Pending Review Vladislav Lehelt 40 views 2 comments Most recent by Genevieve P
    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
  • Amit Wadhwani
    Amit Wadhwani 11 views 1 comment Most recent by Genevieve P
    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
  • Richard Rymill SBP
    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
  • Lakshman .
    Answered - Pending Review Lakshman . 24 views 2 comments Most recent by Lakshman .
    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 .
  • Senthil Anandarangan
    Answered - Pending Review Senthil Anandarangan 18 views 3 comments Most recent by Sean Morgan
    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
  • Hoang Vo
    Answered - Pending Review Hoang Vo 22 views 1 comment Most recent by Sean Morgan
    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
  • Snigdha Singh
    Answered - Pending Review Snigdha Singh 15 views 1 comment Most recent by Genevieve P
    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
  • Eize Gever
    Answered - Pending Review Eize Gever 35 views 2 comments Most recent by Genevieve P
    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
  • leejoramo
    leejoramo 437 views 9 comments Most recent by Lakshman .
    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
  • Yashwant Singh
    Answered - Pending Review Yashwant Singh 27 views 11 comments Most recent by Andrée Starå
    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
  • Yashwant Singh
    Answered - Pending Review Yashwant Singh 14 views 2 comments Most recent by Yashwant Singh
    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
  • Pavel Bogatyrev
    Pavel Bogatyrev 15 views 0 comments Started by Pavel Bogatyrev
    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
  • Joshua Medina
    Answered - Pending Review Joshua Medina 17 views 5 comments Most recent by Andrée Starå
    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
  • Amit Wadhwani
    Accepted Answer Amit Wadhwani 28 views 2 comments Most recent by Nathan Lloyd
    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
  • jg124
    Answered - Pending Review jg124 36 views 1 comment Most recent by [email protected]
    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
  • Lakshman .
    Form GenerationQuestion
    Answered - Pending Review Lakshman . 13 views 3 comments Most recent by Andrée Starå
    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 .
  • Manish Choudhary
    Answered - Pending Review Manish Choudhary 17 views 1 comment Most recent by Genevieve P
    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
  • Joe Liotta
    Accepted Answer Joe Liotta 26 views 6 comments Most recent by Genevieve P
    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
  • L@123
    [email protected] 50 views 2 comments Most recent by [email protected]
    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]
  • twa10028
    twa10028 159 views 3 comments Most recent by Andrée Starå
    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
  • Tom Cichoracki
    Answered - Pending Review Tom Cichoracki 15 views 1 comment Most recent by Mary_A
    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
  • jaccorde
    Answered - Pending Review jaccorde 26 views 1 comment Most recent by Nathan Lloyd
    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
  • Emileah Hiatt
    Answered - Pending Review Emileah Hiatt 44 views 9 comments Most recent by Emileah Hiatt
    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
  • Sheanon Summers
    Accepted Answer Sheanon Summers 26 views 4 comments Most recent by Sheanon Summers
    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
  • beatea
    Answered - Pending Review beatea 23 views 1 comment Most recent by Etienne Mermillod
    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
  • 01011010
    Answered - Pending Review 01011010 23 views 1 comment Most recent by Alejandra
    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
  • LeeGilbert
    LeeGilbert 237 views 3 comments Most recent by Ryan Kramer
    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
  • Susan Swisher
    Answered - Pending Review Susan Swisher 13 views 2 comments Most recent by Susan Swisher
    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
  • Joe Liotta
    Accepted Answer Joe Liotta 15 views 1 comment Most recent by Andrée Starå
    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