Parse JSON Mutation

The Parse JSON mutation turns text that holds JSON into a JSON object or a list of objects. Use it on extra fields and other text fields that were imported as JSON, so the JSON mutations can read their attributes.

Options

This mutation has no options.

• A JSON array of objects becomes a list of objects.
• A single JSON object becomes an object. Use Extract attribute to read from it.
• Invalid JSON, or an array of plain values such as ["a", "b"], leaves the value unchanged and logs a warning.
• Text longer than 4096 characters is left unchanged.

Example

The extra field sizes holds this text:

[{ "size": "S", "chest": "86" }, { "size": "M", "chest": "92" }]

After Parse JSON the value is a list of two objects. Following it with Pluck attribute and the attribute size gives the list S, M.