Connector.Cmd

1.0

public/GetErrorItems.ps1

                                <#

.Synopsis

Function to retrieve item errors for a specified connection using custom PowerShell commands.

.Description

The Get-ErrorItems function is designed to obtain and log item errors for a specified connection in a .csv file. It utilizes custom PowerShell commands such as Start-TranscriptLog, WriteExceptionToOutputFile, WriteErrorBatchToOutputFile, InitializeOutputFile, and Call-Url. The function retrieves errors in batches, handles token expiration, and writes error details to an output file.

.Function Get-ErrorItems

This function retrieves item errors for a specified connection and logs them in an output file. It supports parameters for ConnectionId, OutputFile, BatchLimit, and Torus.

.Parameters

- ConnectionId: Mandatory parameter specifying the connection ID for which item errors are to be retrieved.

- OutputFile: Optional parameter defining the output file for storing error details. Defaults to "Get-ErrorItems" if not provided.

- BatchLimit: Optional parameter determining the batch size for error retrieval. User input is prompted if not provided or if an invalid value is given.

- Torus: Optional switch parameter indicating Torus usage.

.Notes

- Error details are written to the specified output file in CSV format.

#>

function WriteExceptionToOutputFile {

    param (

        $errorMessage,

        $fileName

    )

    $errorMessage | Add-Content -Path $fileName

}

function WriteErrorBatchToOutputFile {

    param (

        $errorsBatch,

        $fileName

    )

    Foreach ($error in $errorsBatch.errors) 

    {

        $outputLine = Get-Date($error.timeStamp) -UFormat "%m/%d/%Y %T"

        $outputLine = $outputLine +","+ $error.displayText +","+ $errorsBatch.Code +","+ $error.detailedCode +',"'+ $errorsBatch.message +'"'

        $outputLine | Add-Content -Path $fileName

    }

}

function InitializeOutputFile {

    param (

        $fileName

    )

    "Time,Path,Error Code,Detailed Error Code,Message" | Set-Content -Path $fileName

}

