Loop over multiple results

Status: Closed · Asked by Juan Ramón Montero on · 0 views

juanmontero — Question ·

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

juanmontero — Reply ·

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 — Reply ·
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.

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
Pabbly — Reply ·

@juanmontero

We have updated your workflow. Please check it

juanmontero — Reply ·

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

Back to all forum threads · Log in to reply