@vsr1 I am trying this below query and I am getting error.
vID = “12323” // getting from a array of objects
historyID= “34333” // getting from a array of objects
INSERT INTO `pure-ems-history` (KEY k.id, VALUE jdata)
select RAW OBJECT_PUT(jdata, "iRef", $vID) from ( SELECT RAW OBJECT_PUT(k, "id", UUID())
FROM `pure-ems-history` AS k WHERE k.id = $historyID) AS jdata;
error -
{"code":5070,"msg":"Cannot INSERT non-string key Missing field or index id. of type value.missingValue."},