Looping by Zapier -> mySQL update record

Hi @stylebase, I’m sorry that you’ve been having trouble with your Zap.

To see what’s going on we need to know how the Looping step is set up. Could you please share a screenshot of the Looping action showing what’s in each of the fields? Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).

Thanks!

Hi Danvers,

Sure thing:

Hi @stylebase 

Good question.

Each Loop will have it’s own Zap Run history details.

When you manually test a Looping step it will only run once.

Hi Troy,

Thanks for your answer, I understand that the test will only loop once, but the Zap run does the same (you can see that in the history, only 2 to 6 tasks run which is just the tasks of my Zap ie it never loops). 

Any idea how I can make sure it loops when scheduled instead of only running once?

Best

Elsa

Hi @stylebase 

First, to actually use the Loop, you have to map the values from the Loop to steps 6 and 7, otherwise you are mapping 1 value and so the loop will only run once. 

so the setup of the Looping by Zapier is incorrect. You need to find X amount of records, what is your search criteria? You need to insert the search criteria into the loop so it runs 7 times (like it shows in the first set of screenshots) and each time it would look for a new record. 
 

If you still need more help, you can share the search value of step 6 and the update value of step 7 so I can help you more.

Hi @MohSwellam 

Thanks a lot for your help. My issue is that SQL actions can only return one row.

What I am trying to do is return all the rows that have today’s date and a certain value in another column (status = PENDING) in a given field of the table. So my approach was to find the first match in the date and the status, run through the action, then update the status to DONE so that it wouldn’t find that same row again. 

I’m not sure if the looping can be done with mySQL. I can see how it can be done if I were to use google sheet but how inconvenient…

Otherwise I’ll have to trigger the zap every minute or so until no more rows are found, but again, quite inefficient in terms of task usage.

Let me know if you have any other ideas!

Best

Elsa

Hey @stylebase!

Given that the MySQL integration only returns one row, it sounds like your approach should work, where you use Looping. But your results would suggest otherwise :(

Your best bet to get a definitive answer is likely to contact our Support team. They can dig in a bit more to see what’s going on behind the scenes.

In the meantime, we do have a feature request for MySQL, to return multiple rows. I’ve added your vote for that, so if/when it gets implemented you’ll be notified via email! 

Hi, any luck solving this?