-
Bridge examples including Javascript
Hi fellow Smartsheeters! In preparation for my session at Engage 2024, The future of workflows, I'm posting a variety of live Bridge examples to this thread. Each "block" will have a use case description, workflow layout, and (if needed) the javascript code I used. Enjoy!
-
BRIDGE - (URL's & IMAGES)
I've created 2 Bridge workflows. Add the URL of an attachment to a row cell. This works perfectly, but the URL is only active for 2 minutes then it becomes inactive. ? Is there a way to make URL's permanent when using Bridge ? Insert an attached image to a row cell I have not been able to get this to work as I intend. ? Is…
-
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…
-
Bridge and ServiceNow
Hi Community, We are embarking on integrating ServiceNow and Smartsheet using Bridge. I would love to hear from anyone who has experience with this integration and can provide some insights or best practices. Thank you, Chris
-
Sheet Access Report Size Limitations
Hello Community Friends - Does anyone have a creative solution for managing the Sheet Access Report? Ours has exceeded the max row limitations of both Excel and Google Sheets. We need the ability to look up who is Sheet Owner and/or Admin of various sheets that we might not have access to, but we can no longer load all of…
-
Problem when authenticating token in API Call. Smartsheet Bridge
When I run a Make API Call I get an 401 error, Invalid Token. I have configured the HTTP request body as per specifications from the website API documentation; it's a POST request, and the actual token has been put both within commas and without it. I believe the token is not the problem because I tested the code in IDEs…
-
Smartsheet Bridge special characters not encoding in endpoint URL
Has anyone ran into this issue? I would like to parse an ISO formatted time into the endpoint URL, but it's not encoding "+" to %2B. My particular use case is getting the latest CVEs from Vulnerability APIs (nist.gov) The endpoint should be formatted as such:…
-
Bridge: Data Reference Doesn't Return Same as Hardcoded Value
I'm connected to an external API that requires a token to be added as a Request Header for calls. The token cannot be hardcoded to the call since it expires every hour. So I must make a call to refresh the token then use that in subsequent call's Header. When I pass the token as a data reference to the Header of the…
-
Bridge + SharePoint Integration
From all the videos I've watched and materials I've read it seems that Bridge is used to bring info into Smartsheet. What if I want it to share intake requests FROM Smartsheet TO SharePoint? I have this use case to share intake requests between departments that's using different systems. Currently it is being done…
-
BRIDGE - Use Trigger Index to Pick From Array and Output
I am currently trying to use Bridge to create a list of all sheets that I have access to in a Smartsheet. I am only pulling in IDs for now but plan to eventually pull more data such as Sheet Name and a few other things related to each sheet. I have figured out how to pull the list of sheets and create an array of just the…
