Powershell Json Formatting

Question

I need some help with formatting json data. I'm converting a table to json to be ingested into a log collector. The collector only likes json in single line format. How can I convert this json:

 [
     {  "Severity":  "Informational",
         "Type":  "Milestone",
         "SiteCode":  "ABC",
         "DateTime":  1505840220813,
         "System":  "Server.domain.local",
         "Component":  "SMS_Distribution_Point_Monitoring",
         "Module":  "SMS Server",
         "MessageID":  2380,
         "Description":  "Start to evaluate package ABC001F5 on distribution point  Display=\\\\Server.domain.local\\ MSWNET: SMS_SITE=ABC \\\\Server.domain.local\\."
     },
     {  "Severity":  "Informational",
         "Type":  "Milestone",
         "SiteCode":  "ABC",
         "DateTime":  1505840220787,
         "System":  "Server.domain.local",
         "Component":  "SMS_Distribution_Point_Monitoring",
         "Module":  "SMS Server",
         "MessageID":  2384,
         "Description":  "Package ABC0019F on distribution point  Display=\\\\Server.domain.local\\ MSWNET: SMS_SITE=ABC \\\\Server.domain.local\\ has been verified successfully."
     }
 ]

to this in powershell when outputting to a file:

 [{"Severity":"Informational","Type":"Milestone","SiteCode":"ABC","DateTime":1505840220813,"System":"Server.thecarlylegroup.local","Component":"SMS_Distribution_Point_Monitoring","Module":"SMSServer","MessageID":2380,"Description":"StarttoevaluatepackageABC001F5ondistributionpointDisplay=\\\\Server.thecarlylegroup.local\\MSWNET:SMS_SITE=ABC\\\\Server.thecarlylegroup.local\\."},
 {"Severity":"Informational","Type":"Milestone","SiteCode":"ABC","DateTime":1505840220787,"System":"Server.thecarlylegroup.local","Component":"SMS_Distribution_Point_Monitoring","Module":"SMSServer","MessageID":2384,"Description":"PackageABC0019FondistributionpointDisplay=\\\\Server.thecarlylegroup.local\\MSWNET:SMS_SITE=ABC\\\\Server.thecarlylegroup.local\\hasbeenverifiedsuccessfully."}]

Jason Boyd · Accepted Answer · 2017-09-19 18:01:16Z

5

Assuming you get your data out of your table and into a string similar to the following:

$json = @"
[
     {  "Severity":  "Informational",
         "Type":  "Milestone",
         "SiteCode":  "ABC",
         "DateTime":  1505840220813,
         "System":  "Server.domain.local",
         "Component":  "SMS_Distribution_Point_Monitoring",
         "Module":  "SMS Server",
         "MessageID":  2380,
         "Description":  "Start to evaluate package ABC001F5 on distribution point  Display=\\\\Server.domain.local\\ MSWNET: SMS_SITE=ABC \\\\Server.domain.local\\."
     },
     {  "Severity":  "Informational",
         "Type":  "Milestone",
         "SiteCode":  "ABC",
         "DateTime":  1505840220787,
         "System":  "Server.domain.local",
         "Component":  "SMS_Distribution_Point_Monitoring",
         "Module":  "SMS Server",
         "MessageID":  2384,
         "Description":  "Package ABC0019F on distribution point  Display=\\\\Server.domain.local\\ MSWNET: SMS_SITE=ABC \\\\Server.domain.local\\ has been verified successfully."
     }
]
"@

Then you can do this (the depth was chosen arbitrarily to ensure that the entire object was converted):

$compressedJson = $json | ConvertFrom-Json | ConvertTo-Json -Compress -Depth 100

answered Sep 19, 2017 at 18:01

Jason Boyd

7,0495 gold badges33 silver badges53 bronze badges

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

1 Comment

Patrick Over a year ago

I'm actually outputting to Json and then removing some invalid data as well. $StatusMessagesJson = $StatusMessages| ConvertTo-Json $StatusMessagesJson -replace [Regex]::Escape('"\/Date('),'' -replace [Regex]::Escape(')\/"'),"" | Set-Content $Path

Maximilian Burszley · Accepted Answer · 2017-09-19 17:37:04Z

0

If you're working a string:

$var = (@"
[
     {  "Severity":  "Informational",
         "Type":  "Milestone",
         "SiteCode":  "ABC",
         "DateTime":  1505840220813,
         "System":  "Server.domain.local",
         "Component":  "SMS_Distribution_Point_Monitoring",
         "Module":  "SMS Server",
         "MessageID":  2380,
         "Description":  "Start to evaluate package ABC001F5 on distribution point  Display=\\\\Server.domain.local\\ MSWNET: SMS_SITE=ABC \\\\Server.domain.local\\."
     },
     {  "Severity":  "Informational",
         "Type":  "Milestone",
         "SiteCode":  "ABC",
         "DateTime":  1505840220787,
         "System":  "Server.domain.local",
         "Component":  "SMS_Distribution_Point_Monitoring",
         "Module":  "SMS Server",
         "MessageID":  2384,
         "Description":  "Package ABC0019F on distribution point  Display=\\\\Server.domain.local\\ MSWNET: SMS_SITE=ABC \\\\Server.domain.local\\ has been verified successfully."
     }
]
"@ -split "`n" | % { $_.Trim() }) -join ''

answered Sep 19, 2017 at 17:37

Maximilian Burszley

19.9k7 gold badges39 silver badges68 bronze badges

1 Comment

Patrick Over a year ago

its not a string, its a table being converted to json as it states

Collectives™ on Stack Overflow

Powershell Json Formatting

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related