ExpandJSON

Filter ExpandJSON

Overview

ExpandJSON extracts values from a JSON formatted record field and writes them into other fields of the same record. It supports JMESPath to select the values to copy inside the JSON.

Example

A possible filter configuration is:

[[filter]]
name="ExpandJSON"
    [filter.config]
    Source = "json_data"
    [filter.config.Fields]
    jfield1  = "field1"
    jfield2  = "field2"

In this example, the filter extracts values of the jfield1 and jfield2 keys of the JSON object present in field json_dataof the record. Then, the values of that keys will be written into the field field1 and field2 of the same record.

Configuration

Keys available in the [filter.config] section:

Name Type Default Required Description
Source string "" true record field that contains the json
Fields map of strings to strings true <JMESPath -> record field> map, the rest will be ignored
TrueFalseValues array of strings [“true”, “false”] false bind the json boolean values to correstponding strings
Last modified April 6, 2021