function Get-ErrorItems{

    param(

        # Connection Id

        [Parameter(Mandatory=$true)]

        [string]

        $ConnectionId,

        [Parameter(Mandatory=$false)]

        [string]

        $OutputFile,

        # Batch Limit

        [Parameter(Mandatory=$false)]

        [int]

        $BatchLimit,

        # Torus Check

        [Parameter(Mandatory=$false)]

        [switch]

        $Torus

    )

    $CommandType = "Get-ErrorItems"

    $OutputFile = Start-TranscriptLog -CommandType $CommandType -OutputFile $OutputFile -ConnectionId $ConnectionId 

    # converting file name to csv to write errors

    $OutputFile = "$OutputFile.csv"

    # Check if the BatchLimit is not provided or is 0

    if (-not ($BatchLimit) -or ($BatchLimit -lt 1) -or ($BatchLimit -gt 5000))

    {

        $validInput = $false

        # Prompt the user for input until a valid integer greater than 0 is provided

        while (-not $validInput)

        {

            $tempBatchLimit = Read-Host "BatchLimit(range 1-5000) (press Enter to use the default value '250')"

            # If the user just presses Enter, use the default value

            if (-not ($tempBatchLimit))

            {

                $BatchLimit = 250

                $validInput = $true

            }

            else

            {

                # Try to parse the user input as an integer

                $parsedTempBatchLimit = 0

                if ([System.Int32]::TryParse($tempBatchLimit, [ref]$parsedTempBatchLimit) -and $parsedTempBatchLimit -gt 0 -and $parsedTempBatchLimit -lt 5001)

                {

                    $BatchLimit = $parsedTempBatchLimit

                    $validInput = $true

                }

                else

                {

                    Write-Error "Invalid input. Please enter a valid integer greater than 0."

                }

            }

        }

    }

    try 

    {

        $TokenInfoObj = GetOAuthToken -TenantId $TenantId -Torus:$Torus

        $Token = $TokenInfoObj.Token

        #Initiliazing Output file

        InitializeOutputFile -FileName $OutputFile

        $ErrorUrlPath = "/v1.0/admin/datasets/$ConnectionId/errors"

        # Get the list of Error Codes

        $errorCodesResponse = Call-Url -CommandType Get-ErrorItems -Token $Token -Method "Get" -UrlPath $ErrorUrlPath -TenantId $TokenInfoObj.TenantId | ConvertFrom-Json

        Write-Host "Total Error Count is: $($errorCodesResponse.errorCount)"

        #Initializing variables

        $errorsReceivedSoFar = "0"

        $errorsMissedSoFar = "0"

        $errorsRemaining = $errorCodesResponse.errorCount

        # Get all the error items for each error code

        Foreach($errorCode in $errorCodesResponse.errorCodes)

        {

            $currentErrorCode = $errorCode.code

            $currentOffset = "0"

            $currentErrorCodeCount = $errorCode.count

            $errorsReceivedForCurrentErrorCode = "0"

            $errorsMissedForCurrentErrorCode = "0"

            Write-Host "Current Error Code: $currentErrorCode, Total Count: $currentErrorCodeCount"

            while($currentOffset -ne "-1") 

            {

                Write-Host "Current Offset: $currentOffset"

                # Refresh the token if it has expired for admin

                if(-not $TokenInfoObj.IsTorus){

                    $currentTime = Get-Date

                    $tokenExpiry = $Token.ExpiresOn.LocalDateTime

                    Write-Host "CurrentTime: $currentTime, TokenExpiresOn: $tokenExpiry"

                    # Refresh the token if it's about to expire in the next 5 seconds

                    if ($tokenExpiry -lt ($currentTime.AddSeconds(5))) 

                    {

                        Write-Host "Access token is about to expire. Refreshing..."

                        $Token = Get-MSALTokenWithRetry -IsRefresh $true

                        Write-Host "Access token Refreshed."

                    }

                }

                else{

                    # implement token expire check for torus

                }

                try 

                {

                    $UrlPathGetErrorCode = "/v1.0/admin/datasets/$ConnectionId/errors/$($currentErrorCode)?offset=$($currentOffset)&limit=$($BatchLimit)"

                    Write-Host "Call for ErrorCode - $($currentErrorCode), Offset-  $($currentOffset),  BatchLimit - $($BatchLimit)"

                    $itemErrorsBatchResponse = Call-Url -CommandType Get-ErrorCodeErrors -Token $Token -Method "Get" -UrlPath $UrlPathGetErrorCode -TenantId $TokenInfoObj.TenantId | ConvertFrom-Json

                    WriteErrorBatchToOutputFile -ErrorsBatch $itemErrorsBatchResponse -FileName $OutputFile

                    $currentOffset = $itemErrorsBatchResponse.metaData.nextOffset

                    $errorsReceivedForCurrentErrorCode = [string]([int]$errorsReceivedForCurrentErrorCode + [int]$itemErrorsBatchResponse.metadata.count)

                }

                catch 

                {

                    Write-Warning "Error while getting the batch for offset: $currentOffset. `nSkipping this batch."

                    WriteExceptionToOutputFile -ErrorMessage $_ -FileName $OutputFile

                    if([int]$currentOffset + [int]$BatchLimit -lt $currentErrorCodeCount)

                    {

                        $currentOffset = [string]([int]$currentOffset + [int]$BatchLimit)

                        $errorsMissedForCurrentErrorCode = [string]([int]$errorsMissedForCurrentErrorCode + [int]$BatchLimit)

                    }

                    else

                    {

                        $currentOffset = "-1"

                        $errorsMissedForCurrentErrorCode = [string]([int]$currentErrorCodeCount - [int]$errorsReceivedForCurrentErrorCode)

                    }

                }

                Write-Host "Current Error Code: $currentErrorCode, Errors Received For current error code: $errorsReceivedForCurrentErrorCode, Errors Missed For Current Error Code: $errorsMissedForCurrentErrorCode"

            }

            $errorsReceivedSoFar = [string]([int]$errorsReceivedSoFar + [int]$errorsReceivedForCurrentErrorCode)

            $errorsMissedSoFar = [string]([int]$errorsMissedSoFar + [int]$errorsMissedForCurrentErrorCode)

            $errorsRemaining = [string]([int]$errorCodesResponse.errorCount - ([int]$errorsReceivedSoFar + [int]$errorsMissedSoFar))

            Write-Host "Total Error Count: $($errorCodesResponse.errorCount), Errors remaining: $errorsRemaining, Errors Missed: $errorsMissedSoFar, Errors Received: $errorsReceivedSoFar"

        }

        Write-Host "------- Get Item Errors Success. Errors list Stored in file $($OutputFile) -------"

    } 

    catch 

    {

        Write-Error "Error in running GetErrorItems.ps1 Error message: `n$_`n";

        WriteExceptionToOutputFile -ErrorMessage $_ -FileName $OutputFile

    }

    Stop-TranscriptLog

}

