Powershell 2.0 Format-list output to JSON?

Question

PS B:\abrabackups> . C:\ps\ConvertTo-JSON.ps1
PS B:\abrabackups> Get-ItemProperty -Path .\AbraSuite01.03.2014 | select Name,CreationTime | ConvertTo-JSON

And that gives me: (formatted for clarity)

{
 "CreationTime": "2014-01-03T16:48:36", 
 "Name": "AbraSuite01.03.2014"
}

Well that's all well and good, but suppose I want my dates in a different format in the JSON string, is there anyway to do this in powershell and still use my shoehorned ConvertTo-JSON.ps1 for powershell 2.0?

alroc · Accepted Answer · 2014-03-03 21:04:31Z

5

Convert your dates to the format you want before converting to JSON by using a calculated property. For example:

Get-ItemProperty -Path .\AbraSuite01.03.2014 | select Name,@{Name="CreationTime";Expression={$_.CreationTime.ToShortDateString()}} | ConvertTo-JSON

Replace $_.CreationTime.ToShortDateString() with whatever you need to get the date format you're after - but the key here is to use $_.CreationTime to grab the creation time of the object in the pipeline.

edited Mar 3, 2014 at 21:04

answered Mar 3, 2014 at 20:44

alroc

28.3k6 gold badges55 silver badges106 bronze badges

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

2 Comments

leeand00 Over a year ago

What is the @{...} syntax called?

alroc Over a year ago

In this context, it's called a calculated property.

Collectives™ on Stack Overflow

Powershell 2.0 Format-list output to JSON?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related