I’m using a Zap to retrieve data from our MS SQL database. I need the zap to retrieve every row that match a certain parameter in a specific column. For instance, I need every row that has invoice # 3511151 in the invoice # column of the table. Is this possible?
Best answer by Danvers
View originalAdd me to … seems silly that this request has been in queue for over 2 years. You’ve enabled a custom SELECT from SQL, but you only allow inserting 1 record. I’m not even sure how this is helpful.
Add me to that list, seems like a pretty basic necessity for any database integration.
Please add me too. Really need this feature.
+3
Hi
I’ve added your vote for this feature request, we’ll notify you via email once available. Thanks!
+9
Thanks for reaching out,
My teammate Sam did post a potential workaround depending on your workflow that I’ll drop below:
One workaround I can think of might be to start your Zap with the MySQL trigger "New Row (Custom Query)". I believe each different row that is found by this query would trigger the Zap individually and allow you to carry out any desired actions on it. Though depending on the desired workflow this may not be ideal.
Another potential workaround would be to mirror your database in an app like Google Sheets, which does support multiple rows for search action steps.
I hope this helps and welcome to the Community!
+3
Hi
I’ve added your vote for this feature request, we’ll notify you via email once available. Thanks!
+8
Hi
+11
Thanks for reaching out here,
Please add my vote. It’s crazy that it’ll only update one row at a time, it almost renders the app useless!!
Hey
+3
Hi
I’ve added your vote for the feature request. We’ll shoot you an email once this is available. Thank you!
+11
Of course,
+9
You got it,
+3
Hi
I’ve added your vote for this feature request, we’ll notify you via email once available. Thanks!
+11
Hey
I’ve added your vote to the feature request too! We’ll reach out by email as soon as we have an update in this! :)
One workaround I can think of might be to start your Zap with the MySQL trigger "New Row (Custom Query)". I believe each different row that is found by this query would trigger the Zap individually and allow you to carry out any desired actions on it. Though depending on the desired workflow this may not be ideal.
Another potential workaround would be to mirror your database in an app like Google Sheets, which does support multiple rows for search action steps. Though again, this may not be an ideal solution for your specific workflow.
+8
+12
Hi
It’s not currently possible to find more than one row using the Find Row/Find Row using Custom query actions in the MySQL Zapier integration, sorry about that!
We do have a feature request open to for this and I've added your email address as another vote for this addition. I don't have an ETA of when or if this will happen, but we will definitely email you if it does become a reality.
I could really use multiple rows as well. do you have an idea of when something like this might be available?
Is this still not solved?
I’m using a Zap to retrieve data from our MS SQL database. I need the zap to retrieve every row that match a certain parameter in a specific column. For instance, I need every row that has invoice # 3511151 in the invoice # column of the table. Is this possible?
Hi
Is there any progress on this?
No progress on this yet? Please add me to the feature reguest as well.
+11
Sure thing,
Mark B’s suggestion won’t work if you don’t have a unique column in your data set. I can’t believe it has been 3 years and there still is no solution. MySQL queries return multiple rows all the time!!
Is there any chance this request will ever be addressed? It has been 3 years...
Gahhh add a vote from me, too, please.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