# SIG # Begin signature block

# MIIoYgYJKoZIhvcNAQcCoIIoUzCCKE8CAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCA8+eGa3KSZuu8n

# Xl79I4o+R2lMMTig3yGye4gi06MN9KCCDXYwggX0MIID3KADAgECAhMzAAADrzBA

# DkyjTQVBAAAAAAOvMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjMxMTE2MTkwOTAwWhcNMjQxMTE0MTkwOTAwWjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDOS8s1ra6f0YGtg0OhEaQa/t3Q+q1MEHhWJhqQVuO5amYXQpy8MDPNoJYk+FWA

# hePP5LxwcSge5aen+f5Q6WNPd6EDxGzotvVpNi5ve0H97S3F7C/axDfKxyNh21MG

# 0W8Sb0vxi/vorcLHOL9i+t2D6yvvDzLlEefUCbQV/zGCBjXGlYJcUj6RAzXyeNAN

# xSpKXAGd7Fh+ocGHPPphcD9LQTOJgG7Y7aYztHqBLJiQQ4eAgZNU4ac6+8LnEGAL

# go1ydC5BJEuJQjYKbNTy959HrKSu7LO3Ws0w8jw6pYdC1IMpdTkk2puTgY2PDNzB

# tLM4evG7FYer3WX+8t1UMYNTAgMBAAGjggFzMIIBbzAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQURxxxNPIEPGSO8kqz+bgCAQWGXsEw

# RQYDVR0RBD4wPKQ6MDgxHjAcBgNVBAsTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEW

# MBQGA1UEBRMNMjMwMDEyKzUwMTgyNjAfBgNVHSMEGDAWgBRIbmTlUAXTgqoXNzci

# tW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8vd3d3Lm1pY3Jvc29mdC5j

# b20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3JsMGEG

# CCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDovL3d3dy5taWNyb3NvZnQu

# Y29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3J0

# MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIBAISxFt/zR2frTFPB45Yd

# mhZpB2nNJoOoi+qlgcTlnO4QwlYN1w/vYwbDy/oFJolD5r6FMJd0RGcgEM8q9TgQ

# 2OC7gQEmhweVJ7yuKJlQBH7P7Pg5RiqgV3cSonJ+OM4kFHbP3gPLiyzssSQdRuPY

# 1mIWoGg9i7Y4ZC8ST7WhpSyc0pns2XsUe1XsIjaUcGu7zd7gg97eCUiLRdVklPmp

# XobH9CEAWakRUGNICYN2AgjhRTC4j3KJfqMkU04R6Toyh4/Toswm1uoDcGr5laYn

# TfcX3u5WnJqJLhuPe8Uj9kGAOcyo0O1mNwDa+LhFEzB6CB32+wfJMumfr6degvLT

# e8x55urQLeTjimBQgS49BSUkhFN7ois3cZyNpnrMca5AZaC7pLI72vuqSsSlLalG

# OcZmPHZGYJqZ0BacN274OZ80Q8B11iNokns9Od348bMb5Z4fihxaBWebl8kWEi2O

