Filter ExpandJSON


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.


A possible filter configuration is:

	Source = "json_data"
	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.


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 December 12, 2022