https://community.splunk.com/t5/Splunk-Dev/Python-SDK-dbxquery-results-limited-to-100k-rows-using-jobs/m-p/608751#M10731 <P>Running a dbxquery through jobs.export my results are limited to 100k rows. Do I need to paginate streaming results?&nbsp;</P> <P>Here's my code:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="python">data = { 'adhoc_search_level': 'fast', 'search_mode': 'normal', 'preview': False, 'max_count': 500000, 'output_mode': 'json', 'auto_cancel': 300, 'count': 0 } job = service.jobs.export(&lt;dbxquery&gt;, **data) reader = results.JSONResultsReader(job) lst = [result for result in reader if isinstance(result, dict)]</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>This runs correctly except that that results are always stopped at 100k rows, it should be over 200k.</P> Tue, 09 Aug 2022 14:56:25 GMT joecav 2022-08-09T14:56:25Z https://community.splunk.com/t5/Splunk-Dev/Python-SDK-dbxquery-results-limited-to-100k-rows-using-jobs/m-p/608751#M10731 <P>Running a dbxquery through jobs.export my results are limited to 100k rows. Do I need to paginate streaming results?&nbsp;</P> <P>Here's my code:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="python">data = { 'adhoc_search_level': 'fast', 'search_mode': 'normal', 'preview': False, 'max_count': 500000, 'output_mode': 'json', 'auto_cancel': 300, 'count': 0 } job = service.jobs.export(&lt;dbxquery&gt;, **data) reader = results.JSONResultsReader(job) lst = [result for result in reader if isinstance(result, dict)]</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>This runs correctly except that that results are always stopped at 100k rows, it should be over 200k.</P> Tue, 09 Aug 2022 14:56:25 GMT https://community.splunk.com/t5/Splunk-Dev/Python-SDK-dbxquery-results-limited-to-100k-rows-using-jobs/m-p/608751#M10731 joecav 2022-08-09T14:56:25Z