# PvQImOAeq3nt7UWJBzJYLAGEpfasaA3ZQgIcEXdD+uwo6ymMzDY6UamFOfYqYWXk

# ntxDGu7ngD2ugKUuccYKJJRiiz+LAUcj90BVcSHRLQop9N8zoALr/1sJuwPrVAtx

# HNEgSW+AKBqIxYWM4Ev32l6agSUAezLMbq5f3d8x9qzT031jMDT+sUAoCw0M5wVt

# CUQcqINPuYjbS1WgJyZIiEkBMIIHejCCBWKgAwIBAgIKYQ6Q0gAAAAAAAzANBgkq

# hkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5

# IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEwOTA5WjB+MQswCQYDVQQG

# EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG

# A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYDVQQDEx9NaWNyb3NvZnQg

# Q29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIIC

# CgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+laUKq4BjgaBEm6f8MMHt03

# a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc6Whe0t+bU7IKLMOv2akr

# rnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4Ddato88tt8zpcoRb0Rrrg

# OGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+lD3v++MrWhAfTVYoonpy

# 4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nkkDstrjNYxbc+/jLTswM9

# sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6A4aN91/w0FK/jJSHvMAh

# dCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmdX4jiJV3TIUs+UsS1Vz8k

# A/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL5zmhD+kjSbwYuER8ReTB

# w3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zdsGbiwZeBe+3W7UvnSSmn

# Eyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3T8HhhUSJxAlMxdSlQy90

# lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS4NaIjAsCAwEAAaOCAe0w

# ggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRIbmTlUAXTgqoXNzcitW2o

# ynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNVHQ8EBAMCAYYwDwYD

# VR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBDuRQFTuHqp8cx0SOJNDBa

# BgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2Ny

# bC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3JsMF4GCCsG

# AQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3dy5taWNyb3NvZnQuY29t

# L3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3J0MIGfBgNV

# HSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEFBQcCARYzaHR0cDovL3d3

# dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1hcnljcHMuaHRtMEAGCCsG

# AQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkAYwB5AF8AcwB0AGEAdABl

# AG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn8oalmOBUeRou09h0ZyKb

# C5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7v0epo/Np22O/IjWll11l

# hJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0bpdS1HXeUOeLpZMlEPXh6

# I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/KmtYSWMfCWluWpiW5IP0

# wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvyCInWH8MyGOLwxS3OW560

# STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBpmLJZiWhub6e3dMNABQam

# ASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJihsMdYzaXht/a8/jyFqGa

# J+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYbBL7fQccOKO7eZS/sl/ah

# XJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbSoqKfenoi+kiVH6v7RyOA

# 9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sLgOppO6/8MO0ETI7f33Vt

# Y5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtXcVZOSEXAQsmbdlsKgEhr

# /Xmfwb1tbWrJUnMTDXpQzTGCGkIwgho+AgEBMIGVMH4xCzAJBgNVBAYTAlVTMRMw

# EQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVN

# aWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNp

# Z25pbmcgUENBIDIwMTECEzMAAAOvMEAOTKNNBUEAAAAAA68wDQYJYIZIAWUDBAIB

# BQCggeYwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEO

# MAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIFKMLbopkqA3UStTXEo0A9Da

# hYvm5JVLNhpVasdi0jR5MHoGCisGAQQBgjcCAQwxbDBqoEyASgBNAGkAYwByAG8A

# cwBvAGYAdAAuAEcAcgBhAHAAaAAuAEMAbwBuAG4AZQBjAHQAbwByAHMALgBDAG0A

# ZABsAGUAdAAuAGQAbABsoRqAGGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbTANBgkq

# hkiG9w0BAQEFAASCAQBbtwMyVtcBVgEH9LAlHm/LfEMkA6qw6eiPnV5UOVST+A8K

# LclVSCLKsPKSbtE5jCfI7XdNGwv0RYgF9RmjEiwyz7CAQZ3497uHSGzksRYyTegH

