API & Developers

Archives for August 2020

Search API 10 minutes rule?
Hi everyone! I've noticed in the last few days that the search API returns a "positive" value on a new row (via search API endpoint) exactly after 10 minutes of being created. Is there any specific docs about this?, or a reason that i'm missing?. Use Case Create new row with a value that doesn't previously exist in your…
Page break for dashboards
Any chance a page break function Dashboard menu. I spend a lot of time trying to fit widgets within a landscape A4 moving things around, scaling and altering margins. A simple page break option when creating a dashboard could resolve this. Zoe
Column webhook firing on all changes and repeatedly reporting same deleted row
I created a webhook with column scope as follows and enabled it. Everytime a change is made on the smartsheet, the webhook fires, even though I specified only one column for the subscope. Shouldn't it only change if a value in that column changes? { "message": "SUCCESS", "resultCode": 0, "result": { "id": 7548025422800772,…
SharePoint/Smartsheet Integration
I have a list of data that's maintained in a SharePoint Online site. On a weekly basis, the list info is downloaded and then uploaded into Smartsheet, where that information is used in several reports and Dashboards, Is there some additional functionality or extension capability where this process could be automated?…
Does Smartsheet retain any information from respondents that provide data in a form?
Does Smartsheet retain any information from respondents that provide data in a form? If so, what information is retained and what is the policy? I have been asked by my organization's leadership.
When I scan a barcode using a form, an extra ' is entered before the number.
I´m using the barcode scan function in a form to enter the barcode. However, when I do the scan an extra character , ', is entered in front of the number. So instead of the number 10345470605 being entered, '10345470605 is entered instead. This is creating errors when I later do an INDEX/MATCH. How can I get rid of this…

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

Internal Server Error w/ API PowerBI connection
I am running into an error when connecting Smartsheet to Power BI (Power Query). I am trying to refresh my PBIX file, but I run into the following error when trying to connect my Smartsheets: The issue randomly started today. No new data and/or transformations have been used on the existing data.
Summary field with formula by API
Hello everyone, I have a function that I run via API that helps me replicate improvements across all the spreadsheets for projects I work on. I tried to insert a new formula field into my spreadsheet using this function and it worked perfectly. However, the field results in a formula error and I need to access all the…
VBA to Smartsheet
Hello all, I am relatively familiar with Smartsheet and VBA. From my understanding I will need to API access to achieve this, but am I able to write a VBA script that pulls my excel file into a Smartsheet report? Just wanting to know for sure if that's possible. Thanks!

API & Developers

Discussion List