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.

How to retrieve all Conversation comments for a row through ODBC?
Hello. I am writing reports in SQL Server Report Server. I have successfully added one of our Smartsheet sheets as an ODBC data source and am able to retrieve all rows and columns. I'm trying to use a lookup or lookupset to retrieve all the entries for a Conversation of a row so that it can be displayed as "Help" text when…
Any way to Automatically Upload File to Workspace or Folder?
I don't see any methods in the python or HTTP APIs to upload a non spreadsheet file to a folder or workspace. Is there any method I'm missing or is this purposefully omitted?
Smartsheet Bridge special characters not encoding in endpoint URL
Has anyone ran into this issue? I would like to parse an ISO formatted time into the endpoint URL, but it's not encoding "+" to %2B. My particular use case is getting the latest CVEs from Vulnerability APIs (nist.gov) The endpoint should be formatted as such:…
API - How can I get all existing workspaces of my organization ?
Hello, We tryed to get list of workspace created in our organization account We use API with Bearer Authentification :'https://api.smartsheet.com/2.0/workspaces I created API acces with my account (Administrator system) , API get result only Workspace where i have an acces on my SmartSheet Account/ How can I get all…
How to embed power bi dashboard to smartsheet?
How to embed power bi dashboard to smartsheet?
Build a cloud smartsheet solution, in Python code
hi Community We've built a solution to manage process controls in SmartSheet. Smoothly integrated with datashuttle. It works via Python, but "on Premise" via Visual studio Code. Our GOAL: We want to move the code and the solution to the Cloud. Our smartsheet customers can then request updates via our Control center. We are…
Smartsheet API and pyinstaller ImportError
I have a python script that takes a csv file and adds the rows into Smartsheet. When I run my code through the command line the script runs perfectly. However, when I created an application using pyinstaller for this script, I am getting an Import Error! Could not load api or model class Sheets Is there a solution to this?
API adding blank row instead of data sent in the code
This is odd. I have a script that adds one row to top of a new/blank sheet for testing purposes. There are two fields and I have the column ID's as well as the sheet ID correct. When I run the script, I get a SUCCESS result. When I go to the sheet, it says it has been changed, and I need to refresh. But, there is no data.…
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
Smartsheet form + website data connection
Hello, I'm exploring the possibility of connecting a Smartsheet form to our website's content management system. Specifically, I'm interested in implementing the following workflow: A user accesses a Smartsheet form to propose updates to specific website content (e.g., a location description). The user enters the new…

Popular Tags

Trending in API & Developers

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!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…

API & Developers

Discussion List

Categories

Popular Tags