AutomateC.exe /exportqueue - how to get more than 5000 rows?

asilarow — Wed, 10 Jun 2026 14:17:27 GMT

Hey All,

I had an interesting requirement lately to export blue prism work queue data to csv, and save on a network share...

So I've written a batch file that does that, but noticed that there is one annoying limitation:

The filter by default limits the export to whatever is set on the "Rows Per Page" field.

Now in this particular scenario this is sufficient... however, what if I would have a larger queue?

I can't find anything documented about this anywhere 😕

Does anybody know can this be changed somehow? or is this a hard limitation?

Oh, and Ideally I want to avoid having to build a process just for this.

I know this can be done via the work queue reporting process from DX... but it's too much effort for something that should be simple.

FYI - for the interested people, batch file below:

@echo off
setlocal enabledelayedexpansion

:: ==============================================================================
:: CONFIGURATION PARAMETERS
:: ==============================================================================

:: FIXED: Removed the accidental duplicate quote before C:\
set "BP_PATH=C:\Program Files\Blue Prism Limited\Blue Prism Automate\AutomateC.exe"

:: Blue Prism Queue Name and Saved Filter Name
set "QUEUE_NAME=WorkQueueNameGoesHere"
set "QUEUE_FILTER=QueueFilternameGoesHere"
set "FILENAME_PREFIX=FileNamePrefixGoesHere"

:: Target output directory
set "TARGET_DIR=OutputDirectoryPathGoesHere"

:: Generate a stable YYYY-MM-DD timestamp independent of Windows locale settings
for /f "tokens=*" %%i in ('powershell -NoProfile -Command "Get-Date -Format 'yyyy-MM-dd HH-mm'"') do set "TODAY=%%i"

:: Define full export file path (saves as a .csv report)
set "EXPORT_FILE=%TARGET_DIR%\%FILENAME_PREFIX% - %TODAY%.csv"

:: ==============================================================================
:: EXECUTION
:: ==============================================================================

echo Verifying target directory existence...
if not exist "%TARGET_DIR%" (
echo Directory does not exist. Creating: "%TARGET_DIR%"
mkdir "%TARGET_DIR%"
)

echo.
echo Starting Blue Prism Queue Export...
echo Queue Name: %QUEUE_NAME%
echo Queue Filter: %QUEUE_FILTER%
echo Target File: %EXPORT_FILE%
echo.

:: --- AUTHENTICATION METHOD ---
:: Ideally should be done via credential store, but for smaller deployments this is fine

"%BP_PATH%" /user USERNAME PASSWORD /queuename "%QUEUE_NAME%" /queuefilter "%QUEUE_FILTER%" /exportqueue "%EXPORT_FILE%"

:: FIXED: Using GOTO instead of () blocks to prevent parenthesis from crashing the script
if %ERRORLEVEL% equ 0 goto :success
goto :failed

:success
echo.
echo [SUCCESS] Queue data exported successfully to: "%EXPORT_FILE%"
goto :end

:failed
echo.
echo [ERROR] Export failed with exit code %ERRORLEVEL%.
echo Please verify that the saved filter "%QUEUE_FILTER%" exists in the Control Room and that your credentials are valid.
goto :end

:end
echo.

Re: AutomateC.exe /exportqueue - how to get more than 5000 rows?

sumire — Wed, 10 Jun 2026 23:46:48 GMT

Hello @asilarow ,

How about retrieving records directly from the database using SSMS, Power BI, or Excel?

Re: AutomateC.exe /exportqueue - how to get more than 5000 rows?

asilarow — Thu, 11 Jun 2026 08:03:06 GMT

Oh, sorry... forgot to mention - this is on Blue Prism Cloud... so no access to the DB 😞

topic AutomateC.exe /exportqueue - how to get more than 5000 rows? in Product Forum

AutomateC.exe /exportqueue - how to get more than 5000 rows?

Re: AutomateC.exe /exportqueue - how to get more than 5000 rows?

Re: AutomateC.exe /exportqueue - how to get more than 5000 rows?