Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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?

T

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 SamB

Hey folks,

Just circling back in here to share that the feature request has been closed - a new Find Multiple Rows via Custom Query action has been added to the latest version of the MySQL app. 😁🎉

That action will allow you to use a custom query to fetch multiple rows. If you’re not able to see that action in your Zaps you may need to upgrade the Zaps to use the latest version of the MySQL apps. You can learn more about upgrading apps in a Zap here: Update to the latest app version in Zaps

Hope you’re able to give that new action a try soon. If you run into any issues with it please do reach out in the Community to let us know. In the meantime, happy Zapping! ⚡

View original
Did this topic help you find an answer to your question?
19% found this helpful

82 replies

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • June 8, 2020

Hi @The Agents!

 

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. 

D
  • devHC
  • New
  • 1 reply
  • June 22, 2020

Hi we would like to vote to enable multiple rows. It’s really stupid to not allow for multiple rows. 

ManorlyDev
1 person likes this
  • ManorlyDev
    ManorlyDev
Liz_Roberts
Forum|alt.badge.img+8
  • Liz_RobertsZapier Staff
  • Zapier Staff
  • 1366 replies
  • June 23, 2020

@devHC you have been added as another vote for this addition. As Danvers mentioned, you will receive an email if this functionality becomes a reality. 

A
  • Anonymous
  • 0 replies
  • August 14, 2020

And please add me as anther vote for this.  Typical application would be to sync/add multiple contacts information from a MySQL db with a Contacts service.

R
  • raizz
  • New
  • 2 replies
  • November 12, 2020

Gahhh add a vote from me, too, please. 

Liz_Roberts
Forum|alt.badge.img+8
  • Liz_RobertsZapier Staff
  • Zapier Staff
  • 1366 replies
  • November 12, 2020

@raizz you have been added!

I
  • involved
  • New
  • 1 reply
  • January 4, 2021

please add me too. thanks!

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • January 4, 2021

Hi @involved, I’ve added you as an interested user on the feature request 🙂 Thanks!

S
  • SankonBeginner
  • Beginner
  • 5 replies
  • January 13, 2021

Please add me as well. 

 

Its essential for pulling multiple row for reports, so yes please 

Liz_Roberts
Forum|alt.badge.img+8
  • Liz_RobertsZapier Staff
  • Zapier Staff
  • 1366 replies
  • January 13, 2021

Hi @Sankon - you have been added as an interested user!

C

No progress on this yet? Please add me to the feature reguest as well. 

S
  • stir
  • New
  • 1 reply
  • January 25, 2021

Hi, this is essential to have not just for MYSQL but also Postgres. Please add my vote as well.

nicksimard
Forum|alt.badge.img+11
  • nicksimardZapier Staff
  • Zapier Staff
  • 2115 replies
  • January 25, 2021

Hi @chris12312124 and @stir you’ve been as interested users as well :)

S
  • SandsTabs
  • New
  • 1 reply
  • February 12, 2021

Please add my vote for this as well

Liz_Roberts
Forum|alt.badge.img+8
  • Liz_RobertsZapier Staff
  • Zapier Staff
  • 1366 replies
  • February 12, 2021

@SandsTabs you have been added to this request!

D
  • Dinozaur
  • New
  • 2 replies
  • February 27, 2021

Please add too

steph.n
1 person likes this
  • steph.n
    steph.n
steph.n
Forum|alt.badge.img+8
  • steph.nBuilder
  • Builder
  • 899 replies
  • March 1, 2021

@Dinozaur - Added you!

V
  • Vagludir
  • New
  • 2 replies
  • March 12, 2021

Get my vote in as well please!

steph.n
Forum|alt.badge.img+8
  • steph.nBuilder
  • Builder
  • 899 replies
  • March 12, 2021

Hi @Vagludir - I’ve added your upvote for this feature request. Should it become available, you’ll be contacted directly via email. Thanks!

M

I could really use multiple rows as well. do you have an idea of when something like this might be available?

 

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • March 15, 2021

Prioritization is largely dependent on the number of customers affected. By adding your vote, I was able to add some weight to the issue! 

 

I'm sorry I don't have a more definitive answer here, we’ll send you an email if we have any updates. 
 

R
Forum|alt.badge.img+1

Hi there @The Agents I have an idea on how this can be "hacked” you could create a view using the FOR JSON

please read both articles I think you could find the trick.

https://docs.microsoft.com/en-us/sql/relational-databases/json/format-query-results-as-json-with-for-json-sql-server?view=sql-server-ver15


https://www.mssqltips.com/sqlservertip/5348/advanced-techniques-to-transform-relational-data-to-json-in-sql-server-2016/

then parse the JSON you get from Row/Find
 

O

Get my vote in as well please!

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • March 16, 2021

Hi @Oscar Bradford - I’ve added you to that feature request. Thank you!

H
  • Harris
  • New
  • 1 reply
  • May 23, 2021

I’m interested in this feature too, please add me and also is it possible to suggest workarounds in the meantime?

 

e.g I have a VoIP product, and I want to send Top 10 users to our Slack channel. Currently it can only return the Top 1 user from the MySQL custom query...

Reply


Terms & Conditions