I am trying to get the records from the elastic search using HTTP Request. When I try to get the bulk records for last 14 days.
When I check in Kibana I am able to see around 417 records from the discover, When I execute same query in n8n , I am able to get only 208 records only.
I am able see as below because of time-out or may I know the reason :
Hi @DilipChiru, I am afraid I won’t be able to answer this questions purely based on the information you have provided. My first guess is that you might be using different indices. Kibana might default to querying multiple indices whereas your n8n node might not do this.
Can you confirm the exact structure of an example Elasticsearch document you can’t find using n8n and share the exact workflow you are using to query this document?
Edit: From looking at your screenshot it seems you’re actually seeing the correct number. The value 208 in the took field simply specifies the milliseconds it took Elasticsearch to execute the request as per Search API | Elasticsearch Guide [8.10] | Elastic.
Basically, from the Http-request we have 433 records in last 14days. we can see from the screenshot. When I check from the Kibana discover page for last 14 days with same aggregation and also the respective filter. we can see 433 records. Even When I download into csv . We can see 433 records available from the csv.
Please suggest me on the above scenario to get full records. Currently, we are getting only 326 records.