Public/Get/Get-HaloReport.ps1
#Requires -Version 7 function Get-HaloReport { <# .SYNOPSIS Gets reports from the Halo API. .DESCRIPTION Retrieves reports from the Halo API - supports a variety of filtering parameters. .OUTPUTS A powershell object containing the response. #> [CmdletBinding( DefaultParameterSetName = "Multi" )] Param( # Report ID [Parameter( ParameterSetName = "Single", Mandatory = $True )] [int64]$ReportID, # Number of records to return [Parameter( ParameterSetName = "Multi" )] [int64]$Count, # Filters response based on the search string [Parameter( ParameterSetName = "Multi" )] [string]$Search, # Paginate results [Parameter( ParameterSetName = "Multi" )] [Alias("pageinate")] [switch]$Paginate, # Number of results per page. [Parameter( ParameterSetName = "Multi" )] [Alias("page_size")] [int32]$PageSize, # Which page to return. [Parameter( ParameterSetName = "Multi" )] [Alias("page_no")] [int32]$PageNo, # The name of the first field to order by [Parameter( ParameterSetName = "Multi" )] [string]$OrderBy, # Whether to order ascending or descending [Parameter( ParameterSetName = "Multi" )] [switch]$OrderByDesc, # The name of the second field to order by [Parameter( ParameterSetName = "Multi" )] [string]$OrderBy2, # Whether to order ascending or descending [Parameter( ParameterSetName = "Multi" )] [switch]$OrderByDesc2, # The name of the third field to order by [Parameter( ParameterSetName = "Multi" )] [string]$OrderBy3, # Whether to order ascending or descending [Parameter( ParameterSetName = "Multi" )] [switch]$OrderByDesc3, # The name of the fourth field to order by [Parameter( ParameterSetName = "Multi" )] [string]$OrderBy4, # Whether to order ascending or descending [Parameter( ParameterSetName = "Multi" )] [switch]$OrderByDesc4, # The name of the fifth field to order by [Parameter( ParameterSetName = "Multi" )] [string]$OrderBy5, # Whether to order ascending or descending [Parameter( ParameterSetName = "Multi" )] [switch]$OrderByDesc5, # Filters by the specified ticket [Parameter( ParameterSetName = "Multi" )] [Alias("ticket_id")] [int64]$TicketID, # Filters by the specified client [Parameter( ParameterSetName = "Multi" )] [Alias("client_id")] [int64]$ClientID, # Filters by the specified site [Parameter( ParameterSetName = "Multi" )] [Alias("site_id")] [int64]$SiteID, # Filters by the specified user [Parameter( ParameterSetName = "Multi" )] [Alias("user_id")] [int64]$UserID, # Filters by the specified report group [Parameter( ParameterSetName = "Multi" )] [Alias("reportgroup_id")] [int64]$ReportGroupID, # Whether to return only records for reports that include graphs [Parameter( ParameterSetName = "Multi" )] [switch]$ChartOnly, # Include extra objects in the result. [Parameter( ParameterSetName = "Single" )] [switch]$IncludeDetails, # Whether to include the report data in the response [Parameter( ParameterSetName = "Single" )] [switch]$LoadReport ) $CommandName = $MyInvocation.InvocationName $Parameters = (Get-Command -Name $CommandName).Parameters # Workaround to prevent the query string processor from adding a 'reportid=' parameter by removing it from the set parameters. if ($ReportID) { $Parameters.Remove("ReportID") | Out-Null } try { if ($ReportID) { Write-Verbose "Running in single-report mode because '-ReportID' was provided." $QSCollection = New-HaloQueryString -CommandName $CommandName -Parameters $Parameters $Resource = "api/Report/$($ReportID)" $RequestParams = @{ Method = "GET" Resource = $Resource AutoPaginateOff = $True QSCollection = $QSCollection ResourceType = "reports" } } else { Write-Verbose "Running in multi-report mode." $QSCollection = New-HaloQueryString -CommandName $CommandName -Parameters $Parameters -IsMulti $Resource = "api/Report" $RequestParams = @{ Method = "GET" Resource = $Resource AutoPaginateOff = $Paginate QSCollection = $QSCollection ResourceType = "reports" } } $ReportResults = New-HaloRequest @RequestParams Return $ReportResults } catch { Write-Error "Failed to get reports from the Halo API. You'll see more detail if using '-Verbose'" Write-Verbose "$_" } } |