API & Developers

Archives for March 2021

1006 error on an update to sheet with references
I am having trouble making an update to a sheet. I am confident my code works because I can make successful updates on a test sheet that I setup. I created the test sheet by doing a 'save as new' on the original. So all the fields are exactly the same. I think the issue has to do with formulas and references to other…
Purchasing Request Form in Smartsheet
I want to produce a purchase request form in Smartsheet and I'd like to bounce a few ideas off the community. Please see the attached sample of what's used now. Originally, I was hoping to use Document Generator to map the fields of a fillable pdf to a Smartsheet grid and then have people fill in this PDF to populate the…
Smartsheet API Error code 1012 and Status code:400
Hello Team, We are getting this Error code 1012 and Status code:400 (Bad data request )when we try to Add rows/Post data in the smartsheet using Smartsheet API. We have index 0 as Unique ID of Text/Number data type and it holds values. I have tried to clear all cookies and caches from web browser, and verified the URL…
Unable to access filters on published sheet on mobile (not using the app)
I have a published sheet that I have shared using Microsoft teams. If users do not have the smartsheet app on their phone they are unable to use the published filters available because filters does not appear as an option for published sheets on app.smartsheet.com... Is there a way to publish the sheet for users to have…
Report Filter on API generated Field
For several months we have been running an API from FUB that populates 8 different sheets. From there we run a report to filter the information via specific columns. Last week the reports stopped functioning and names seem to have changed. See photos, "Created" no longer exists. We'd like to resolve this by filtering on…
errorCode" : 1012,"Required object attribute(s) are missing from your request: cell.columnId."
Hello, Error with Smartsheet: We are getting this error code 1012 and status code:400 (Bad data request )when we try to Add rows/Post data in the smartsheet. Any insights on this error would be helpful. { "errorCode" : 1012, "message" : "Required object attribute(s) are missing from your request: cell.columnId.", "refId" :…
Building A Test Package In SQL Dev That Writes To A Smartsheet
Hello, I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet table. How do I go about creating a package that does this? I have never built a…
Webhooks vs Built-In Automation
I know that automated workflows in smartsheet won't take place if the trigger is a change on a cell link. Will the same happen in the case of when a webhook is triggered? Will a webhook send if the trigger is a cell linked column?
Inconsistent results when using contact list columns
I am attempting to use the API to perform CRUD actions on a sheet. Several of the columns have Contact/Multi-Contact datatypes. I have discerned through practice that when I create or update a row, that the API expects the email of the contact to be provided in the request. Question number 1: Is that actually the case? I…

Trending in API & Developers

Do you know if you can add a custom code in values (pink rectangle) - Bridge Workflow?
Do you know if you can add a custom code in values (pink rectangle) in this Bridge workflow that is updating a SharePoint list any time changes are being made in the relevant Smartsheet Table? Basically this workflow is working as expected with one issue: for every empty cell, the workflow will update SharePoint with the…
Number values containing 'Apostrophe after being imported from Excel
Greetings All ! looking for some assistance regarding an integration issue I've picked up when importing data from Excel to Smartsheet's using MS FLow , i.e. Excel->MS Flow-> Smartsheet I am inserting an integer but the value on Smartsheet contains an apostrophe before the number which is not ideal as i am using these…
Can anyone help with the Dashboard api?
The sight object exposes Widgets as a get and a set. public IList<Widget> Widgets { get { return widgets; } set { widgets = value; } } When you update the Sight you get a JSON error. The API documentation states Update is for a dashboard name change - this does work ok. Can anyone confirm whether you can or cannot update…

API & Developers

Discussion List