Private/ConvertFrom-XML.ps1
|
<#
.COPYRIGHT Copyright (c) Office Center Hønefoss AS. All rights reserved. Licensed under the MIT license. See https://github.com/officecenter/Autotask/blob/master/LICENSE.md for license information. #> Function ConvertFrom-XML { <# .SYNOPSIS This function converts an array of XML elements to a custom psobject for easier parsing and coding. .DESCRIPTION The function an array of XML elements and recursively converts each element to a custom PowerShell object. Each XML property is converted to an object property with a value of datetime, double, integer or string. .INPUTS [System.XML.Xmlelement []] .OUTPUTS [System.Object[]] .EXAMPLE $element | ConvertFrom-XML Converts variable $element with must contain 1 or more Xml.Xmlelements to custom PSobjects with the same content. .NOTES NAME: ConvertFrom-XML #> [cmdletbinding()] Param ( [Parameter( Mandatory = $true, ValueFromPipeLine = $true, ParameterSetName = 'Input_Object' )] [Xml.Xmlelement[]] $InputObject ) begin { # Enable modern -Debug behavior if ($PSCmdlet.MyInvocation.BoundParameters['Debug'].IsPresent) { $DebugPreference = 'Continue' } Write-Debug ('{0}: Begin of function' -F $MyInvocation.MyCommand.Name) $result = @() # Set up TimeZone offset handling if (-not($script:ESTzone)) { $script:ESTzone = [System.TimeZoneInfo]::FindSystemTimeZoneById("Eastern Standard Time") } if (-not($script:ESToffset)) { $now = Get-Date $ESTtime = [System.TimeZoneInfo]::ConvertTimeFromUtc($now.ToUniversalTime(), $ESTzone) $script:ESToffset = (New-TimeSpan -Start $now -End $ESTtime).TotalHours } } process { foreach ($element in $InputObject) { # Get properties $properties = $element | Get-Member -MemberType property # Create a new, empty object $object = New-Object -TypeName PSObject # Loop through all properties and add a member for each foreach ($property in $properties) { # We are accessing property values by dynamic naming. It is a lot easier # to reference dynamic property names with a string variable $propertyName = $property.Name # Extract/create a value based on the property definition string switch -Wildcard ($property.Definition) { # Most properties are returned as strings. We will use a few tests to # try to recognise other value types 'string*' { # Test if it is a date first if ($element.$propertyName -match '^([12]\d{3}-(0[1-9]|1[0-2])-(0[1-9]|[12]\d|3[01]))') { # Convert to a Datetime object [DateTime]$dateTime = $element.$propertyName # Add timezone difference $value = $dateTime.AddHours($script:ESToffset) } else { # This isn't a date. We'll use a regex to avoid turning integers into doubles switch -regex ($element.$propertyName) { '^\d+\.\d{4}$' { [Double]$double = $element.$propertyName $value = $double } '^\d+$' { [Int64]$Integer = $element.$propertyName $value = $Integer } Default { $value = $element.$propertyName } } } Add-Member -InputObject $object -MemberType Noteproperty -Name $propertyName -Value $value } # For properties that are XML elements; recurse 'System.Xml.Xmlelement*' { # A bit of recursive magic here... $value = $element.$propertyName | ConvertFrom-XML Add-Member -InputObject $object -MemberType Noteproperty -Name $propertyName -Value $value } # Arrays. Loop through elements and perform recursive magic 'System.Object*' { $value = @() foreach ($Item in $element.$propertyName) { $value += $Item | ConvertFrom-XML } Add-Member -InputObject $object -MemberType Noteproperty -Name $propertyName -Value $value } } } } $result += $object } end { Return $result } } |