# Elasticsearch - Timestamp based document Upsert
**URL:** https://discuss.elastic.co/t/elasticsearch-timestamp-based-document-upsert/265688
**Category:** Elasticsearch
**Created:** [February 27, 2021, 11:34am UTC](https://discuss.elastic.co/t/elasticsearch-timestamp-based-document-upsert/265688 "2021-02-27T11:34:45Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@tag\_v](https://discuss.elastic.co/u/tag_v)
#### Post date: [February 27, 2021, 11:34am UTC](https://discuss.elastic.co/t/elasticsearch-timestamp-based-document-upsert/265688/1 "2021-02-27T11:34:45Z")
I am looking for more efficient and performance way to implement below use case:
- Every input JSON contains event\_timestamp and document\_id field. document\_id is '\_id' for the index.
- If a document with document\_id already exists in index and event\_timestamp of new input json is latest than existing document's event\_timestamp, perform update operation
- If a document with document\_id already exists in index, but, event\_timestamp of new input json is older than existing document's event\_timestamp, no operations
- If document with document\_id not exists in index, perform insert operation
Currently, I am performing 2 round trip calls to from Elasticsearch. Is there any better way to do similar to hbase timestamp column which stores latest timestamp event ?
Thanks in Advance.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 27, 2021, 11:35am UTC](https://discuss.elastic.co/t/elasticsearch-timestamp-based-document-upsert/265688/2 "2021-03-27T11:35:26Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.