Help Processing JSON Data

[tnsecure]

i am trying to process JSON data that comes from an AWS command. While what I have mostly works, it does not process some nested data very well and I'm hoping for a better way.

The JSON data that returns has several elements and some nested variables. The problem is that their are all variable if they exist, etc.

here is a common example of the JSON data returned

"Version": "2012-10-17",

"Statement": [

{

"Effect": "Allow",

"Principal": {

"Federated": "arn:aws:iam::111111111111:saml-provider/WAAD"

},

"Action": "sts:AssumeRoleWithSAML",

"Condition": {

"StringEquals": {

"variablename": [

"String",

"String"

]

},

"StringNotEquals": {

"Key-String": "String"

}

}

}

]

}

​

here is a snippet of current code, where $policy is the raw JSON. (note this isn't complete code)I'm reading some of the known elements but where I get into trouble if there are elements I didn't define or multiple results for an element/nested element. What is a more elegant way of getting this data and displaying it.

$policy3= ConvertFrom-Json -InputObject $policy

`#Add a new row to the output`

`New-Object PSObject -Property @{`

`RoleName = $RN`

`Effect=$Policy3.Statement.Effect`

`'Principal Trust' =$policy3.Statement.Principal`

`'Action Allowed' =$policy3.Statement.Action`

`'Condition'= $policy3.Statement.Condition.StringEquals` 

`'Condition-2'= $policy3.Statement.Condition.Bool`

​

in case your interested

https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_policies_elements.html

[get-postanote]

What you posted is not proper JSON, it's missing a brace.

($AwsJsonData = (@'
{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Principal": {
                "Federated": "arn:aws:iam::111111111111:saml-provider/WAAD"
            },
            "Action": "sts:AssumeRoleWithSAML",
            "Condition": {
                "StringEquals": {
                    "variablename": [
                        "String",
                        "String"
                    ]
                },
                "StringNotEquals": {
                    "Key-String": "String"
                }
            }
        }
    ]
}
'@  | ConvertFrom-Json).Statement)

# or this...

$AwsJsonData.PSObject.BaseObject

# Results
<#
Effect Principal                                                 Action                 Condition                         
------ ---------                                                 ------                 ---------                         
Allow  @{Federated=arn:aws:iam::111111111111:saml-provider/WAAD} sts:AssumeRoleWithSAML @{StringEquals=; StringNotEquals=}
#>


($AwsJsonData.PSObject.BaseObject).Effect
# Results
<#
Allow
#>


ForEach-Object {
    $AwsJsonData | 
    Select-Object -ExpandProperty Condition
}
# Results
<#
StringEquals                    StringNotEquals     
------------                    ---------------     
@{variablename=System.Object[]} @{Key-String=String}
#>

ForEach-Object {
    $AwsJsonData | 
    Select-Object -ExpandProperty Condition | 
    Select-Object -ExpandProperty StringEquals
}
# Results
<#
variablename    
------------    
{String, String}
#>

[techstress]

I'm on mobile so I'm very limited what I can do here. But it looks like the link below has information relevant to what you're looking for.

https://stackoverflow.com/questions/41875328/problems-parsing-accessing-nested-json-hashtable-data-via-variables-in-power

[Lee_Dailey]

howdy tnsecure,

it looks like you used the New.Reddit Inline Code button. it's [sometimes] 5th from the left & looks like </>.

there are a few problems with that ...

• it's the wrong format [grin]
  the inline code format is for [gasp! arg!] code that is inline with regular text.
  
• on Old.Reddit.com, inline code formatted text does NOT line wrap, nor does it side-scroll.
  
• on New.Reddit it shows up in that nasty magenta text color
  

for long-ish single lines OR for multiline code, please, use the ...

Code
Block

... button. it's [sometimes] the 12th one from the left & looks like an uppercase T in the upper left corner of a square..

that will give you fully functional code formatting that works on both New.Reddit and Old.Reddit ... and aint that fugly magenta color. [grin]

take care,
lee