Best answer

MS SQL Find Multiple Rows on the Same Table


Userlevel 2

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?

icon

Best answer by Danvers 8 June 2020, 17:23

View original

64 replies

Userlevel 5
Badge +3

Hi @BudgetCoinz 

 

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

Userlevel 1

Please add too

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! :)

Userlevel 1

Please add my vote.  This is much needed! 

Userlevel 5
Badge +3

Hi @kinship 

 

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

Userlevel 7
Badge +12

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

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. 

Userlevel 7
Badge +12

Hi, @Harris!

 

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. 

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.

Hi, @Harris!

 

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!

Userlevel 1

Please add me as well. 

 

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

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

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

Get my vote in as well please!

Please add my upvote as well, this would be a great feature. Thanks!

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

Userlevel 5
Badge +3

Hi @bisevo guy 

 

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

Userlevel 7
Badge +8

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

Userlevel 3
Badge +6

Hey @Zeeptin and @LoganH24, I hope you’re doing well!

I’ve just added you both as interested users on the feature request. :)

Userlevel 7
Badge +11

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

Userlevel 1
Badge

Add 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.

Userlevel 5
Badge +3

Hi @saintbrian 

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

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! 

Reply