Using the csv output plugin

Hi All,
I use the http_poller plugin to import data and get it in a nice json format. I also use the filter "split" to split the docs on "candles" and get this:

{
     "@timestamp" => 2017-10-06T12:48:01.197Z,
    "granularity" => "D",
       "@version" => "1",
     "instrument" => "EUR_USD",
        "candles" => {
          "volume" => 27536,
        "closeMid" => 1.167945,
         "highMid" => 1.17158,
         "openMid" => 1.17114,
          "lowMid" => 1.16692,
            "time" => "2017-10-05T21:00:00.000000Z",
        "complete" => false
    }
}

In kibana I just refer to the fields as"candles.highMid" . Now that I want the output to csv as well how do I refer to these fields within "candles"?
This dont work (closeMid will be empty - other columns will have values):
csv{
fields => ["closedMid","instrument","granularity"]
path => "../CSVEXPORT/csv-export.csv"
}
Neither do this work (closeMid will be empty - other columns will have values):
csv{
fields => ["candles.closedMid","instrument","granularity"]
path => "../CSVEXPORT/csv-export.csv"
}
Any suggestions how to refer to these fields within candles in the output to csv?

Br
Cris

Im sorry for this. Wasnt reading the manual properly.

Nested fields should be referenced as "[nested][field]"

This thread may be closed :slight_smile:

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.