PSFunctions/Get-DataverseTableRowCount.ps1
|
function Get-DataverseTableRowCount { [CmdletBinding()] param ( [Parameter(Mandatory=$true)] [String]$TableName, [Parameter(Mandatory=$false)] [string]$Filter = "" ) Write-Progress -Activity "Counting rows" $meta = Send-DataverseOperation '{"Uri":"EntityDefinitions(LogicalName=''be_filing'')?$select=LogicalCollectionName,PrimaryIdAttribute"}' | Select-Object -ExpandProperty Content | ConvertFrom-Json $uri = $meta | Select-Object -ExpandProperty LogicalCollectionName $primaryAttr = $meta | Select-Object -ExpandProperty PrimaryIdAttribute $uri += "?`$count=true&`$select=$($primaryAttr)""" if ($Filter -ne "") { $uri += "&`$filter=$($Filter)" } $resp = Send-DataverseOperation "{""Uri"":""$uri""}" | Select-Object -ExpandProperty Content | ConvertFrom-Json $next = $resp | Select-Object -ExpandProperty "@odata.nextLink" $count = $resp | Select-Object -ExpandProperty "@odata.count" while ($next -ne "") { Write-Progress -Activity "Counting rows" -Status "Rows counted: $count" $resp = Send-DataverseOperation "{""Uri"":""$next""}" | Select-Object -ExpandProperty Content | ConvertFrom-Json if (Get-Member "@odata.nextLink" -InputObject $resp) { $next = $resp | Select-Object -ExpandProperty "@odata.nextLink" $count += $resp | Select-Object -ExpandProperty "@odata.count" } else { $next = "" $count += ($resp | Select-Object -ExpandProperty value).Count } } Write-Progress -Activity "Counting rows" -Completed return $count } |