Hi,
we want to use Zapier to automate a few tasks, based on the “New Row” or “New or Updated Row” PostgreSQL triggers. We’ve now read that these triggers will only return 50 rows with each poll – is that true? That would make it quite useless for us. Any tipps?
Here’s the article we’ve found: https://help.zapier.com/hc/en-us/articles/8496037193997-Common-Problems-with-PostgreSQL#existing-columns-causing-an-error-when-using-custom-query-0-0
Thanks!
Stefan
Best answer by Troy Tessalone
Hi
You may have to explore using APIs to get the data:
When using the "New Row" Trigger, each poll captures the 50 most recent rows. That means if more than 50 rows are added in a polling interval (5 or 15 minutes depending on your plan), some data will be lost.
If you need to capture more than 50 rows at a time, you'll want to add them to your database in batches—no more than 50 records at a time every 5 or 15 minutes (depending on your plan).
+14Hi
You may have to explore using APIs to get the data:
When using the "New Row" Trigger, each poll captures the 50 most recent rows. That means if more than 50 rows are added in a polling interval (5 or 15 minutes depending on your plan), some data will be lost.
If you need to capture more than 50 rows at a time, you'll want to add them to your database in batches—no more than 50 records at a time every 5 or 15 minutes (depending on your plan).
Appreciate your help!
+14
Honestly, not sure.
Best to try opening a ticket with Zapier Support for possible clarity: https://zapier.com/app/get-help
Appreciate it
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
