How to insert JSON data in SQLite?

[kfawcett]

I have JSON array field defined in my table using the Database Manager

The problem is the data is showing as undefined on insert.

How do I format the insert row so the array is stored properly?

[kfawcett]

Wrap the value in json() in the database insert.

{{json(message.data.labelIds)}}

Then on the page use parseJSON().

GmailLabelIds.parseJSON()