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

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?

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.