PowerShell is a automation and configuration tool that is optimized for dealing with structured data (such as JSON and XML). It was recently open-sourced by Microsoft and runs on Windows, Linux, and OS X.
To get data from a Socrata Open Data API in PowerShell, it is as easy as calling the Invoke-RestMethod cmdlet:
A full example of inserting data can be found in the Active Directory attributes to Socrata Github. I’ve also added a snippet to the automatic API documentation (example) that you can just copy and paste for your dataset!