Adds a field that contains data in JSON format.
You can add and edit content in JSON fields. There is a 2,500 character limit on JSON fields. To ensure that the JSON field is well-formatted, use the following JSON syntax when adding or editing fields via the API where,
- properties and values must be surrounded by double quotation marks
- double quotation marks must be escaped
For example:
[{"Fields":{"Name":"Asset1","JSONField":"[{\"FIELD1\":\"1\"},{\"FIELD2\":\"ONE\"},
{\"FIELD3\":\"true\"}]"}}]
Note: Date-time data must be formatted correctly, for example
"2019-05-01T00:00:00.000Z", or 2019-05-31. Date-time data is treated as UTC. If you
only provide the shorter date format, for example 2019-05-31, this can result in
unexpected displays due to timezone conversion. For example, the timezone conversion
may result in the display showing 2019-05-30.