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…

Trending in API & Developers

Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?
Creating Webhook with subscope
Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { "callbackUrl": "https://www.myApp.com/webhooks", "enabled": true, "events": [ "*.*" ], "name": "Webhook for Sheet Creation", "version": 1,…

API & Developers

Discussion List