Search with offset returns duplicates
See attached Search_query_API_issue.docx.
(from attachment) Search query API issue: Search query API is having a limit of retrieving only 1000 records. To retrieve the all the records from the DB we need to call the search API multiple times until we get all the records. When Search API is invoked for the first time that is for first iteration it will get 1000 records. For the second iteration we will pass the offset value. When we are passing the offset value, we are indicating it to retrieve the data from that point. And the iteration goes on until all the records are retrieved. And the offset value is increased for every subsequent iteration. But we observed that the Search query API is not working as intended to work with the offset value. The order of retrieval of records is not maintained. It is retrieving the records which are already returned. So this is giving the duplicate records. For Example, below when we are trying to retrieve the CRS data using the Search query API...