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.

smartsheet reference manager - Status "Processing"
Good Afternoon, all of my references are still in a status of processing, and I set these up on Friday 10.29.21. Do we have a way to get these going? Every time I do these, they take forever
Is there any API to get the sheets with the exact name and location?
I wanted to get the list of the sheets with the exact name I provide , also from the exact location either from workspace, folder or home. By exact name I mean returned sheets name should match complete string with given name and not just contain that string.
Percentage formatting with API
Hello, I'm trying to automate the modification of multiple spreadsheets with the API, and I'm bringing a detailed formula to my columns. The displayed value is a percentage so I'm bringing a value between 0 and 1, but I would like to directly format the column in percentage. I've observed on an extract after setting…
Using Smartsheet as a datasource in Sql Server Report Builder
Hi there. To keep it simple, I'm looking to use Smartsheet as a datasource to build an SSRS report. Has anyone done this successfully? If so, are there any special needs such as a driver to pull it off? Any knowledge on this is appreciated. SB
I am using a Set template and can't change US currency on the dashboard to Canadian or no currency .
I have changed the sheet's currency but it doesn't change on the dashboard.
Is their any API to fetch sheets with exact name match and filter on basis of location ?
I wanted to get the list of the sheets with the exact name I provide. I have tried the Get / Search method to look for exact text by adding double quotes but it doesn't filter out special characters. For eg. If I request https://api.smartsheet.com/2.0/search?query="Report for Calendar App" Response: { "results": [ {…
Can you access the API when on Pro plan?
Hi I'd like to generate an api access token in order to work on some integrations with the Smartsheet API. However when I click on "Generate new access token", I get a popup saying "Upgrade for Smartsheet API". Yet here: https://help.smartsheet.com/articles/1072100-smartsheet-api-faqs it indicates that the API applies to…
Python Smartsheet Webhook Verification
I am not a programmer by any stretch of the imagination. I am trying to create a webhook in Python using Anvil for the callback url I have created a webhook. I am struggling to get it authenticated/verified. I have spent hours reading and trying all sorts of solutions. I am using Atom on my desktop for the webhook. On…
Smartsheet webhook subscope weird behavior
I have a sheet on smartsheet that looks like this: I wish that when `test_trigger` column in the sheet got changed, smartsheet can send a notification to my AWS API gateway. So I use webhook with subscope to setup the notification. However, I can't tell which cell in `test_trigger` column got changed from the request sent…
How to delete all webhooks in bulk?
There is an api end point to delete webbooks one by one.. any end point to delete all in once?

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