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.)
Best answer
Customization options of Trigger Column for PostgreSQL?
Best answer by jacobPBest answer by jacobP
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.