Paging with Get-RbData
With large datasets it may necessary to pull the data in “pages”. The Command Builder does not provide a template for paging. Below is an example of using Get-RbData with paging to pull data incrementally from the source.
$pagesize = 500
$pagenum = 1
$maxerr = 10
$errcount = 0
While ($errcount -lt $maxerr) {
$datapage = $null
try{
$datapage = Get-RbData -TaskName './../../some data grid' -DataSetName 'Some View' -PageSize $pagesize -PageNum $pagenum
$errcount = 0
} catch{
#some error, loop again
$errcount++
Continue
}
if(!$datapage){break} #no more data to fetch
$null= ..... do something with the page of data; eg. add it to a datatable .....
$pagenum++
}