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.

How can I access the Smartsheet API from Excel power query?
Hi, I have ODBC connector for Excel but need to use the API in this instance. I'd like to create an API connection that can be run by anyone with access to the Excel document. I have a secure token but am unable to configure the parameters in Power Query so that the Smartsheet API is happy and provides access. I currently…
List Discussions function limited characters
Hello, I am trying to pull all discussion and comments associated with a sheet ID. I was able to pull using the API through python as shown below. However the comments came in with only limited characters, in other words I can only see the first 100 characters. Please advice PYTHON CODE BELOW " import smartsheet import…
Automated import through the API
Dear Smartsheet-Community, I am doing a semesterthesis in coorporation with a company that has been using Smartsheet for a while. My job is to create an automated order tool for AM parts, which serves as an order backlog including the 3D models and part properties and that enables communication with the supplier. Object of…
Event Reporting API
Hi team, I have a question on smartsheet Event Reporting API. As event API is available as an Add on feature on Enterprise Plan only, So If a customer has an Enterprise plan and we use the API will it also bring in activity for any users who are using a Business plan for example? Or will it only bring in users from the…
Smartsheet Admin license/Creating an App
I have been tasked with creating an app using the Smartsheet API/SDK. Our company only has a fixed number of licenses and does not plan on purchasing any more so I have to get an admin license transferred to me. I plan on creating an app in developer tools and storing the client id/secret in Azure Vault. Should I have the…
need help on Attachments API
How can i pull attachments added to row in smartsheet from third party system using API without using attachment id
Smartsheet pulling data from a API
Asking the community to see if you all have found a solution that smartsheet currently does not have one for. We are building an API for ourselves and our 3rd Party Partners to have access to a single source of data that smartsheets and other products would pull from. However, smartsheet does not have a solution to PULL…
Can I populate Smartsheet rows from a SQL Database read?
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
Bulk create Sheet from template through smartsheet API
Hello, I've currently been facing an issue regarding the Smartsheet API, a quick breakdown of what i'm trying to do, I require to create 900+ sheets that will all have the same layout (a template is available for that) After skimming through the API discovered the feature of creating sheets based on a template, problem is,…
Creating a Webhook that only gets triggered for new added rows but not for updates
Hello according to API documentation, creation request of Webhooks the events parameter should only get an array with "*.*" value.This would mean that web hook would be called on any changes happened on sheet. I would need to get my web hook get triggered only when a new row is added. Is it possible to limit this?

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