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.

Has anyone experienced issues with custom queries using the Postgresql trigger not sending all the data?

I have an automation set up that populates a google sheet via a SQL query at a 6 AM each day. 

When I run the query locally on my db there are a handful of records that populate and it runs as expected. However, Zapier is only picking up one record instead of the multiple.

This tends to happen sporadically - sometimes the automation works as expected, other times it doesn’t. I’m a bit stumped and wondering if anyone else has run into a similar situation.

Thanks!

Hi @TryMystery, welcome to the Community!

Hmm, that is a bit of a puzzle. I took a look at know limitations and issues for Postgresql and I can’t see anything that immediate explains why it would sometimes only find one record. Are you using the new row trigger? If so, do you have an ‘Order by’ field in your Zap? It’s important to have one as it’s how the Zap can ‘deduplicate’ rows, how it remembers previous rows so it knows which ones are new/updated). Could you try adding one to see if that does the trick?

I hope that helps!

 

I’m using a custom query actually. Does the order by necessity come into play for custom queries as well?

Reply


Terms & Conditions