I'm trying to get more than 10k records from an Elasticsearch using the Rest api (http://localhost:9200/json-metrics/_search), but all I have is the rest api link, which is the input to my BI tool. I need those records in single url link. how to use the Rest API to get more than 10,000 records
You can use:
- the
size
andfrom
parameters to display by default up to 10000 records to your users. If you want to change this limit, you can changeindex.max_result_window
setting but be aware of the consequences (ie memory). - the search after feature to do deep pagination.
- the Scroll API if you want to extract a resultset to be consumed by another tool later. (Not recommended anymore)
@dadoonet
im new to elk, may be where to set the cofiguration index.max_result_window , any example for this
im using Nest
As I wrote, it's probably a bad idea.
but be aware of the consequences (ie memory).
index.max_result_window
is an index setting. So you set it when you create the index. I think you can update this setting on an existing index. Update index settings API | Elasticsearch Guide [8.11] | Elastic
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.