We have a postgres table with a JSONB column we’d like to update. We’re using ‘Update row in PostgreSQL”, however, when we specify a value, such as:
`{“key”: “Value”}`
..it inputs it into our db with escape characters that render the JSON invalid. We have also tried single quotes and other formatting, but are unable to find a consistent format that works.
How can we format a jsonb value?
Hi
Good question.
Can you post screenshots with how your Zap steps are configured along with a specific example so we can have more context?
Def. See attached, let me know if that’s not clear.
Have you tried removing the leading and trailing ‘ ?
Also, the values look to have JSON brackets {}, which may be impacting the JSON structure.
> Have you tried removing the leading and trailing ‘ ?
Yes, without ` ’ `, zapier automatically puts ` ” ` around the entire content, along with `\` escape characters for the quotes.
> Also, the values look to have JSON brackets {}, which may be impacting the JSON structure.
Correct, this is expected because we include query params. These are in the correct JSON structure and work within our application as expected.
If you suspect there is an issue with the Zap action, you can try opening a ticket with Zapier Support: https://zapier.com/app/get-help
This integration doesn’t support jsonb.
We have an open feature request to support this, and I’ve gone ahead and logged your email as a vote for that feature. I don't have an ETA on when that might happen, we get so many feature requests every day, but we do use these lists when we're working on app updates.
As we have your email logged as a vote there, we will be sure to drop you an email to let you know as soon as we get any news on that front.
I’m sorry I don’t have a better answer for you here.
Thanks for the info, we’ll have to find another workaround for now!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.