How to retrieve JSON data using PowerShell?

Question

I have this JSON. Trying to retrieve tactics array by using below code in PowerShell.

Why the actual output is weird even though tactics contains comma separated values, it is considering as one value with space separated values.

How to get the expected output?

My JSON:

  {
       "displayName": "travel with mailbox permission",
     "tactics": [
            "InitialAccess",
            "PrivilegeEscalation"
          ],
          "techniques": [
            "T1078",
            "T1548"
          ]
  }

My code:

param (
    [Parameter(Mandatory = $true)]
     # The resourceVariable which holds the resource details
    [string] $jsonvariable
    
)   
 $json = Get-AutomationVariable -Name $jsonvariable
 $jsonObject = ConvertFrom-Json -InputObject $json
            
         echo $jsonObject.tactics

Output:

 Expected o/p:
 InitialAccess,PrivilegeEscalation
            
 Actual O/p :
 InitialAccess PrivilegeEscalation

Please edit your question and create a valid minimal reproducible example. In its current state it produces a (Unexpected token ':' in expression or statement.) error. With regards to the issue, this is just how it is displayed, the actual object is probably just an array. Try $json.tactics.GetType(), $json.tactics.count or $json.tactics[0]. — iRon
– iRon, Commented Feb 7, 2023 at 10:51
The sample code you've posted is not valid PowerShell. Is $json a string containing the json? — Mathias R. Jessen
– Mathias R. Jessen, Commented Feb 7, 2023 at 11:10
@iRon $json.tactics.count is coming as 1 eventhough it has 2 values — dev333
– dev333, Commented Feb 7, 2023 at 11:14
"$json.tactics.count is coming as 1 eventhough it has 2 value". For me it returns 2: ('{"displayName":"travel with mailbox permission","tactics":["InitialAccess","PrivilegeEscalation"],"techniques":["T1078","T1548"]}' |ConvertFrom-Json).tactics.Count — iRon
– iRon, Commented Feb 7, 2023 at 11:55

Anthony Norwood · Accepted Answer · 2023-02-07 10:49:27Z

1

Try using

$json.tactics -join ','

Powershell is outputting each value in the array separately, rather than as a comma-separated list.

answered Feb 7, 2023 at 10:49

Anthony Norwood

4672 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to retrieve JSON data using PowerShell?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related