resources/table.ps1
|
function New-QlikTable() { [CmdletBinding()] param ( [parameter(Mandatory = $true)] [string] $Type, [parameter(Mandatory = $true)] [PSObject[]] $Columns, [string] $Filter, [int] $Skip, [int] $Take, [string] $SortColumn, [bool] $OrderAscending ) process { $json = @{ type = $Type columns = $Columns } | ConvertTo-Json -Compress -Depth 10 $path = "/qrs/$Type/table" $query = @( if ($Filter) { "filter=$Filter" } if ($Skip) { "skip=$Skip" } if ($Take) { "take=$Take" } if ($SortColumn) { "sortColumn=$SortColumn" } if ($psBoundParameters.ContainsKey("OrderAscending")) { "orderAscending=$OrderAscending" } ) -join '&' if ($query) { $path = $path, $query -join '?' } Return Invoke-QlikPost $path $json } } |