From parameter in delete by query API

I am trying to use the [delete_by_query](https://www.elastic.co/guide/en/elasticsearch/reference/7.x/docs-delete-by-query.html) API to keep a maximum of 5 documents for a user that are most recent. I am using the sort parameter on a date field along with the from parameter. The from parameter is giving me the following error

Validation Failed: 1: using [from] is not allowed in a scroll context;
2: from is not supported in this context

I am using the following query -


POST http://<ip>/<index_name>/_delete_by_query
{
    "query": {
        "term": {
            "user": "12345"
        }
    },
    "sort": {
        "date": {
            "order": "desc"
        }
    },
    "from": 5
}

Could you help me identify what is causing the error? Do I need to change the scroll context to something else?

Thanks.

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