-
BRIDGE - Using JSON as HTTP Call body
Hi all, I am trying to send a JSON payload using HTTP Call utility function, but on the target url I receive the payload as a string. I am actually using a Javascript script to build the payload and then using the reference as a body, but also trying using something like { "test": true } in the body will produce something…
-
Smartsheet Bridge/JavaScript functionality
Hi everyone! I'm trying to set up some automations through Smartsheet Bridge, but I'm running up against some possible limitations in the system and wanted to check with the community to see if there might be some workarounds. Does anyone know if it's possible to do one or both of the following: Access Smartsheet…
-
Does anyone have experience with handling JWT data with Bridge?
We're using Google PubSub service to receive updates notifications and they come with JWT encoding in the web hook endpoint. Does anyone have managed to decode JWT payload in Bridge since we cannot run libraries in Bridge and there's no working Javascript to decode it. Thanks!
-
Anyone know how to use "update row" in Bridge to add a Contact to a cell?
I am trying to add a contact with the display value of a name, and the value of an email address. I am using the format in the bridge documentation but still getting an error. Anyone have success and an example of the correct format? Thanks!
-
Bridge - Limit Amount of Characters in a String
I am trying to limit the amount of Characters in a String to Less then 50. So if there is more than 50 characters I want to remove the excess Characters, is this possible? I built out checking the size of the string and substracting the 50 from that amount, but I cannot find a way to remove that many characters from the…
-
Best Practice to read a large set of objects
I'm looking for the best practice method to read a large-ish data set from an API using Bridge. Specifically, I need to read 9000 rows from a Resource Management report and post that data to a Smartsheet sheet. But I also have this need coming up with other systems such as Gitlab and Workday. When I use a parent-child…
-
Use CSV from Extract Fields from Array?
Anyone know how to use the CSV output from the "Extract Fields" step in Array management? I'd like to save the results as a CSV and then use Data Shuttle to import it. I'm reading utilization data from Smartsheet Resource Management into a sheet in Smartsheet. But there's about 9000 rows and Bridge seems to be choking on…
-
Easy way to add contacts to a drop down?
I set up a workflow to add contacts listed in a sheet to a contact drop down of another sheet, however the workflow takes about 10 minutes to run since it is building an array with a child workflow. Does anyone have a cleaner way to take contacts listed on a sheet and update a contact dropdown?
-
Anyone have an example of Sorting an Object Array?
I just get the error stopped, doesn't tell me why. Pretty sure I'm doing it right.
