Loop over multiple results

[juanmontero]

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 protected]
2 Maria [email protected]
3 Susan [email protected]

Thanks

 

[Fagun Shah]

Iterator module will help here -

 

[juanmontero]

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.

 

[Fagun Shah]

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.

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.

 

[Pabbly]

@juanmontero

We have updated your workflow. Please check it

 

[juanmontero]

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