-
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
-
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…
-
Why is Smartsheet only adding one blank row instead of all the rows it read from G-sheet?
Hi, I'm trying to make a script from Apps Script to work with Smartsheet and I'm stuck. The script is to process some rows that need to be copied to a specific Smartsheet based on some filtering criteria, but after the script runs, we can see the following. Is there anything that might be preventing Smartsheet from pasting…
-
/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