# g4d77au5VRQmy5M+ywTit/y0y2cszlSFhFKmvQXSLRm8ObIhkIvDu4+HOX6S0bgs

# nk/tLNtPWeLmko+kDrlIJqkSCXVuD8EQG+pIgZ3MRIrk2c1Jb2kl3/mEUr5czTEx

# b/jsAXavOZo4tiTR4ht7jOvK2PdGOHemYdWWN8N9RGN+u8rLrzLzgKbS1IpqMOcQ

# eJT0bD8s2y+3TrqJv3li3t1VTxLDPkUxjXqXUYSxoYIXlDCCF5AGCisGAQQBgjcD

# AwExgheAMIIXfAYJKoZIhvcNAQcCoIIXbTCCF2kCAQMxDzANBglghkgBZQMEAgEF

# ADCCAVIGCyqGSIb3DQEJEAEEoIIBQQSCAT0wggE5AgEBBgorBgEEAYRZCgMBMDEw

# DQYJYIZIAWUDBAIBBQAEIHHG3I+pt+k0nlSe3VZYyYmHOtn7vgSKJWXUA0wL6NrX

# AgZl8yTZubYYEzIwMjQwNDAyMDc0NDIwLjA0OFowBIACAfSggdGkgc4wgcsxCzAJ

# BgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25k

# MR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJTAjBgNVBAsTHE1pY3Jv

# c29mdCBBbWVyaWNhIE9wZXJhdGlvbnMxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVT

# TjpGMDAyLTA1RTAtRDk0NzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAg

# U2VydmljZaCCEeowggcgMIIFCKADAgECAhMzAAAB8j4y12SscJGUAAEAAAHyMA0G

# CSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u

# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp

# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMB4XDTIz

# MTIwNjE4NDU1OFoXDTI1MDMwNTE4NDU1OFowgcsxCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xJTAjBgNVBAsTHE1pY3Jvc29mdCBBbWVyaWNhIE9w

# ZXJhdGlvbnMxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVTTjpGMDAyLTA1RTAtRDk0

# NzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZTCCAiIwDQYJ

# KoZIhvcNAQEBBQADggIPADCCAgoCggIBALzl88sXCmliDHBjGRIR5i9AG2dglO0o

# qPYUrHMfHR+BXpeAgiuYJaakqX0g7O858n+TqI/RGehGjkXz0B3b153MZ2VZsKPV

# DLHkdQc1jzK70SUk6Z2B6429MrhFbjC72IHn/PZJ4K5irJf+/zPo+m/b2HW201ax

# Jz8o8566HNIBeqQDbrkFIVPmTKTG/MHQvGjFLqhahdYrrDHXvY1ElFhwg19cOFRG

# 9R8PvSOKgT3atb86CNw4rFmR9DEuXBoVKtKcazteEyun1OxSCbCzJxMQ4F0ZWZ/U

# cIPtY5rPkQRxDIhLYGlFhjCw8xsHre4eInXnyo2HVIle6gvnAYO79tlTM34HNwuP

# 3qLELvAkZAwGLFYf1375XxuXXRFh1cNmWWNEC9LqIXA3OtqG7gOthvtvwzu+/CEQ

# vTEI69vtYUyyy2xxd+R0TmD41JpymGAV9yh+1Dmo8PY81WasbfwOYcOhiGCP26o8

# s/u+ehd/uPr4tbxWifXnwPRauaTsK6a5xBOIdHJ6kRpUOecDYaSImh6H+vd9KEvo

# IeA+hMHuhhT93ok6dxGKgNiqpF9XbCWkpU7xv5VgcvyGfXUlEXHqnr2YvwFG1Jnp

# 0b8YURUT59WaDFh8gJSumCHJCURMk8hMQFLXkixpS5bQa9eUtKh8Z/a3kMCgOS4o

# JsL7dV0+aVhVAgMBAAGjggFJMIIBRTAdBgNVHQ4EFgQUlVuHACbq0DEEzlwfwGDT

