I’m getting a very weird error that I’m not sure how to solve.
I have a workflow that retrieves information from ClickUp and then inserts into postgres.
Clickup has many fields stored as a json string.
The insert works perfectly now.
However, when I’m trying to do an update operation in postgres, using the exact same workflow to transform my data before updating it, I get the error
ERROR: column “my_column” is of type jsonb but expression is of type text
I tried the stringify function on the column but it is not working.
Appreciate any advice on how I could solve this or debug it.