I've been using using apex_json.write to write json for some time which has been working out great.
However today the cursor to write as json had a column containing json.
the result for the json column wasn't what I was after.
The result was like :
"INGREDIENTS":"[{\"Bread Improver\":\"1g\"},{\"Flour\":\"480g\"}]"
When was hoping for something more like:
"INGREDIENTS":"[{"Bread Improver":"1g"},{"Flour":"480g"}]"
Is there anyway around this? Its a solution still under construction I could save something else in the column other then json but am not sure if that woulf help...I'm hoping to avoid trying a nested table.