Convert Json Object to string with PowerShell

Question

I'm trying to convert this :

tags: [
    { tagName : "O365" },
    { tagName : "Skype for Business" }
]

to "O365,Skype for Business" as a string.

Could anyone help me to accomplish this using Powershell ?

What have you tried so far?

Sambardo
– Sambardo

2018-04-16 13:04:19 +00:00
Commented Apr 16, 2018 at 13:04 — Sambardo
– Sambardo, Commented Apr 16, 2018 at 13:04
get-help ConvertFrom-Json

Christopher
– Christopher

2018-04-16 13:13:18 +00:00
Commented Apr 16, 2018 at 13:13 — Christopher
– Christopher, Commented Apr 16, 2018 at 13:13

PlageMan · Accepted Answer · 2018-04-16 14:08:50Z

3

Works only if you have only one "tags" property in your JSON :

$json = @"
{
    tags: [
        { tagName : "O365" },
        { tagName : "Skype for Business" }
    ]
}
"@

(ConvertFrom-Json $json | % tags | % tagName) -Join ", "

# result : O365, Skype for Business

edited Apr 16, 2018 at 14:08

answered Apr 16, 2018 at 13:27

PlageMan

8328 silver badges25 bronze badges

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

2 Comments

Joey Over a year ago

In PowerShell 3+ I find it easier to just use ForEach-Object for such things: ConvertFrom-Json $json | % tags | % tagName

PlageMan Over a year ago

@Joey : You are right, Syntax is simpler with %, I updated the answer.

Hubert Léveillé Gauvin · Accepted Answer · 2019-02-12 21:46:46Z

1

Similarly,

$separator = ","
$tagname = (ConvertFrom-Json $json).tags.tagName
[String]::Join($separator,$tagname)

Or as a one-liner

[String]::Join(",",(ConvertFrom-Json $json).tags.tagName)

answered Feb 12, 2019 at 21:46

Hubert Léveillé Gauvin

5231 gold badge5 silver badges14 bronze badges

Collectives™ on Stack Overflow

Convert Json Object to string with PowerShell

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related