Take a look at the JSON Mapping tool available within QEWD-Ripple
This is built to address the very common requirements to map data from JSON to JSON/ XML to JSON/ etc. (NB For healthcare purposes it also caters for HL7v2 messages)
See slightly older version with some sample data in here
See the tool in action from here,
http://dev.ripple.foundation/json-editor
available in standalone and online versions
https://github.com/robtweed/qewd-transform-json-editor