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.

Best answer

How to set up a Zap in Zapier to detect new or updated rows in an MSSQL table

  • February 20, 2025
  • 9 replies
  • 29 views
G

Hi,

Sorry if these are sill questions, but while in my trail phase, I have linked an SQL server (TESTInstance) and my TEAM accounts and I am trying to get a chat message to happen when Zappier see a row added to amended in a certain table (MyUsers) ( it is looking at a specific column (Hash) which changes when a row is added or a user updates information) . Zappier tests work, but when I do an actual change to an existing (dummy) user, nothing happens. Polling is set to 2 . I know that changes has happened as a) I did it, b) I can see the details in HASH has changes. Could someone  advise what I am doing incorrectly ? 

Best answer by Troy TessaloneBest answer by Troy Tessalone

​@GOker 

Did you review the help links?

 

Help links for using SQL Server in Zaps: https://zapier.com/apps/sql-server/integrations

 

View original
Did this topic help you find an answer to your question?

9 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 30974 replies
  • February 20, 2025

Hi ​@GOker 

Help us have more info by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
G
  • GOkerBeginner
  • Author
  • Beginner
  • 4 replies
  • February 20, 2025
Here are the screenshots, thank you :-) so when a change is made, this hash column / cell for the effected row changes. 
Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 30974 replies
  • February 20, 2025

​@GOker 

TIP: Click field labels that are underlined to see tooltips with more info.

 

Have you tried testing with your Zap turned ON?

Check your Zap Runs history for activity and to see the DATA IN/OUT for each step: https://zapier.com/app/history/

 

Help links for using SQL Server in Zaps: https://zapier.com/apps/sql-server/integrations

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
G
  • GOkerBeginner
  • Author
  • Beginner
  • 4 replies
  • February 20, 2025

ZAP is On. 

I make a change, and i wait 2 minutes. NOTHING. ZAP test when constructing it work, but not IRL .

 

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 30974 replies
  • Answer
  • February 20, 2025

​@GOker 

Did you review the help links?

 

Help links for using SQL Server in Zaps: https://zapier.com/apps/sql-server/integrations

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
G
  • GOkerBeginner
  • Author
  • Beginner
  • 4 replies
  • February 20, 2025

could very well be this then. 🤦‍♂️ Thankyou :-) 

JammerS
Forum|alt.badge.img+6
  • JammerSZapier Staff
  • Zapier Staff
  • 2350 replies
  • February 24, 2025

Hi ​@GOker,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

G
  • GOkerBeginner
  • Author
  • Beginner
  • 4 replies
  • February 24, 2025

Hi, yes, sorry, Forgot to amend the Ticket.  Basically, the table I was trying to use doesn’t have a DateTime column. 

JammerS
Forum|alt.badge.img+6
  • JammerSZapier Staff
  • Zapier Staff
  • 2350 replies
  • February 25, 2025

Wow! That’s good to know. Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.

Reply


Terms & Conditions