Product questions?
Sign in and 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.

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?
Feature Suggestion: View Cell History Changes when printing/viewing row vertically.
Hello, I've been trying to find the form to submit a feature suggestion but have been having difficulty finding it. I do project management, and we're just now getting into how we can best leverage Smart Sheets to that end. However, one thing has immediately stood out that would be of great use if implemented: Essentially,…
Setting Up Webhooks
I'm looking for assistance on how to set up webhooks. Nobody in Smartsheet seems to have any idea how to set it up. I was passed from one person to another. I'm no developer and that's why I was hoping Smartsheet can point me in the right direction. But nada. Anyone here who knows how? The webhook is from the RingCentral…
Loop back to the start of a Bridge Workflow
I am trying to build a help chatbot that our team members can use to quickly find help docs on various topics/processes. For example the chat would look something like this - If you answer yes I want the chatbot to loop back to the very start and clear any history from the previous questions/answers, and if you answer no…

Trending in API & Developers

Change Agent with Python SDK is not working
Hi, I'm using smartsheet-python-sdk version 3.0.2 with Python 3.11 and trying to set the Change Agent so I can use it to read when receiving the webhooks but although I pass the change_agent parameter this is not being applied. When i made the request using cURL it works fine. The below is how I set the change_agent:…
SmartSheet API call via Alteryx
Hello, I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs. As a first step, I am extracting the details of the smartsheets that I am given access to (just the…
Bridge: Move select columns/attachments/comments to another sheet
Hello all! I'm looking to see if a Bridge workflow can be done with moving/copying select columns from one sheet to another BUT also bringing their attachments/comments over as well. I've made a workflow to copy select columns from a source sheet to a targeted sheet but never have the comments/attachment follow. I have a…

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags