-
Power Automate
Hi We are trying to connect DYN365 to a smart sheet solution - the date has been encapsulated in a dynamic Report - but we when we try to do the power automate workflow when can't seem to link to the report - Can Power Automate connect to a report or is it only a sheet?
-
Javascript fetch vs. Smartsheet
I am trying to query a smartsheet using very vanilla Javascript, see below. I verify that cURL will work using my API key, but the code below generates 403. I cannot use "require('smartsheet');" as the website platform does not permit. How can I get my Javascript snippet to behave as well as cURL? const apiUrl =…
-
How do I loop through an Array in Bridge?
Hello! I have been trying to loop through an Array in Bridge, and can't seem to figure it out. From what I can find online, I need to use a child workflow and send the Array there while also setting the child workflow's "number of runs" equal to the length of the Array. This is partially working. The Array is being sent…
-
How to Generate List of All Smartsheet Objects I can Access?
Hello, I have records management policies and often need to get a list of all of the Workspaces, Sheets, Reports, and Dashboards I can at least view as an account member. I typically use the "Access.csv" report to do this, but it does not include a few useful things. I'm wondering if maybe there are workarounds I can…
-
Issue: Smartsheet API Not Returning Data for Formula Columns in Sheets
I am experiencing an issue with the Smartsheet API where data from columns containing formulas are not being returned when querying a sheet. However, the same data is correctly displayed in the UI and can be accessed through reports via THE API. So I can access sheet data for formula columns via a report that points to…
-
How to add a row with a CONTACT_LIST column using API (python)
I am trying to add a row to an existing sheet with a CONTACT_LIST column. As far as I can tell, I am following the syntax properly, but I am always getting a validation error in the response. Can someone provide a sample request for this operation, using python. I found this similar question, and it says it was answered,…
-
Delete/Remove/Clear Hyperlink using API
While there are a wealth of articles, discussions, and examples of adding and updating hyperlinks in cells using the Smartsheet API, I struggled to find any concrete guidance on how to remove a hyperlink or clear a cell that contains one via the API. I need the equivalent of going into the sheet, hitting "Delete" in the…
-
Login to my app via smartsheet sso
I create a application with GUI to handle with data from smartsheet (crud). Then I make login module via OAuth2 flow to get the token to authentication and call some smartsheet API. But when I am done these procedures, I got a access token and refresh token which is not in jwt token. I use that token to call smartsheet API…
-
SAML Authentication issue when changing from PingFederate to PingONE
Encountering the following problem: "The EntityID associated with this IDP is already in use. Please select a unique EntityID for your setup." Even though we're using a different IDP, the problem persists.
-
changing the Row number for coommets?
Hello, Is there a way to change the comments notification to show a Ticket ID number instead of the row number? So in the picture change the Row 441 to ticket ID 500?
