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 {
    $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+$' { 
                  [Int]$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                              
          }
              
          # Blatant misuse of the default clause for saving a bit of typing...
        }
      }
    }

    $Result += $Object
  }

  End {
    Return $Result
  }
}