Loop over multiple results
Status: Closed · Asked by Juan Ramón Montero on · 0 views
Greetings,
I have one flow: Test - Schedule To MySQL (Beta)
In it I have a custom MySql query and the result has multiple rows.
I would like to know to send those individual rows results to another app, lets say freshdesk.
If my query result contains 3 rows (column: name, email), how can i create 3 tickets on freshdesk?
Result of Query:
1 Juan [email hidden]
2 Maria [email hidden]
3 Susan [email hidden]
Thanks
Iterator module will help here -
Thanks Fagun. I have checked this before, but the problem with how MySQL connector is that the data is sent to pabbly row by row, not in json.
So I end up with hundreds of row like this:
result 0: name
Result 0: email
Result 1: name1
Result 1: email 1
Result 2: name 2
Result 2: name 2
And so on.
Thanks Fagun. I have checked this before, but the problem with how MySQL connector is that the data is sent to pabbly row by row, not in json.So I end up with hundreds of row like this:
result 0: name
Result 0: email
Result 1: name1
Result 1: email 1
Result 2: name 2
Result 2: name 2And so on.
Try turning off simple response toggle. It is above Save and Send Test Request Button.
Once you turn off that click on Save and Send Test Request button again.
@juanmontero
We have updated your workflow. Please check it

This was incredible! thanks a lot. Now it works perfect :)