I need to integrate an existing powershell script to update it's status via a restful web service that returns json. I'm a bit new to powershell but I was able to find the System.Net.WebRequest object do something like the following.
$a = [System.Net.WebRequest]::Create("http://intranet/service/object/")
$a.Method = "GET"
$a.GetResponse()
which returns a json array of objects
[ {id:1}, {id:2}] // etc
I'm not sure where to go from here and how to parse this into a native datatype. I'd like to be able to post and delete as well.
Any pointers? And are there any json/rest libraries or command-lets?
What you want is PowerShell 3 and its Invoke-RestMethod, ConvertTo-Json, and ConvertFrom-Json cmdlets. Your code will end up looking like:
$stuff = invoke-RestMethod -Uri $url -Method Get;
and there shouldn't even be a need to invoke ConvertFrom-Json on the resulting $stuff => it's already in a usable non-string format.
As for POSTs|PUTs, simply use PowerShell hashes and arrays to structure your data and then call ConvertTo-Json on it before passing it to invoke-RestMethod or invoke-WebRequest:
invoke-WebRequest -Uri $url -ContentType application/json -Method Post -Body $objectConvertedToJson
See http://technet.microsoft.com/en-us/Library/hh849971.aspx for details.
You could use DataContractJsonSerializer, which is a part of standard .Net library.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With