# 5jrihnkwHwYDVR0jBBgwFoAUn6cVXQBeYl2D9OXSZacbUzUZ6XIwXwYDVR0fBFgw

# VjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jcmwvTWlj

# cm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIwMTAoMSkuY3JsMGwGCCsGAQUF

# BwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3Br

# aW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENBJTIwMjAxMCgx

# KS5jcnQwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcDCDAOBgNV

# HQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQADggIBAD1Lp47gex8HTRek6A9ptw3d

# Bl7KKmCKVxBINnyDpUK/0VUfN1Kr1ekCyWNlIo1ZIKWEkTPk6jdSb+1o+ehsX7wK

# QB2RwtCEt2RKF+v3WTPL28M+s6aUIDYVD2NWEVpq3ZAzffPWn4YI/m26+KsVpRbN

# RZUMU6mj87nMOnOg9i1OvRwWDe5dpEtPnhRDdji49heqfrC6dm1RBEyIkzPGlSW9

# 19YZS0K+dbd4MGKQOSLHVcT3xVxgjPb7l91y+sdV5RqsZfLgtG3DObCmwK1SHu1H

# rCEKtViRvoW50F1YztNW+OLukaB+N6yCcBJoP8KEu7Hro8bBohoX7EvOTRs3GwCP

# S6F3pB1avpNPf2b9I1nX9RdTuTMSh3S8BjeYifxfkDgj7397WcE2lREnpiIMpB3l

# hWDGy5kJa/hDBvSZeEch70K5t9KpmO8NrB/Yjbb03cuy0MlRKvW8YUHyJDlbxksz

# k/BPy+2woQHAcRibCy5aazGSKYgXkFBtLOD3DPU7qN1ZPEYbQ5S3VxdY4wlQnPIQ

# fhZIpkc7HnepwC8P2HRTqMQXZ+4GO0n9AOtZtvi6u8B+u+o2f2UfuBU+mWo08Mi9

# DwORneW9tCxiqXPrXt7vqBrtJjTDvX5A/XrkI93NRjfp63ZKbim+ykQryGWWrchh

# zJfS/z3v5f1h55wzU9vWMIIHcTCCBVmgAwIBAgITMwAAABXF52ueAptJmQAAAAAA

# FTANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hp

# bmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jw

# b3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0

# aG9yaXR5IDIwMTAwHhcNMjEwOTMwMTgyMjI1WhcNMzAwOTMwMTgzMjI1WjB8MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNy

# b3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCAiIwDQYJKoZIhvcNAQEBBQADggIP

# ADCCAgoCggIBAOThpkzntHIhC3miy9ckeb0O1YLT/e6cBwfSqWxOdcjKNVf2AX9s

# SuDivbk+F2Az/1xPx2b3lVNxWuJ+Slr+uDZnhUYjDLWNE893MsAQGOhgfWpSg0S3

# po5GawcU88V29YZQ3MFEyHFcUTE3oAo4bo3t1w/YJlN8OWECesSq/XJprx2rrPY2

# vjUmZNqYO7oaezOtgFt+jBAcnVL+tuhiJdxqD89d9P6OU8/W7IVWTe/dvI2k45GP

# sjksUZzpcGkNyjYtcI4xyDUoveO0hyTD4MmPfrVUj9z6BVWYbWg7mka97aSueik3

# rMvrg0XnRm7KMtXAhjBcTyziYrLNueKNiOSWrAFKu75xqRdbZ2De+JKRHh09/SDP

# c31BmkZ1zcRfNN0Sidb9pSB9fvzZnkXftnIv231fgLrbqn427DZM9ituqBJR6L8F

# A6PRc6ZNN3SUHDSCD/AQ8rdHGO2n6Jl8P0zbr17C89XYcz1DTsEzOUyOArxCaC4Q

# 6oRRRuLRvWoYWmEBc8pnol7XKHYC4jMYctenIPDC+hIK12NvDMk2ZItboKaDIV1f

# MHSRlJTYuVD5C4lh8zYGNRiER9vcG9H9stQcxWv2XFJRXRLbJbqvUAV6bMURHXLv

