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++ }