Private/JsonParsing.ps1
|
# ALl JSON parsing functions should live here. function Get-ParsedAccountJson { <# .SYNOPSIS Describe the function here .DESCRIPTION Describe the function in more detail .EXAMPLE Give an example of how to use it .EXAMPLE Give another example of how to use it .PARAMETER computername The computer name to query. Just one. .PARAMETER logname The name of a file to write failed computer names to. Defaults to errors.txt. #> [CmdletBinding()] param( [Parameter(Mandatory=$true,ValueFromPipeline)] [Object[]]$Account ) begin {} process { $Account.ForEach{ [PSCustomObject]@{ Account = $_.name Type = $_.type OnBudget = $_.on_budget Closed = $_.closed Note = $_.note Balance = ([double]$_.balance / 1000) ClearedBalance = ([double]$_.cleared_balance / 1000) UnclearedBalance = ([double]$_.uncleared_balance / 1000) AccountID = $_.id } } | Sort-Object Account } } function Get-ParsedPayeeJson { <# .SYNOPSIS Describe the function here .DESCRIPTION Describe the function in more detail .EXAMPLE Give an example of how to use it .EXAMPLE Give another example of how to use it .PARAMETER computername The computer name to query. Just one. .PARAMETER logname The name of a file to write failed computer names to. Defaults to errors.txt. #> [CmdletBinding()] param( [Parameter(Mandatory=$true,ValueFromPipeline)] [Object[]]$Payee, [Parameter(ValueFromPipeline)] [Object[]]$PayeeLocation ) begin {} process { $Payee.ForEach{ $payeeId = $_.id # Build an object of longitude/latidude data for the current payee $location = $PayeeLocation.Where{$_.payee_id -eq $payeeId}.ForEach{ [PSCustomObject]@{ Latitude = $_.latitude Longitude = $_.longitude Maps = "https://maps.google.com/maps?q=$($_.latitude),$($_.longitude)" } } # Return the formatted payee data [PSCustomObject]@{ Payee = $_.name Location = $location TransferAccountID = $_.transfer_account_id PayeeID = $payeeId } } | Sort-Object Payee } } function Get-ParsedTransactionJson { <# .SYNOPSIS Describe the function here .DESCRIPTION Describe the function in more detail .EXAMPLE Give an example of how to use it .EXAMPLE Give another example of how to use it .PARAMETER computername The computer name to query. Just one. .PARAMETER logname The name of a file to write failed computer names to. Defaults to errors.txt. #> [CmdletBinding(DefaultParameterSetName='TransactionResponse')] param( [Parameter(Position=0,Mandatory=$true,ValueFromPipeline,ParameterSetName='TransactionResponse')] [Parameter(Position=0,Mandatory=$true,ParameterSetName='Detail')] [Object[]]$Transaction, [Parameter(Position=1,ParameterSetName='Detail')] [Object[]]$Subtransaction, [Parameter(Position=2,ParameterSetName='Detail')] [Object[]]$Payee, [Parameter(Position=3,ParameterSetName='Detail')] [Object[]]$PayeeLocation, [Parameter(Position=4,ParameterSetName='Detail')] [Object[]]$ParsedPayee ) begin { Write-Verbose "ParameterSetName: $($PsCmdlet.ParameterSetName)" } process { switch ($PSCmdlet.ParameterSetName) { 'Detail' { # If no ParsedPayee data is provided, generate it if (!$ParsedPayee -and $Payee) { $ParsedPayee = Get-ParsedPayeeJson $Payee $PayeeLocation } $Transaction.ForEach{ $transId = $_.id $payeeId = $_.payee_id $payee = $ParsedPayee.Where{$_.PayeeId -eq $payeeId} # Build an object of longitude/latidude data for the current payee $subtrans = $Subtransaction.Where{$_.transaction_id -eq $transId}.ForEach{ $payeeId = $_.payee_id $subPayee = $ParsedPayee.Where{$_.PayeeId -eq $payeeId} [PSCustomObject]@{ Amount = ([double]$_.amount / 1000) Memo = $_.memo Payee = $subPayee.Name #Category PayeeID = $subPayee.PayeeId #CategoryID } } # Return the formatted transaction data [PSCustomObject]@{ Date = [datetime]::ParseExact($_.date,'yyyy-MM-dd',$null) Amount = ([double]$_.amount / 1000) Memo = $_.memo Cleared = $_.cleared Approved = $_.approved #account Payee = $payee.Name #Category Subtransactions = $subtrans PayeeID = $payee.PayeeId #CategoryID } } } 'TransactionResponse' { $Transaction.ForEach{ # Build an object of longitude/latidude data for the current payee $subtrans = $_.subtransaction.ForEach{ [PSCustomObject]@{ Amount = ([double]$_.amount / 1000) Memo = $_.memo Payee = $_.payee_name Category = $_.category_name Account = $_.account_name PayeeID = $_.payee_id CategoryID = $_.category_id AccountID = $_.account_id } } # Return the formatted transaction data [PSCustomObject]@{ Date = [datetime]::ParseExact($_.date,'yyyy-MM-dd',$null) Amount = ([double]$_.amount / 1000) Memo = $_.memo Cleared = $_.cleared Approved = $_.approved FlagColor = (Get-Culture).TextInfo.ToTitleCase($_.flag_color) Payee = $_.payee_name Category = $_.category_name Account = $_.account_name Subtransactions = $subtrans PayeeID = $_.payee_id CategoryID = $_.category_id AccountID = $_.account_id } } } } } } function Get-ParsedCategoryJson { <# .SYNOPSIS Describe the function here .DESCRIPTION Describe the function in more detail .EXAMPLE Give an example of how to use it .EXAMPLE Give another example of how to use it .PARAMETER computername The computer name to query. Just one. .PARAMETER logname The name of a file to write failed computer names to. Defaults to errors.txt. #> [CmdletBinding()] param( [Parameter(Mandatory=$true,ValueFromPipeline)] [Object[]]$Category, [Switch]$List, [Switch]$IncludeHidden ) begin {} process { if ($List) { $Category.Where{ # Get rid of hidden category groups unless $IncludeHidden is $true if (!$IncludeHidden) { $_.hidden -ne $true -and $_.name -ne 'Internal Master Category' } else { $_.name -ne 'Internal Master Category' } }.ForEach{ # Build an object of subcategories for each group $categories = $_.categories.Where{ # Get rid of hidden categories unless $IncludeHidden is $true if (!$IncludeHidden) { $_.hidden -ne $true } else {$true} }.ForEach{ [PSCustomObject]@{ Category = $_.name Note = $_.note Budgeted = ([double]$_.budgeted / 1000) Activity = ([double]$_.activity / 1000) Balance = ([double]$_.balance / 1000) Hidden = $_.hidden CategoryID = $_.id } } | Sort-Object Category # Don't return the category group if there aren't any categories if ($categories) { [PSCustomObject]@{ CategoryGroup = $_.name Hidden = $_.hidden Categories = $categories CategoryGroupID = $_.id } } } | Sort-Object CategoryGroup } else { $Category.ForEach{ # Return the formatted data [PSCustomObject]@{ Category = $_.name Note = $_.note Budgeted = ([double]$_.budgeted / 1000) Activity = ([double]$_.activity / 1000) Balance = ([double]$_.balance / 1000) Hidden = $_.hidden CategoryID = $_.id } } | Sort-Object Category } } } |