# jflSxIUXk8A8FdsaN8cIFRg/eKtFtvUeh17aj54WcmnGrnu3tz5q4i6tAgMBAAGj

# ggHdMIIB2TASBgkrBgEEAYI3FQEEBQIDAQABMCMGCSsGAQQBgjcVAgQWBBQqp1L+

# ZMSavoKRPEY1Kc8Q/y8E7jAdBgNVHQ4EFgQUn6cVXQBeYl2D9OXSZacbUzUZ6XIw

# XAYDVR0gBFUwUzBRBgwrBgEEAYI3TIN9AQEwQTA/BggrBgEFBQcCARYzaHR0cDov

# L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9Eb2NzL1JlcG9zaXRvcnkuaHRtMBMG

# A1UdJQQMMAoGCCsGAQUFBwMIMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsG

# A1UdDwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFNX2VsuP6KJc

# YmjRPZSQW9fOmhjEMFYGA1UdHwRPME0wS6BJoEeGRWh0dHA6Ly9jcmwubWljcm9z

# b2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIz

# LmNybDBaBggrBgEFBQcBAQROMEwwSgYIKwYBBQUHMAKGPmh0dHA6Ly93d3cubWlj

# cm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3J0

# MA0GCSqGSIb3DQEBCwUAA4ICAQCdVX38Kq3hLB9nATEkW+Geckv8qW/qXBS2Pk5H

# ZHixBpOXPTEztTnXwnE2P9pkbHzQdTltuw8x5MKP+2zRoZQYIu7pZmc6U03dmLq2

# HnjYNi6cqYJWAAOwBb6J6Gngugnue99qb74py27YP0h1AdkY3m2CDPVtI1TkeFN1

# JFe53Z/zjj3G82jfZfakVqr3lbYoVSfQJL1AoL8ZthISEV09J+BAljis9/kpicO8

# F7BUhUKz/AyeixmJ5/ALaoHCgRlCGVJ1ijbCHcNhcy4sa3tuPywJeBTpkbKpW99J

# o3QMvOyRgNI95ko+ZjtPu4b6MhrZlvSP9pEB9s7GdP32THJvEKt1MMU0sHrYUP4K

# WN1APMdUbZ1jdEgssU5HLcEUBHG/ZPkkvnNtyo4JvbMBV0lUZNlz138eW0QBjloZ

# kWsNn6Qo3GcZKCS6OEuabvshVGtqRRFHqfG3rsjoiV5PndLQTHa1V1QJsWkBRH58

# oWFsc/4Ku+xBZj1p/cvBQUl+fpO+y/g75LcVv7TOPqUxUYS8vwLBgqJ7Fx0ViY1w

# /ue10CgaiQuPNtq6TPmb/wrpNPgkNWcr4A245oyZ1uEi6vAnQj0llOZ0dFtq0Z4+

# 7X6gMTN9vMvpe784cETRkPHIqzqKOghif9lwY1NNje6CbaUFEMFxBmoQtB1VM1iz

# oXBm8qGCA00wggI1AgEBMIH5oYHRpIHOMIHLMQswCQYDVQQGEwJVUzETMBEGA1UE

# CBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9z

# b2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxNaWNyb3NvZnQgQW1lcmljYSBPcGVy

# YXRpb25zMScwJQYDVQQLEx5uU2hpZWxkIFRTUyBFU046RjAwMi0wNUUwLUQ5NDcx

# JTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIFNlcnZpY2WiIwoBATAHBgUr

# DgMCGgMVAGuL3jdwUsfZN9AR8HTlIsgKDvgIoIGDMIGApH4wfDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp

# bWUtU3RhbXAgUENBIDIwMTAwDQYJKoZIhvcNAQELBQACBQDptgXfMCIYDzIwMjQw

# NDAyMDQxOTQzWhgPMjAyNDA0MDMwNDE5NDNaMHQwOgYKKwYBBAGEWQoEATEsMCow

