Hello guys!
We have found a bug in the Zapier Loop!
Context:
- We have a query returning 3 columns and 16 rows
- containing ids, names, list of topics
- represented as separated with ‘|’ strings, e.g. `one|two|three`, in order to work with Loops
- These 16 rows then was passed to the Zapier Loop from Text, attaching each column to a value
- All worked as expected besides the following:
- The ids and names columns all had values for all the rows
- The list of topics however were empty for some rows, including the first 2 rows of the results
- The Loop then SHIFTED UP the list of topics values by 2 rows to fill in the empty first 2 rows!
- Example say we had as result of the query:
- 1,bill,
- 2,john,
- 3,nick, a|b|c
- 4,jack,
- 5,dean,d|e
- 6,george,
- The Loop got
- 1,bill,a|b|c
- 2,john,
- 3,nick,d|e
- 4,jack,
- ...
- The loop had no issue handling the empty list of topics rows AFTER filling in the first one with something (observation)
Impact:
- Due to this issue we have send some wrong information to some recipients and had to do damage control
Temporary Workaround:
- We don’t allow empty values now to ensure we have the correct information for our automations
Expectations:
- We do expect the Zapier team to address this issue so we can remove the workaround at some point
Thanks for your time!
Bill
