Run a cell value from an array multiple times for an API GET request call?

lschek1

Is it possible to process an array containing the cell value (the array would be rows) in an API call in Smartsheet Bridge?

I have this scenario: I have a trigger that activates every time a value changes in a Smartsheet column. The way it runs helps to retrieve row by row and take the data I need to make an API call. I can make it run once a day like this.

This workflow works, the problem is, I would like to create a Schedule trigger that run this workflow two times a day at least, as the API call involves a connection to a tracking system, so it's required to be up to date.

When running a Schedule trigger, the Get Sheet element will retrieve many rows, so my question is if it's possible to somehow not to reference in the Form Parameter only one value from one row, but to bring over a tracking id multiple times? Each Tracking ID will be in all the rows. Does Bridge support this kind of process?

Paul Newcome

You would want to set up a parent/child workflow set. You can use the array reference to tell the parent workflow to run the child workflow as many times as is needed. You can also pass information from the parent workflow to the child workflow so that it can be leveraged later.

lschek1

Hi @Paul Newcome, Noted. I created the parent and the child workflow.

With Search Sheet, I'm able to retrieve the number of rows to loop, in this case, it would be two rows. In the Child Workflow element, I enter into Number of Rows the reference to data Array, basically following the steps in this post, but I got this error:

workflow execution failed: Plugin Error INVALID_DATA : failed to execute extension module : Failed to parse module params : The value '?' was not valid for the parameter 'rowIds'.

Paul Newcome

Do you have any child entity values you are passing?

lschek1

I didn't have values in child entity, in what format should I include it? For example, for this array with two values, there is 0 and 1, so if I want to pass "Carrier Code", should I add it like this: {{states.startstate.smartsheet.search_sheet.data.0.Carrier Code}} ?

I just run the workflow with this value in child entity but I got the above error message again.

lschek1

Sorry for the inconveniences, I figured out the issue. The error message was from the Child Workflow, didn't know the Parent Workflow logs were connected to the other workflow.

After doing some tests and checking the Child Workflow, I only needed to search for {{runtime.entities.id}} to retrieve the rows id, as I was using Smartsheet: Get Row to retrieve the row id. That's why the above error message came about.

Paul Newcome

Glad you were able to get it sorted.