-
/users API throwing User not found.
Fetching all users using below API fetches all the users with status, ACTIVE, DECLINED, DEACTIVATED. https://api.smartsheet.com/2.0/users But when we try to fetch the single user using https://api.smartsheet.com/2.0/users/abc If the user abc has status as DECLINED. It fails with error { "errorCode": 1020, "message": "User…
-
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…
-
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…
-
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…
-
Generate list of current group memberships for a given user in Bridge
I would like to be able to make an API call in Bridge to generate a list of all groups/groupIDs that a user is a member of. To my knowledge, this can only be done for me as the "current user" at this time.
-
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
-
How will the new email OTP login method impact Live Connector?
How will the new email OTP login method impact Live Connector’s 32-bit ODBC connection?
-
Bridge - Error with POST call to API - Invalid Body
I'm trying to make a post call to an API using the "Call API" action within Bridge. Unfortunately, every time I try this action, it fails with an "Invalid Payload" response. I've tested the payload in Postman, and it seems to be working correctly. The API I'm using is a "POST" to a Slack Webhook. (It will automatically…
-
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…
-
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…
