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

Customization options of Trigger Column for PostgreSQL?

  • 19 March 2020
  • 3 replies
  • 192 views
J
Userlevel 1

I’m looking to have Zapier only trigger based on a specific PostgreSQL change to a JSONB value. 

I’m using the PostgreSQL “New or Updated Row” trigger.

My PostgreSQL database has a table with a JSONB column, which, among many other key:pair values, has a boolean setting.

Can I set the Zap to trigger off of a change to that specific JSON value? I know that ‘Trigger Column’ section has a Custom field that I can enter something into, but what are the limitations here? I can’t find documentation.

(The ‘New Row (Custom Query)’ option won’t work in my case, because a new db row cannot be created in this instance.)
 

icon

Best answer by jacobP 24 March 2020, 15:33

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.

3 replies

Danvers
Userlevel 7
Badge +12

Hi @jacobP I’m sorry for the delay in getting you a response on this one!

 

I can see that you have a ticket open with our support team - where they able to answer your question about using the JSON value to trigger the sheet?

J
Userlevel 1

@Danvers, thanks for getting back. I tried to delete the original post, as I figured it out myself... the answer was filters. (I didn’t even know they existed). 

Danvers
Userlevel 7
Badge +12

Thanks for letting us know,  @jacobP!

Terms & Conditions