PublicFunctions/Get-DataVerseRows.ps1
|
function Get-DataVerseRows { [cmdletbinding()] param ( [Parameter(Mandatory)][String]$EntitySetName , [Parameter()][string[]]$Columns , [Parameter()][string]$Where , [Parameter()][int]$Limit = 0 , [Parameter()][ValidateSet("Custom","Updateable","All")][string]$Options = "Custom" , [Parameter()][switch]$IncludeAnnotations ) $ep = $EntitySetName if(-not $Columns) { switch($Options) { "Custom" { $Columns = [SDVApp]::Schema.ColumnsCustom($EntitySetName) | Select-Object -ExpandProperty LogicalName } "Updateable" { $Columns = [SDVApp]::Schema.ColumnsCanUpdate($EntitySetName) | Select-Object -ExpandProperty LogicalName } "All" { $Columns = [SDVApp]::Schema.Columns($EntitySetName) | Select-Object -ExpandProperty LogicalName } } } $ep = QueryAppend $ep ('$select=' + ($Columns -join ",")) if($Limit -gt 0) {$ep = QueryAppend $ep "`$top=$limit" } if($Where) { $ep = QueryAppend $ep "`$filter=$Where" } $addHdrs = @{'If-None-Match'= ""} if($IncludeAnnotations) { $addHdrs['Prefer'] ='odata.include-annotations="*"' } $request = @{ Method = "GET" EndPoint = $ep AddHeaders = $addHdrs } Invoke-DataVerse @request | Select-Object -ExpandProperty value | ForEach-Object { $ht = [ordered]@{ PSTypeName = "SimplyDataVerse.$EntitySetName" } foreach($c in $columns) { $ht[$c] = $_.$c } [PSCustomObject]$ht } } |