Powershell - set Json to variable

Question

So I'm making a MySQL query, and one of the columns is a chunk of json that I want to set a particular subset of info to a variable. Wondering if I can condense my code a little. Right now my code is:

$data = Query -Query "select * from TABLE where fqdn = 'testhost.mycompany.com'"

$json = $data.request | ConvertFrom-Json
$WhatIreallyWant = $json.build_request

Can I condense the last two lines? build_request is part of the request json.

$WhatIreallyWant = ($data.request | ConvertFromJson).build_request ? — TessellatingHeckler
– TessellatingHeckler, Commented Aug 9, 2016 at 15:51

Community · Accepted Answer · 2017-05-23 12:14:47Z

2

You could use a pipeline like this

$WhatIWant = $data.request | ConvertFrom-Json | Select-Object -ExpandProperty build_request

or like suggested by TessellatingHeckler in the comments

$WhatIWant = ($data.request | ConvertFrom-Json).build_request

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Aug 9, 2016 at 16:07

DAXaholic

35.9k6 gold badges84 silver badges77 bronze badges

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

1 Comment

cbaum Over a year ago

Indeed it did. Thanks!

Collectives™ on Stack Overflow

Powershell - set Json to variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related