Using the csv output plugin


(Cristian) #1

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


(Cristian) #2

Im sorry for this. Wasnt reading the manual properly.

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

This thread may be closed :slight_smile:


(system) #3

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