PostgreSQL JSON update not working

App Building
, ,
1

  • Goal: Update row with json object in postgresql table

  • Details: Whenever I try to include a json object in my insert query to my postgresql table it always gives me an error saying

update "pricinggrouptable" set "updatequeue" = $1 where "id" = $2 returning * - invalid input syntax for type json

The updatequeue column in my table is of a json type. And this is the object that I am trying to insert:

{"newName": {{editPricingGroupName.value}}, "newValue": {{editMarginValueInput.value}} }

This is the preview of the query:
Screenshot 2024-04-23 at 11.28.11 AM

2

Hi @jeevenugo,

Try wrapping the JSON in quotes instead of inserting the object. JSON looks like an object, but it's a string.

'{"newName": {{editPricingGroupName.value}}, "newValue": {{editMarginValueInput.value}} }'
3

Nope still giving me issues