Zoho CRM ODBC error when trying to update Subform
I am trying to update the values in a subform. The subform data is in a string field of the primary form's table, formatted as a JSON array of objects -- each object being a row of the subform table.
When trying to modify the field via an Update query, I get the following error:
[Devart][ODBC][Zoho CRM]Unable to cast object of type 'Newtonsoft.Json.Linq.JObject' to type 'Newtonsoft.Json.Linq.JValue'
Update query format:
UPDATE Zoho...[CustomModule1] SET theSubformField = '[{"line_no":1,"price":10},{"line_no":2,"price":15}]' WHERE id = '.......';
Is it possible to update and create subform line items using the Devart Zoho CRM ODBC driver? And if so, how?