Postgres error showing unable to find column that's actually there

[SnackGuy]

Your Workflow URL

https://connect.pabbly.com/v2/app/workflow/mapping/IjU3NjcwNTZjMDYzNzA0MzE1MjY1NTUzNzUxM2Ii_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

I am trying to run a postgres action to update a table using data from an API call. I am trying to reference a status column, but the tool seems to think its a column called "new". It wont complete the action and errors out each time. Are there any ideas on how to better get this working?

 

[Preeti Paryani]

Hi @SnackGuy,

Thanks for reaching out.

Could you please share the exact PostgreSQL query you’re trying to run?

Also, from your screenshot, it looks like you’ve mapped “Status” as a key, and the value being passed during execution is “New”. That’s why it’s getting treated incorrectly in the query.

To fix this, we recommend using a static status text/value (instead of mapping the status key) or mapping the actual value field you want to update.