How to read and store multiple rows of data using Bridge?
Hi all, I'm hoping that someone has solved for this, or that I'm being blind, but I can't see a way to easily read a array of objects using Bridge, where those objects contain multiple fields, and then loop through those objects.
I have an example below that I was able to make work by combining columns and extracting from the array, but that's not going to work for anything more complex. Surely there's a way to read a set of objects, each containing multiple fields/values, loop through that set, and do something with each object like inserting them as a row in a sheet with the values in different columns? I know child workflows are used to loop, but in my example below you'll see that they don't seem to work with an array of objects that contain multiple values in each object or more nested arrays.
My example is Gitlab. I have a Bridge workflow defined that runs through the following steps:
1) Search Sheet (Smartsheet) for rows that have a status update and epic ID defined in two columns
2) Get a list of objects from the search that looks like this
Smartsheet: Search Sheet
----------Status: 'my status'
----------Status: 'my status 2'
3) If I then try to run a child workflow and reference the data: Array in Number of Runs field, I get an error
I'm pretty sure this is because the child workflow can't reference an array that has multiple fields in each object.
To get around this, I used a sheet formula to combine the epic ID and status into a single field. Then I used Array: Extract Field to pull that field out of the Search results to arrive at an array that looks like this:
Array Management: Extract Field from Array
0: '123456-my status'
1: '67890-my status 2'
The child workflow was able to reference this Array for the Number of Runs fields, pretty sure that's because it's just a single item for each object in this array.
I can't be doing this for large objects with multiple values and further nested arrays though, which is how most info comes back from other tool's APIs (and even Smartsheet API).
Anyone have any ideas or examples of how you've successfully looped through a data set of multiple objects with multiple nested objects and arrays in each?
Thanks for any tips and help in advance!
BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM
SEATTLE WA, USA