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.

Automated Data Export
Hey All, I have a problem that I have been struggling to find an efficient solution for regarding how to routinely get form data out of smartsheets. I am hoping for ideas, advice, and/or secure tools that you all may know of to help with that. For context, below is my current issue/goal and what I think is the best…
EU account - how to activate developer tools
Hello, How can I activate developer tools for an account used on EU Smartsheet? Here is not working: https://developers.smartsheet.com/ I had the same issue with a GOV account, and there I was helped after I've opened a ticket (the solution was to be activated manually by Smartsheet team). I did the same for EU account but…
Using Bridge for Row Autosort
Hi, is it possible to use Bridge to auto-sort a sheet (the trigger being when a new row is inserted)?
Predecessor column show #Ref differently before & after refresh for invalid predecessor
If invalid predecessor data then Predecessor column show #Ref differently before & after refresh Steps to reproduce: Create a smartsheet with 3 task and change setting dependencies enable true. Add predecessor as following. 1. Task 2 add predecessor data row 1. 2. Task 3 add predecessor data row 2. 3. Task 1 add…
Fillable PDF
Has anyone tried to use the submit button on a fillable PDF form to send data into smartsheet? Doens't seem to difficult but could use some guidance.
When can the update_report api become available?
There is a specific use case in my organization that I need to be able to rename a set of reports automatically. Currently I'm able to do it to sheets and sights in the same folder, however the reports remains manual because this api is not available. I hope this can become available soon. If there is any workaround…
Is Smartsheet going to add API Calls for WorkApps?
Will we be able to access workapps via the api? Such as giving permissions to roles etc through API calls?
Editing rows with a form is the #1 tool missing here
I know this is not a new topic, there are many questions and discussions on this already. But me and my end users really need a form view for modifying existing rows. My rows contain over 250 columns in the database I'm building. If I could create different form views to modify rows with, my efficiency would probably…
Python API - results on Reports do not match manual Excel extracts
Hi, We are currently automating some processes around Smartsheet, where one of the key steps is to extract data from a Smartsheet Report (sic! Not a Sheet!). We tried the following approaches using the Python API using the Smartsheet connector for the Azure Data Factory…
Trying to update a cell in a row with PowerShell by passing a variable
This works okay: $Headers = @{ Authorization = "Bearer ***********" } $uri = "https://api.smartsheet.com/2.0/sheets/5034086415787908/rows" $body = '[{"id": "5257700085983108", "cells": [{"columnId": "853109098473348","value": true}]}]' Invoke-RestMethod -Method put -Uri $uri -Headers $headers -body $body But this doesn't…

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