Hello. I am hoping that someone may have a workable approach. I am trying to load several thousand search results into my script and I am only getting back the limited 1000 results. I understand how to re-process the search to obtain all of the results. The only way that I know how to do this is to sort the results using the internal id and cycle the other iterations based on the last internal id. However my dilemma is that I have not been able to get the "item internal id" field off of the item pricing records without timing out the search. It seems to be wanting to return every single combination for every item and customer iteration - even though I am filtering through using the customer as well.
So far I have only worked with the search in the UI, and it works great up until I include the Item Internal ID in the results. This is a customer search pointing to the Pricing Item join. Any thoughts would be greatly appreciated!