HL7 2.x to JSON DB field

Hi,



I'm looking for the best way to store the HL7 data we receive in input into a JSON field in PostgreSQL.

Our goal is to store the data with the original structure, like the example below:



{

"MSH": {

"MSH.1": "|",

"MSH.2": "^~\\&",

"MSH.3": {

"MSH.3.1": "SwiSyn",

"MSH.3.2": "General"

}, ...



I've read different posts about JSON, but it is not clear if we may use the intergrated Rhino JSON parser to do that or if we have to convert from XML to JSON, for example with json-lib.



http://ift.tt/1C5zQAT

http://ift.tt/1C5zQAT



I've also read MIRTH-2276 and MIRTH-2759 about JSON data type, but unfortunately we can't wait until it will be available.



Any advice on how to achieve that would be very useful.



Thank you

HL7 2.x to JSON DB field