Convert epoch time columns to date in lostash config file

Elastic Stack Logstash
1

Hey as per below, i have am polling a http and passing through the csv filter pulling date which works fine. However I need to convert the epoch timestamp to readable date and time. I have tried a few different ways with no luck including convert in the csv plugin and the date plugin.
I have even tried deleting the indexes and letting it pull again but the data still comes through as 'text'

filter {

                         ## Parse values from "cdr" array and create a field for each value ##
   csv {
     source => "message"
     separator => ","
     skip_header => "true"
     columns => ["callref","created","time_start","direction","platform","source","destination","clid","to","duration","billable_time","billed_cost","definition"]
		#convert => {
		#	"created" => "date_time"
		#	"time_start" => "date_time"
		#}
     target => "cdr"
   }
   date {
		match => [ "created","UNIX_MS" ]
		target => "created"
		timezone => "UTC"
}
2

What does the output look like right now?

3 
    {
      "_index": "test-2020.08.07",
      "_type": "_doc",
      "_id": "lEmTx3MBIcx4DRpOZCjF",
      "_version": 1,
      "_score": 0,
      "_source": {
        "cdr": {
          "duration": "2412",
          "billed_cost": "0.5423",
          "callref": "Q8W2VT3MBEG5",
          "destination": "61185991111",
          "clid": "61108251111",
          "definition": "outbound_fixed",
          "billable_time": "2410",
          "direction": "outbound",
          "time_start": "1596758421",
          "source": "J8UHA67",
          "to": "61285992111",
          "created": "1596760833",
          "platform": "AIRtest"
        },
        "@timestamp": "2020-08-07T06

whereas i would like to show time_start and created to human readable as per below

GMT : Friday, August 7, 2020 12:00:21 AM
Your time zone : Friday, August 7, 2020 10:00:21 AM GMT+10:00

4

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