Product questions?
Ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

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…
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?
Smartsheet API to Link with AzureDevOps
I am working with two tools and would like to have an API that would link Azure DevOps and the Smartsheet. Is there currently a API from Smartsheet would connect and interface with Azure DevOps?
Attach file to row using PHP
The smartsheet api docs provide this documentation to attach a file to a row. curl https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/attachments \ -H "Authorization: Bearer ll352u9jujauoqz4gstvsae05" \ -H "Content-Type: application/msword" \ -H 'Content-Disposition: attachment; filename="ProgressReport.docx"' \…
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…
API Load Error with Python Executable
I have created a python script in PyCharm, the file has been running with no issues. I converted the file to .exe using PyInstaller and auto-py-to-exe but with both methods I receive the following error after running the .exe: "Import Error! Could not load api or model class folders." A screen shot of the command line is…
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" :…

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List

Categories

Popular Tags