-
Auto-Sorting sheet hacks
Hey guys! I've long been searching for a way to make one specific sheet auto-sort, without having to create individual reports. I know this has been a requested feature for ages and that it's in the works. I was curious if anyone has come up with any clever workarounds that can be used while we're all anxiously waiting? I…
-
Bridge - JSON parsing - Remove HTML and match date
I'm looking for some help on how to extract particular data from a JSON response from an external API call made with Smartsheet Bridge. The API call is working fine, and I'm getting the JSON response. Part of the response is an indexed set of data within the response, that includes HTML formatting tags. I'd like to strip…
-
Use Javascript in Bridge to efficiently import data from an API
Hi all - I'm excited to share a custom Javascript solution with my fellow Bridge users. I am not a Jscript coder - all credit for this goes to the awesome @Nathan Lloyd at Smartsheet - Large Enterprise Technical Sales Engineer, who gave me the basis for this script at ENGAGE 2022. Thank you Nathan! In this thread I'll…
-
Attachments vs Discussion with Attachments
Am using below Smartsheet API to get all the attachments. It brings the attachments from attachments and attachment available under Discussion. No problem in that. smartsheetclient.Attachments.get_attachment(sheet_id, attachment_id) While deleting the attachments using the below API. Here the problem is attachments section…
-
Attempting PUT method on Reports "sourceSheets" field... Does anyone know what the API is expecting?
Hello! I am attempting to use the PUT method on a Report to update the source sheets, but cannot figure out how it wants the source sheets to be formatted.. Like what information do I need to put for each sheet in my array of sourceSheets? I am using Powershell. Here is my code so far: $token = <API TOKEN> $reportID = <ID…
-
Adding Image to Cell from gdrive URL automatically using Python & Smartsheet API
Hi All, I am currently trying to automatically adding image into a cell in smartsheet using Smartsheet API and Python. So, we have two column : Column A containing image URL Column B where we want to add the image from gdrive URL I have hundred rows, meaning we have hundreds cell on column B to add image from column A. I…
-
Can Smartsheet auto populate data from a pdf to one of the sheets?
I am working with a client and I actually build workflows in Smartsheet for different clients based on their requirement. This particular client has an editable pdf which they send out and get it filled. Now that they decided to use Smartsheet, I want to see if I can link this editable pdf to the sheet in Smartsheet and…
-
Does smartsheet have an endpoint for fetching the security controls from the admin centre
Hi @Lee Joramo @Genevieve P. Is there an end point/api or a sdk for fetching the the security controls from the Admin Centre page on the UI. If yes, does the access token need additional permissions. If No , Is there any other way to fetch these info. Or is it under development and when is it expected. Thanks, Narinder
-
Share Sheet on Bridge
I am trying to share a sheet via the Share Sheet module. I have set it up with a data reference pointing at a sheet id (I have also tried it with just the sheet ID). I've confirmed the data reference as well. The run log is saying success, but it is not in fact sharing the sheet or sending the intended email. If anyone has…
-
How to retrieve the only past 5 days created row using Smartsheet API
Hi All, I'm exploring the Smartsheet API. My use case to extract past 5days newly created records from my "ABC1231231" Sheet using Smartsheet API call. Kindly advise me which API method i need to use and how to use the Date query filter?