Write as JSON Map directive

The WRITE-AS-JSON-MAP directive converts the record into a JSON map.

Syntax

write-as-json-map :column

The column will contain a JSON map of all the fields in the record.

The WRITE-AS-JSON-MAP directive converts the entire record into a JSON map. If the column already exists, it will overwrite it.

Depending on the type of object a field is holding, it will be transformed appropriately.

Using this record as an example:

{
  "int": 1,
  "string": "this, is a string."
}

Applying this directive:

write-as-json-map :body

results in this record:

{
  "body": { "int":1, "string": "this, is a string." },
  "int": 1,
  "string": "this, is a string."
}