# Issues with Elasticsearch Scroll API results
**URL:** https://discuss.elastic.co/t/issues-with-elasticsearch-scroll-api-results/264581
**Category:** Elasticsearch
**Created:** [February 17, 2021, 1:30pm UTC](https://discuss.elastic.co/t/issues-with-elasticsearch-scroll-api-results/264581 "2021-02-17T13:30:29Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@samacker77elastic](https://discuss.elastic.co/u/samacker77elastic)
#### Post date: [February 17, 2021, 1:30pm UTC](https://discuss.elastic.co/t/issues-with-elasticsearch-scroll-api-results/264581/1 "2021-02-17T13:30:30Z")
Hi everyone,
I am trying to read documents from an index using the scroll API. The problem that I am facing is that, Kibana Discover shows the hits to be **195,867** , but my code misses or skips 10,000 documents.
I am not able to figure out the part I am doing wrong. Please find my code below.
```auto
DOMAIN = 'x.x.x.x'
PORT = 'y'
import json
from elasticsearch import Elasticsearch, exceptions
values_list = []
query_body = {
"size":10000,
"query":
{
"exists": {"field": "candidateSkills.skill"}
},
"_source": "candidateSkills.skill"
}
def fetch_data_from_ES(index_name):
results_dict = {}
global values_list
INDEX_NAMES = [index_name]
host = str(DOMAIN) + ":" + str(PORT)
client = Elasticsearch(host)
#client = client.params(scroll='25m')
try:
info = json.dumps(client.info(), indent=4)
print("Elasticsearch client info():", info)
except exceptions.ConnectionError as err:
print ("\nElasticsearch info() ERROR:", err)
print ("\nThe client host:", host, "is invalid or cluster is not running")
client = None
if client != None:
for index in INDEX_NAMES:
print("Fetching from index = {}".format(index))
doc_count = 0
query_body = {"size":10000,"query":{"exists": {"field": "candidateSkills.skill"}}}
resp = client.search(index = index,body = query_body,scroll = '25m')
old_scroll_id = resp['_scroll_id']
while len(resp['hits']['hits']):
try:
resp = client.scroll(scroll_id = old_scroll_id,scroll = '25m')
except:
resp = client.search(index = index,body = query_body)
if old_scroll_id != resp['_scroll_id']:
print ("Switched scroll ID")
try:
old_scroll_id = resp['_scroll_id']
except:
pass
for doc in resp['hits']['hits']:
doc_id = doc['_id']
values = doc['_source']['candidateSkills']
temp = [i['skill'] for i in values]
results_dict[doc_id] = temp
print("Creating dictionary, added {} values.".format(len(results_dict)))
return results_dict
```
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 17, 2021, 1:31pm UTC](https://discuss.elastic.co/t/issues-with-elasticsearch-scroll-api-results/264581/2 "2021-03-17T13:31:25Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.