Import `integer_range` from CSV with kibana `Visualize data from a file`?

Is it possible for the Machine Learning>Data Visualizer>Visualize data from file to import a csv file where one of the columns is an integer_range? If so, what is the syntax that should be used in the integer_range column of the csv file?

For example, this is my csv file:

price_range,customertype
"{""lte"":5}",regular
"{""gt"":5}",premium

During import, these are my advance settings:

And it produced this error:

0: failed to parse field [price_range] of type [integer_range] in document with id 'qGaN4IUB7CKCUde2IlRH'. Preview of field's value: '{"lte":5}'

{"message":"\"{\"\"lte\"\":5}\",regular"}

I added

    {
      "json" : {
        "field" : "price_range"
      }
    },

to the ingestion pipeline and everything worked!

1 Like