Convert XML to JSON (PowerShell) | Operating systems, scripting, PowerShell and security

PowerShell

# Download Json.NET
# Popular high-performance JSON framework for .NET
# https://www.newtonsoft.com/json

# Adds a Microsoft .NET Framework type (a class) to a Windows PowerShell session
Add-Type -Path C:\Users\juan\Desktop\Automatizacion\Windows\packages\Newtonsoft.Json.9.0.1\lib\net45\Newtonsoft.Json.dll

[XML]$members = '<?xml version="1.0"?>
<members>
	<member id="1">
		<user>juanito</user>
		<group>ventas</group>
	</member>
	<member id="2">
		<user>luis</user>
		<group>ventas</group>
	</member>
</members>'

$json = [Newtonsoft.Json.JsonConvert]::SerializeXmlNode($members) | ConvertFrom-Json

$json.members.member | %{
    $_.user
    $_.group
}

# Download Json.NET

# Popular high-performance JSON framework for .NET

# https://www.newtonsoft.com/json

# Adds a Microsoft .NET Framework type (a class) to a Windows PowerShell session

Add-Type -Path C:\Users\juan\Desktop\Automatizacion\Windows\packages\Newtonsoft.Json.9.0.1\lib\net45\Newtonsoft.Json.dll

[XML]$members = '<?xml version="1.0"?>

<user>juanito</user>

<group>ventas</group>

</member>

<group>ventas</group>

</member>

</members>'

$json = [Newtonsoft.Json.JsonConvert]::SerializeXmlNode($members) | ConvertFrom-Json

$json.members.member | %{

$_.user

$_.group

}

Publicado el día 11 de febrero de 2018

CATEGORÍAS

PowerShell