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?
How to retrieve all rows matching a specific parameter in a MS SQL database column with Zapier?
Hi,
Thanks for your reply and for letting us know why this addition would be helpful for you - I’ve added you as an interested user on the feature request.
Hi,
Thanks for your reply and for letting us know why this addition would be helpful for you - I’ve added you as an interested user on the feature request.
Could you please do the same for me as well? We would use the feature to retrieve all our customers that have birthdays that particular day and add them to a email list for that day!
Please add my upvote as well, this would be a great feature. Thanks!
Hey
I’ve just added you both as interested users on the feature request. :)
Me too as well!
Any alternatives for now?
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.
Please add me too. Really need this feature.
Hey
I’ve added your vote as well. We’ll be in touch by email with any updates! :)
Please add my vote as well via the email xxx@xxxx.com.
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
You got it,
Please add my vote as well and kindly let us know if there is any progress.
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!
Hey
I’m sorry that workaround didn’t do the trick here,
We’ll be sure to email you as soon as this feature request has been implemented! :)
Add me to that list, seems like a pretty basic necessity for any database integration.
Of course,
Add me to that list!! we are working where we will need this function! Thank you
And add me to this request as well. To put it bluntly; we can’t use Zapier for our purposes without this feature.
Please add me as well to this request!
Hi
I added your vote for this feature request, we’ll update via email once available. Thanks!
Please add me too. Really need this feature.
Hi
I’ve added your vote for the feature request. We’ll shoot you an email once this is available. Thank you!
given this request was started years ago, it probably isnt going to happen, but in case please add my vote for it!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.