# CgIFAOm2Bd8CAQAwBwIBAAICC/YwBwIBAAICE10wCgIFAOm3V18CAQAwNgYKKwYB

# BAGEWQoEAjEoMCYwDAYKKwYBBAGEWQoDAqAKMAgCAQACAwehIKEKMAgCAQACAwGG

# oDANBgkqhkiG9w0BAQsFAAOCAQEAyr503Vz224iz5Y+1N8CWbb1+AeU7SRAi5ubV

# JGKv+4wOXDsrg8nLYVUVadCQuH9NeSS37X9NLIGMMy2pts2Wa+LvK2vsIV+34zPM

# N4klRuDRxFzsskjFAN4ABY57qf1aRhndcc/Mgh2bvoIlqZE/Z8HbG00Nvo3h8hjR

# wuDqiQeTX9DOFVvRM70gdokFnQsf/xpIs2mD+DCVTTiq/GPGcxisZd0dmpuGNu/f

# wvaH2zlN4fehABb21OqgpO8w89NG+6EwCS0+97GBu6dujkoeBJjUDZM/VYT3RHE2

# pAy0qu447DX65A4IE6VwFIMSUfPNxMZSRFz0W9Y6u5mTGgizgjGCBA0wggQJAgEB

# MIGTMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQH

# EwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNV

# BAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB8j4y12SscJGU

# AAEAAAHyMA0GCWCGSAFlAwQCAQUAoIIBSjAaBgkqhkiG9w0BCQMxDQYLKoZIhvcN

# AQkQAQQwLwYJKoZIhvcNAQkEMSIEIOiftqEzKt9eavcNc1i033edyw2y0Sv7lJOc

# dum2x5Q2MIH6BgsqhkiG9w0BCRACLzGB6jCB5zCB5DCBvQQg+No+HS4xUlzTj5jh

# G7kFRRscTiy5nqdEdJS7RddKQ0QwgZgwgYCkfjB8MQswCQYDVQQGEwJVUzETMBEG

# A1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWlj

# cm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFt

# cCBQQ0EgMjAxMAITMwAAAfI+MtdkrHCRlAABAAAB8jAiBCBosXOLym/gHIJNt3hf

# hs675Dh5uU9At6AnkdhIYAeyTDANBgkqhkiG9w0BAQsFAASCAgBEx9L2vUPdNf1v

# D5NCQLbhFRm6ub5kYVYG7RRWjBBV2TK1DJi82xMn/RcUzhx3IRHRrsfDKKGE1W6Z

# h/xaEMCt4f8TAVij62H2dYHduQpI5wyxwUoYKzqmCIe/dZ/dfcbswdzXqRmdPkEZ

# 1UZRPrt8r0y/NQLeQTXOa0ze+gi0gRNH100xSGCIuWMEzHIrKWsKzpxXVUVdVW8O

# ud5Un3yZ11Nb5z12fUSZ3Qzj1nEjp7aOTOaUkSFJAAqJ/13mPp8g5hOvlYnzJqWU

# qq0p5sieAfmVp+karVpsIc4vf8zpyTCotbU/9geI8qGCRrcrocK4803C2UgHk/1B

# HJPBcnOqpsjGDgGnsqxhnZdBjVL9vuZhBbOQ+xJcbpMEYbEmXZ2J+zT1XLiL6sdT

# t5mTOHLVP8txOFyFEhmZ5dBH2ibzvMNKLIa+yFHagOfgHENGdNa6zs0jILKnHLtj

# kBvc1H6z097WhhmK+tBOS721Bz1hKXwmZKpKuHpi87/xBbVOcsZIp+CJsxQddLvS

# DzP950n8UbPtPW2VcKSteURe8TfoPVL4n7JuV5vR3rrfL0iE9xOc1+Xt+crnNFsw

# 44HU6sQh0A4SOcdwYeiMW9dXto9IWZPzyctdorkIW9CAuvOoHl4xUe4ZNRdTgxG2

# 2HDIAvJN5PO8aTKT3Ef2WEKRE7iNSA==

# SIG # End signature block