About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to retrieve all rows matching a specific parameter in a MS SQL database column with Zapier?
Best answer

How to retrieve all rows matching a specific parameter in a MS SQL database column with Zapier?

Show first post

81 replies

A

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 @Danvers 

Is there any progress on this?

JammerS
Userlevel 6
Badge +3

Hi @Jim Case 

 

I’ve added your vote for this feature request, we’ll notify you via email once available. Thanks!

jammer․solijon
J
Userlevel 1

Please add my vote.  This is much needed! 

JammerS
Userlevel 6
Badge +3

Hi @kinship 

 

I’ve added your vote for this feature request, we’ll update you via email once available. Thanks!

jammer․solijon
K

Please add me to the list of requestors as well.  Any idea how many requests it takes to get a feature added?  I’m a potential customer working through my use case and without this feature, I don’t see moving forward.  We are querying a MySQL database and attempting to write new/updated records to rows of a SmartSheet.

JammerS
Userlevel 6
Badge +3

Hi @IanKerry 

 

I’ve added your vote for this feature request and we’ll update you via email once available. Thanks!

jammer․solijon
A

given this request was started years ago, it probably isnt going to happen, but in case please add my vote for it!

JammerS
Userlevel 6
Badge +3

Hi @Amrit 

 

I’ve added your vote for the feature request. We’ll shoot you an email once this is available. Thank you!

jammer․solijon
A

Please add me too. Really need this feature.

JammerS
Userlevel 6
Badge +3

Hi @BudgetCoinz 

 

I added your vote for this feature request, we’ll update via email once available. Thanks!

jammer․solijon
B

Please add me as well to this request!

JammerS
Userlevel 6
Badge +3

Hi @bisevo guy 

 

I’ve added you to this feature request. Thanks!

jammer․solijon
B

And add me to this request as well. To put it bluntly; we can’t  use Zapier for our purposes without this feature.

 

SamB
Rank
Userlevel 7
Badge +11

Sure thing @zappier! I’ve added your vote to that feature request now. :slight_smile:

Z

Add me to that list!! we are working where we will need this function! Thank you

SamB
Rank
Userlevel 7
Badge +11

Of course, @tlwaller! I’ve added your vote to that feature request now. We will notify you by email once it’s been added. :)

T

Add me to that list, seems like a pretty basic necessity for any database integration.

SamB
Rank
Userlevel 7
Badge +11

I’m sorry that workaround didn’t do the trick here, @aydinflyp :(

We’ll be sure to email you as soon as this feature request has been implemented! :)

A

Hey @christina.d, thank you for the quick response. Tried that mentioned solution out with Postgres and SendGrid. My custom query returned two rows but I had the option to select only one to continue and send an email with SendGrid. I will wait until a complete solution comes out.

christina.d
Userlevel 7
Badge +9

Thanks for reaching out, @aydinflyp! While we don’t have any updates to share at this time, I did get your vote added to this request. We’ll be sure to shoot you an email once we do know more. 🙂

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! 

A

Please add my vote as well and kindly let us know if there is any progress.

christina.d
Userlevel 7
Badge +9

You got it, @Amanda Shah! I’ve got your vote added to that request. 🙂We’ll keep you in the loop via email as well as update this thread as soon as we know more. 

A

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. 

SamB
Rank
Userlevel 7
Badge +11

Hey @neutron_star! 

I’ve added your vote as well. We’ll be in touch by email with any updates! :)

N

Please add me too. Really need this feature.

Reply


Terms & Conditions