I've been playing around with a similar idea - using plain JSON as the message format, you can make a set of pipeable command line utilities for manipulating data from many web APIs.
https://github.com/benbernard/RecordStream
I've used it a lot and it's a godsend for a most "record-y" manipulation.