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

Best answer

Custom Query Syntax

  • 22 December 2020
  • 4 replies
  • 895 views
A
  • Anonymous
  • 0 replies

Hi There,

 

I am a newbie, and having great fun creating my new Zap. I have tried to search help but didn’t find anything.

 

My Zap connected to our SQL - a query - and works well in sending an invoice to Xero as a result.

 

However I now what to add something to the Trigger.  

I only want the Trigger to work, if the value of a field is a particular value.

So I have made the trigger “New Row (custom query)” and I have added in the query

where [cluster] = “I”

but this doesn't work - “Incorrect syntax near the keyword 'where'. (156)”

what is the synax of a customer query?

 

My plan is to create several zaps that will use this value of [cluster] to send the invoice to Xero, but use a different account code in Xero depending on the value of [cluster].

 

many thanks

 

ian

icon

Best answer by GetUWired 22 December 2020, 14:42

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Ennes
Userlevel 5
Badge +5

Hey @IanKerry ,

does it work to use a filter after your trigger? You can see how this works here. I also attached a screenshot for convenience.

I think this can help you to achieve the job. Instead of output, you should just use your specific variable and choose when the Zap should continue. Does that make sense?

Let me know!

A

Hey Ennes,

 

Thanks, I didnt realised that you could add filters and what if’s etc. That is great and I am sure now I will be able to get this sorted.

 

Thanks very much for your input.

 

Ian 

 

GetUWired
Userlevel 7
Badge +12

The problem likely lies with your SQL Query Statement, The SQL SELECT Statement doesn’t start with WHERE. The filter step should work but I would try to format my Select statement in proper syntax. 
SELECT column1, column2( or * to return all) FROM table_name WHERE [cluster] = “I”

https://www.w3schools.com/sql/sql_select.asp

A

Ah OK, thanks GetuWired. I do a lot of SQL queries in Access, I didnt realise the same syntax was used in a Zap. So that will be very useful, thanks.

 

Ian 

Terms & Conditions