Trouble with Extracting individual rows using workflow loop?

English Forum
1

I’m trying to using a workflow to duplicate multiple rows that already exist in an external postges table. It seems like it’s working 50%.

image
image422×667 7.81 KB

The SQL Query Node includes the code below…

INSERT INTO outside_process_flowdowns (“customer_unique_id”, “internal_part_number”, “createdAt”, “updatedAt” )
VALUES (‘{{$context.data.customer_unique_id}}’, ‘{{$context.data.internal_part_number}}’, ‘{{$system.now}}’, ‘{{$system.now}}’);

When I select two rows on the table with the check boxes and trigger the work flow what I’d expect is:
| new id 1 | copied customer_unique_id 1 | copied internal_part_number 1 |
| new id 2 | copied customer_unique_id 2 | copied internal_part_number 2 |

instead of looping through and separating each line it pushes the entire array of selected entries into each line
| new id 1 | [copied customer_unique_id 1, copied customer_unique_id 2] | [copied internal_part_number 1, copied internal_part_number 2] |
| new id 2 | [copied customer_unique_id 1, copied customer_unique_id 2] | [copied internal_part_number 1, copied internal_part_number 2] |

I can’t figure out how to make sure it separates the rows

2

You should use the data from the loop target object under scope variables when performing the SQL data insertion.
Of course, this requires that the loop object is configured correctly in your workflow.

3

Thanks shleyZ, you’re the best.