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