# Deleting duplicates in index using API query **URL:** \ **Category:** Elasticsearch\ **Created:** [June 23, 2022, 5:24am UTC](https://discuss.elastic.co/t/deleting-duplicates-in-index-using-api-query/307945 "2022-06-23T05:24:24Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Naga\_Prudhvi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/naga_prudhvi/32/99501_2.png) [@Naga\_Prudhvi](https://discuss.elastic.co/u/Naga_Prudhvi)\ **Post date:** [June 23, 2022, 5:24am UTC](https://discuss.elastic.co/t/deleting-duplicates-in-index-using-api-query/307945/1 "2022-06-23T05:24:24Z")
I an in search of a query to to delete the duplicates for below example index data: name product sale id sai pen 100 1 kumar car 30 2 sai pen 100 1 sai pen 100 1 ram bike 288 3 kumar car 30 2 After deleting duplicates my index should loook like below, name product sale id sai pen 100 1 ram bike 288 3 kumar car 30 2 ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [June 23, 2022, 5:47am UTC](https://discuss.elastic.co/t/deleting-duplicates-in-index-using-api-query/307945/2 "2022-06-23T05:47:26Z")
Please do not open multiple threads on the same topic. This has already been asked and answered [here](https://discuss.elastic.co/t/how-to-identiry-duplicates-and-delete-it-in-index/307830/5) and [here](https://discuss.elastic.co/t/how-to-identify-and-remove-duplicates-in-elasticsearch-index/307866/4). ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 23, 2022, 6:07am UTC](https://discuss.elastic.co/t/deleting-duplicates-in-index-using-api-query/307945/3 "2022-06-23T06:07:33Z")