API & Developers

Archives for February 2022

Save as new template set not saving all files
Hi everyone. I have template set consisting of appx 38 sheets/reports/dashboards in total. I have set it up with minimal info within it so every new project I start is a blank canvas but has all the automations and cell links kept. only thing that reallly changes is the project plan. unfortunately now when I try to save as…
Smartsheet app authorization
Greetings, Looking for a little guidance. I would like to develop an app that sends data to a sheet through HTTP. I have used the Python SDK with a raw token in the past but now I need a more secure solution and figured creating a 3rd part app is the way to go. I am having trouble with the workflow. Whilst following the…
Using a fillable PDF as a form to fill in Smartsheet
Hello, I am looking for ways to use fillable PDF (attached) as a form to fill out Smartsheet. Similar to how a form is generated in Smartsheet, is there a way for a fillable PDF to be used as a "custom form?" Each field can be defined and mapped beforehand to the corresponding smartsheet and "submit" would update the…
Need help integration QB and Smartsheet
I use smartsheet to keep all my projects and service calls. I would like to be able to select assign my customer to smartsheets from my Quickbook customers.
how to delete all the rows of a sheet using python at once
I am trying to build an automation that updates an excel file to smartsheet once I run it. I have build that program but issue i am facing is that they are getting updated below the previous one. So I want to delete the rows first .Is there any way to do it without requiring row id.?
Dropdown List Per Cell Using API?
I have been doing a ton of research on how to do a dropdown at the CELL level, instead of column level. All signs point to this being a lost cause, as the feature has been being requested for 5+ years now. However, one forum response indicated this is possible through API. Does anyone know if this is the case? If yes, how…
Transforming data from API in Power BI
Hello Smart People! I need to report on some data that I have compiled from many sheets in a Smartsheet report. The reporting tool that we have is Power BI, but the connector to Smartsheet defaults to IE, which isn't supported by Smartsheet. Apparently, this is a bug, and the work around is to add smartsheet.com to the…
Resource Managment API - Reports
When connecting to the report rows endpoint, I am receiving an error when using the timeframe as shown in the API documentation. "time_frame":{ "from": "2022-01-01", "to":"2022-12-31"} Error message received: {'message': 'to is not a valid time_frame'} The API works without error when using one of the canned strings such…
Send an email with Attachment
Hello, Is it possible to send an email with an attachment using Power Automate? Thanks, Shahara
Callback URL not receiving callbacks, but webhook lists last successful attempt.
Hi all, I'm am trying to integrate Smartsheet webhooks into my teams Power Automate flow. I have created the hook, enabled and verified it using HTTP response connector in PA. When making a change in the sheet as required my PA flow does not trigger. Getting the hook list shows a more recent timestamp for…

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

How do I integrate AMEX charges into Smartsheet
We are trying to automate our expenses. Daily we'll copy and paste transactions for our staff to identify, and attach receipts. We'd like to automate the copy and paste sequence and have transactions automatically be pulled from AMEX daily. Ideas?
unable to move a row in Python
I use Smartsheet to govern a project that does ~10k tasks per year so automating as much of the project is extremely helpful. I have multiple python scripts that are updating sheets and grabbing data form sheets but this is the first time i have tried to move data in a sheet. I am trying to move a row below another row…
Snowflake Data into Smartsheet?
Hey everyone, Do you know if there is a way to connect Snowflake data into Smartsheet using the API? I have found many resources on getting Smartsheet data into Snowflake but nothing on the other way around. We are trying to either do something native within Smartsheet or use an open-source software such as Airbyte.

API & Developers

Discussion List