Hello All,
I have saved search which i am trying to export to csv.
But i got error:
document_parsing_exception Caused by: illegal_argument_exception: Expected text at 1:623 but found START_OBJECT Root causes: document_parsing_exception: [1:726] failed to parse field [payload.searchSource.filter.query.range.@timestamp] of type [date] in document with id '02f59028-923f-4d17-840e-1a63a7dbf1df'. Preview of field's value: '{format=strict_date_optional_time, gte=2024-06-30T22:00:00.000Z, lte=2024-07-31T23:00:00.000Z}'
My @timestamp field is in type date.
And data are from datastream.
Also added format to timestamp field :
dd.MM.yyyy HH:mm:ss
What is the issue?
These are my mappings :
Tried everyone none is working.
".ds-winlogbeat-8.13.1-2024.10.17-000049": {
"mappings": {
"@timestamp": {
"full_name": "@timestamp",
"mapping": {
"@timestamp": {
"type": "date",
"format": "strict_date_optional_time||epoch_millis||strict_date"
}
}
}
}
},
".ds-winlogbeat-8.13.1-2024.10.08-000042": {
"mappings": {
"@timestamp": {
"full_name": "@timestamp",
"mapping": {
"@timestamp": {
"type": "date"
}
}
}
}
},
".ds-winlogbeat-8.13.1-2024.10.16-000043": {
"mappings": {
"@timestamp": {
"full_name": "@timestamp",
"mapping": {
"@timestamp": {
"type": "date",
"format": "strict_date_optional_time||epoch_millis||dd.MM.yyyy HH:mm:ss"
}
}
}
}
},
Any hints what can cause issue?