Existing Result sets (and openEHR RM JSON serializations)

Ocean (XML, see Ocean Informatics EHR Service Interface#DataStructures)
Marand (JSON, see below)
DIPS (JSON, see below)
All the LiU-EEE-specific schemas are at https://github.com/LiU-IMT/EEE/tree/master/src/main/xsd
- Our experimental result format for queries of XML data (originally intended for openEHR AQL queries) in that directory is at https://github.com/LiU-IMT/EEE/blob/master/src/main/xsd/xml-result-v1.xsd It was inspired by SPARQL's result set at http://www.w3.org/TR/rdf-sparql-XMLres/
- ...but agreeing on a JSON-format is probably more urgent than for XML.
- The JSON format for SPARQL might be a useful input for thought though, see http://www.w3.org/TR/2013/REC-sparql11-results-json-20130321/ The "head" and "bindings" stuff using vairables from the query might be interesting. The SPARQL response looks a bit more like the Marand than the DIPS version. I am not sure that using terms like "rows" and "columns" (like in the DIPS-version) is the best for tree-shaped NoSQL data (even though they are logically some kind of rows).
Archie (has RM serialization in JSON & XML)
Code24 (see below)
CaboLabs (see below)

Marand Ehrscape result set

{
  "meta": {
    "href": "http://thinkehr2:8082/rest/v1/query/?aql=select%20%20%20%20%20a_a/data%5Bat0002%5D/events%5Bat0003%5D/data%5Bat0001%5D/items%5Bat0004%5D/value%20as%20Temperature,%20%20%20%20%20a_b/data%5Bat0001%5D/events%5Bat0006%5D/data%5Bat0003%5D/items%5Bat0004%5D/value%20as%20Blood_Pressure_Systolic,%20%20%20%20%20a_b/data%5Bat0001%5D/events%5Bat0006%5D/data%5Bat0003%5D/items%5Bat0005%5D/value%20as%20Diastolic%20from%20EHR%20e%20contains%20COMPOSITION%20a%20contains%20(%20%20%20%20%20OBSERVATION%20a_a%5BopenEHR-EHR-OBSERVATION.body_temperature.v1%5D%20and%20%20%20%20%20OBSERVATION%20a_b%5BopenEHR-EHR-OBSERVATION.blood_pressure.v1%5D)%20offset%200%20limit%20100"
  },
  "aql": "select     a_a/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value as Temperature,     a_b/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value as Blood_Pressure_Systolic,     a_b/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value as Diastolic from EHR e contains COMPOSITION a contains (     OBSERVATION a_a[openEHR-EHR-OBSERVATION.body_temperature.v1] and     OBSERVATION a_b[openEHR-EHR-OBSERVATION.blood_pressure.v1]) offset 0 limit 100",
  "executedAql": "select     a_a/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value as Temperature,     a_b/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value as Blood_Pressure_Systolic,     a_b/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value as Diastolic from EHR e contains COMPOSITION a contains (     OBSERVATION a_a[openEHR-EHR-OBSERVATION.body_temperature.v1] and     OBSERVATION a_b[openEHR-EHR-OBSERVATION.blood_pressure.v1]) offset 0 limit 100",
  "resultSet": [
    {
      "Temperature": {
        "@class": "DV_QUANTITY",
        "magnitude": 37.1,
        "units": "°C",
        "precision": 1
      },
      "Blood_Pressure_Systolic": {
        "@class": "DV_QUANTITY",
        "magnitude": 120,
        "units": "mm[Hg]"
      },
      "Diastolic": {
        "@class": "DV_QUANTITY",
        "magnitude": 90,
        "units": "mm[Hg]"
      }
    },
    {
    ...

There is some meta-data at the beginning:

href: href of the call
aql: the AQL client sent
executedAql: AQL the server executed - this will have potential parameters replaced

Resultset is a simple array of rows with one object per column. Columns names are taken from AQL select aliases, if none is present then just 0-based column index prefixed by a hash-sign (#) is used instead, i.e.: #0 for first column, etc.

JSON format used here for the RM is also used for other operations. Here is an example where we select an Observation rather than simple DATA_VALUEs:

"Measurement": {
    "@class": "OBSERVATION",
    "name": {
      "@class": "DV_TEXT",
      "value": "Body temperature"
    },
    "archetype_details": {
      "@class": "ARCHETYPED",
      "archetype_id": {
        "@class": "ARCHETYPE_ID",
        "value": "openEHR-EHR-OBSERVATION.body_temperature.v1"
...

Attribute names are snake-case (like defined in MagicDraw). We also add attribute @class to every object to define the exact class used for the object. Class names are all upper case and also snake-case.

DIPS Arena EHR ResultSet

Below it the resultset from DIPS Arena EHR Server. The query used is the same as in the Marand example above.

Arena EHR Server supports both JSON and XML on the query resource. The JSON is shown below and a XML examples is here: Arena EHR Server API

ResultSet as JSON

{
  "@class": "RESULTSET",
  "@schemaversion": "0.1.0",
  "@type": "raw",
  "@created": "2016-06-17T14:18:00.422+02:00",
  "@generator": "DIPS.OpenEhr.ResultSets.Serialization.Json.ResultSetJsonWriter (5.0.0.0)",
  "name": null,
  "correlationid": "00000000-0000-0000-0000-000000000000",
  "totalResults": 31,
  "columns": [
    {
      "name": "Temperature",
      "path": "/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value"
    },
    {
      "name": "Blood_Pressure_Systolic",
      "path": "/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value"
    },
    {
      "name": "Diastolic",
      "path": "/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value"
    }
  ],
  "rows": [
    [
      {
        "@class": "DV_QUANTITY",
        "magnitude": 37.0,
        "units": "Cel"
      },
      {
        "@class": "DV_QUANTITY",
        "magnitude": 120.0,
        "units": "mm[Hg]"
      },
      {
        "@class": "DV_QUANTITY",
        "magnitude": 80.0,
        "units": "mm[Hg]"
      }
    ],

Archie

Archie can serialize RM Objects to XML using the standard openEHR RM XSD, or it can be used to serialize to JSON. The format we have now is very similar that the one Marand uses: snake_cased attribute names, type names as the same notation as the RM specs.

The code to serialize to this format or parse it to RM Objects is present in Archie starting from version 0.2.1

 "data" : {
      "@type" : "HISTORY",
      "name" : {
        "@type" : "DV_TEXT",
        "value" : "history"
      },
      "archetype_node_id" : "id2",
      "events" : [ {
        "@type" : "POINT_EVENT",
        "name" : {
          "@type" : "DV_TEXT",
          "value" : "any event"
        },
        "archetype_node_id" : "id7",
        "time" : {
          "@type" : "DV_DATE_TIME",
          "magnitude" : 1466427403,
          "value" : "2016-06-20T14:56:43.702+02:00"
        },    
		"data" : {
          "@type" : "ITEM_TREE",
          "name" : {
            "type" : "DV_TEXT"
          },
          "archetype_node_id" : "id4",
          "items" : [ {
            "@type" : "ELEMENT",
            "name" : {
              "@type" : "DV_TEXT",
              "value" : "Systolic"
            },
            "archetype_node_id" : "id5",
            "value" : {
              "@type" : "DV_QUANTITY",
              "magnitude" : 120.0,
              "precision" : 0,
              "units" : "mm[Hg]"
            },
            "path" : "/data[id2]/event[id7]/data[id4]/item[id5]"
          }, {
            "@type" : "ELEMENT",
            "name" : {
              "@type" : "DV_TEXT",
              "value" : "Diastolic"
            },
            "archetype_node_id" : "id6",
            "value" : {
              "@type" : "DV_QUANTITY",
              "magnitude" : 80.0,
              "precision" : 0,
              "units" : "mm[Hg]"
            },
            "path" : "/data[id2]/event[id7]/data[id4]/item[id6]"
          },

Code24

Code24 does not have yet implemented AQL, but most probably it will be ready in Q3/Q4 2016. Intention is to follow the same JSON as Marand's example above. The current RESTApi that we have at this time is published at http://rest.base24.nl/docs

CaboLabs

We do XML to JSON automatically. Our result sets have different forms, one oriented to COMPOSITIONS one oriented to DATATYPES.

COMPOSITIONS

composition output

{
  "list": {
    "@xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
    "@xmlns": "http://schemas.openehr.org/v1",
    "version": {
      "@xsi:type": "ORIGINAL_VERSION",
      "contribution": {
        "id": {
          "@xsi:type": "HIER_OBJECT_ID",
          "value": "71da6483-9e69-43dc-82a9-dc5926a41c7d"
        },
        "namespace": "EHR::COMMON",
        "type": "CONTRIBUTION"
      },
      "commit_audit": {
        "system_id": "CABOLABS_EHR",
        "committer": {
          "@xsi:type": "PARTY_IDENTIFIED",
          "external_ref": {
            "id": {
              "@xsi:type": "HIER_OBJECT_ID",
              "value": "cc193f71-f5fe-438a-87f9-81ecb302eede"
            },
            "namespace": "DEMOGRAPHIC",
            "type": "PERSON"
          },
          "name": "Dr. House"
        },
        "time_committed": {
          "value": "20160502T174526,000-0400"
        },
        "change_type": {
          "value": "creation",
          "defining_code": {
            "terminology_id": {
              "value": "openehr"
            },
            "code_string": 249
          }
        }
      },
      "uid": {
        "value": "e02b938e-ffca-446e-9562-ed609b0a67ad::EMR::1"
      },
      "data": {
        "@xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
        "@archetype_node_id": "openEHR-EHR-COMPOSITION.signos.v1",
        "@xsi:type": "COMPOSITION",
        "name": {
          "value": "Signos vitales"
        },
        "uid": {
          "@xsi:type": "HIER_OBJECT_ID",
          "value": "6ee98578-06e7-486b-a903-2a2fea21b1e9"
        },
        "archetype_details": {
          "archetype_id": {
            "value": "openEHR-EHR-COMPOSITION.signos.v1"
          },
          "template_id": {
            "value": "Signos"
          },
          "rm_version": "1.0.2"
        },
        "language": {
          "terminology_id": {
            "value": "ISO_639-1"
          },
          "code_string": "es"
        },
        "territory": {
          "terminology_id": {
            "value": "ISO_3166-1"
          },
          "code_string": "UY"
        },
        "category": {
          "value": "event",
          "defining_code": {
            "terminology_id": {
              "value": "openehr"
            },
            "code_string": 443
          }
        },
        "composer": {
          "@xsi:type": "PARTY_IDENTIFIED",
          "external_ref": {
            "id": {
              "@xsi:type": "HIER_OBJECT_ID",
              "value": "cc193f71-f5fe-438a-87f9-81ecb302eede"
            },
            "namespace": "DEMOGRAPHIC",
            "type": "PERSON"
          },
          "name": "Dr. House"
        },
        "context": {
          "start_time": {
            "value": "20160502T174526,000-0400"
          },
          "setting": {
            "value": "Hospital Montevideo",
            "defining_code": {
              "terminology_id": {
                "value": "openehr"
              },
              "code_string": 229
            }
          }
        },
        "content": [
          {
            "@archetype_node_id": "openEHR-EHR-OBSERVATION.blood_pressure.v1",
            "@xsi:type": "OBSERVATION",
            "name": {
              "value": "Blood Pressure"
            },
            "language": {
              "terminology_id": {
                "value": "ISO_639-1"
              },
              "code_string": "es"
            },
            "encoding": {
              "terminology_id": {
                "value": "Unicode"
              },
              "code_string": "UTF-8"
            },
            "subject": {
              "@xsi:type": "PARTY_SELF"
            },
            "protocol": {
              "@archetype_node_id": "at0011",
              "@xsi:type": "ITEM_TREE",
              "name": {
                "value": "Tree"
              }
            },
            "data": {
              "@archetype_node_id": "at0001",
              "@xsi:type": "HISTORY",
              "name": {
                "value": "history"
              },
              "origin": {
                "@xsi:type": "DV_DATE_TIME",
                "value": "20160502T174526,000-0400"
              },
              "events": {
                "@archetype_node_id": "at0006",
                "@xsi:type": "POINT_EVENT",
                "name": {
                  "value": "any event"
                },
                "time": {
                  "@xsi:type": "DV_DATE_TIME",
                  "value": "20160502T174526,000-0400"
                },
                "data": {
                  "@archetype_node_id": "at0003",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "blood pressure"
                  },
                  "items": [
                    {
                      "@archetype_node_id": "at0005",
                      "@xsi:type": "ELEMENT",
                      "name": {
                        "value": "Diastolic"
                      },
                      "value": {
                        "@xsi:type": "DV_QUANTITY",
                        "magnitude": 92,
                        "units": "mm[Hg]"
                      }
                    },
                    {
                      "@archetype_node_id": "at0004",
                      "@xsi:type": "ELEMENT",
                      "name": {
                        "value": "Systolic"
                      },
                      "value": {
                        "@xsi:type": "DV_QUANTITY",
                        "magnitude": 180,
                        "units": "mm[Hg]"
                      }
                    }
                  ]
                },
                "state": {
                  "@archetype_node_id": "at0007",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "state structure"
                  }
                }
              }
            }
          },
          {
            "@archetype_node_id": "openEHR-EHR-OBSERVATION.body_temperature.v1",
            "@xsi:type": "OBSERVATION",
            "name": {
              "value": "Body temperature"
            },
            "language": {
              "terminology_id": {
                "value": "ISO_639-1"
              },
              "code_string": "es"
            },
            "encoding": {
              "terminology_id": {
                "value": "Unicode"
              },
              "code_string": "UTF-8"
            },
            "subject": {
              "@xsi:type": "PARTY_SELF"
            },
            "protocol": {
              "@archetype_node_id": "at0020",
              "@xsi:type": "ITEM_TREE",
              "name": {
                "value": "Protocol"
              }
            },
            "data": {
              "@archetype_node_id": "at0002",
              "@xsi:type": "HISTORY",
              "name": {
                "value": "History"
              },
              "origin": {
                "@xsi:type": "DV_DATE_TIME",
                "value": "20160502T174526,000-0400"
              },
              "events": {
                "@archetype_node_id": "at0003",
                "@xsi:type": "POINT_EVENT",
                "name": {
                  "value": "Any event"
                },
                "time": {
                  "@xsi:type": "DV_DATE_TIME",
                  "value": "20160502T174526,000-0400"
                },
                "data": {
                  "@archetype_node_id": "at0001",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "Tree"
                  },
                  "items": {
                    "@archetype_node_id": "at0004",
                    "@xsi:type": "ELEMENT",
                    "name": {
                      "value": "Temperature"
                    },
                    "value": {
                      "@xsi:type": "DV_QUANTITY",
                      "magnitude": 39,
                      "units": "°C"
                    }
                  }
                },
                "state": {
                  "@archetype_node_id": "at0029",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "State"
                  }
                }
              }
            }
          },
          {
            "@archetype_node_id": "openEHR-EHR-OBSERVATION.pulse.v1",
            "@xsi:type": "OBSERVATION",
            "name": {
              "value": "Pulso"
            },
            "language": {
              "terminology_id": {
                "value": "ISO_639-1"
              },
              "code_string": "es"
            },
            "encoding": {
              "terminology_id": {
                "value": "Unicode"
              },
              "code_string": "UTF-8"
            },
            "subject": {
              "@xsi:type": "PARTY_SELF"
            },
            "protocol": {
              "@archetype_node_id": "at0010",
              "@xsi:type": "ITEM_TREE",
              "name": {
                "value": "*List(en)"
              }
            },
            "data": {
              "@archetype_node_id": "at0002",
              "@xsi:type": "HISTORY",
              "name": {
                "value": "*history(en)"
              },
              "origin": {
                "@xsi:type": "DV_DATE_TIME",
                "value": "20160502T174526,000-0400"
              },
              "events": {
                "@archetype_node_id": "at0003",
                "@xsi:type": "POINT_EVENT",
                "name": {
                  "value": "*Any event(en)"
                },
                "time": {
                  "@xsi:type": "DV_DATE_TIME",
                  "value": "20160502T174526,000-0400"
                },
                "data": {
                  "@archetype_node_id": "at0001",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "*structure(en)"
                  },
                  "items": {
                    "@archetype_node_id": "at0004",
                    "@xsi:type": "ELEMENT",
                    "name": {
                      "@xsi:type": "DV_CODED_TEXT",
                      "value": "Frecuencia cardiaca",
                      "defining_code": {
                        "terminology_id": {
                          "value": "local"
                        },
                        "code_string": "at1027"
                      }
                    },
                    "value": {
                      "@xsi:type": "DV_QUANTITY",
                      "magnitude": 65,
                      "units": "/min"
                    }
                  }
                },
                "state": {
                  "@archetype_node_id": "at0012",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "*List(en)"
                  }
                }
              }
            }
          },
          {
            "@archetype_node_id": "openEHR-EHR-OBSERVATION.respiration.v1",
            "@xsi:type": "OBSERVATION",
            "name": {
              "value": "Respirations"
            },
            "language": {
              "terminology_id": {
                "value": "ISO_639-1"
              },
              "code_string": "es"
            },
            "encoding": {
              "terminology_id": {
                "value": "Unicode"
              },
              "code_string": "UTF-8"
            },
            "subject": {
              "@xsi:type": "PARTY_SELF"
            },
            "data": {
              "@archetype_node_id": "at0001",
              "@xsi:type": "HISTORY",
              "name": {
                "value": "history"
              },
              "origin": {
                "@xsi:type": "DV_DATE_TIME",
                "value": "20160502T174526,000-0400"
              },
              "events": {
                "@archetype_node_id": "at0002",
                "@xsi:type": "POINT_EVENT",
                "name": {
                  "value": "Any event"
                },
                "time": {
                  "@xsi:type": "DV_DATE_TIME",
                  "value": "20160502T174526,000-0400"
                },
                "data": {
                  "@archetype_node_id": "at0003",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "List"
                  },
                  "items": {
                    "@archetype_node_id": "at0004",
                    "@xsi:type": "ELEMENT",
                    "name": {
                      "value": "Rate"
                    },
                    "value": {
                      "@xsi:type": "DV_QUANTITY",
                      "magnitude": 66,
                      "units": "/min"
                    }
                  }
                },
                "state": {
                  "@archetype_node_id": "at0022",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "List"
                  }
                }
              }
            }
          },
          {
            "@archetype_node_id": "openEHR-EHR-OBSERVATION.body_weight.v1",
            "@xsi:type": "OBSERVATION",
            "name": {
              "value": "Peso corporal"
            },
            "language": {
              "terminology_id": {
                "value": "ISO_639-1"
              },
              "code_string": "es"
            },
            "encoding": {
              "terminology_id": {
                "value": "Unicode"
              },
              "code_string": "UTF-8"
            },
            "subject": {
              "@xsi:type": "PARTY_SELF"
            },
            "protocol": {
              "@archetype_node_id": "at0015",
              "@xsi:type": "ITEM_TREE",
              "name": {
                "value": "*protocol structure(en)"
              }
            },
            "data": {
              "@archetype_node_id": "at0002",
              "@xsi:type": "HISTORY",
              "name": {
                "value": "*history(en)"
              },
              "origin": {
                "@xsi:type": "DV_DATE_TIME",
                "value": "20160502T174526,000-0400"
              },
              "events": {
                "@archetype_node_id": "at0003",
                "@xsi:type": "POINT_EVENT",
                "name": {
                  "value": "Cualquier evento."
                },
                "time": {
                  "@xsi:type": "DV_DATE_TIME",
                  "value": "20160502T174526,000-0400"
                },
                "data": {
                  "@archetype_node_id": "at0001",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "*Simple(en)"
                  },
                  "items": {
                    "@archetype_node_id": "at0004",
                    "@xsi:type": "ELEMENT",
                    "name": {
                      "value": "Peso"
                    },
                    "value": {
                      "@xsi:type": "DV_QUANTITY",
                      "magnitude": 48,
                      "units": "kg"
                    }
                  }
                },
                "state": {
                  "@archetype_node_id": "at0008",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "*state structure(en)"
                  }
                }
              }
            }
          },
          {
            "@archetype_node_id": "openEHR-EHR-OBSERVATION.height.v1",
            "@xsi:type": "OBSERVATION",
            "name": {
              "value": "Height/Length"
            },
            "language": {
              "terminology_id": {
                "value": "ISO_639-1"
              },
              "code_string": "es"
            },
            "encoding": {
              "terminology_id": {
                "value": "Unicode"
              },
              "code_string": "UTF-8"
            },
            "subject": {
              "@xsi:type": "PARTY_SELF"
            },
            "protocol": {
              "@archetype_node_id": "at0007",
              "@xsi:type": "ITEM_TREE",
              "name": {
                "value": "List"
              }
            },
            "data": {
              "@archetype_node_id": "at0001",
              "@xsi:type": "HISTORY",
              "name": {
                "value": "history"
              },
              "origin": {
                "@xsi:type": "DV_DATE_TIME",
                "value": "20160502T174526,000-0400"
              },
              "events": {
                "@archetype_node_id": "at0002",
                "@xsi:type": "POINT_EVENT",
                "name": {
                  "value": "Any event"
                },
                "time": {
                  "@xsi:type": "DV_DATE_TIME",
                  "value": "20160502T174526,000-0400"
                },
                "data": {
                  "@archetype_node_id": "at0003",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "Simple"
                  },
                  "items": {
                    "@archetype_node_id": "at0004",
                    "@xsi:type": "ELEMENT",
                    "name": {
                      "value": "Height/Length"
                    },
                    "value": {
                      "@xsi:type": "DV_QUANTITY",
                      "magnitude": 194,
                      "units": "cm"
                    }
                  }
                },
                "state": {
                  "@archetype_node_id": "at0013",
                  "@xsi:type": "ITEM_TREE",
                  "name": {
                    "value": "Tree"
                  }
                }
              }
            }
          }
        ]
      },
      "lifecycle_state": {
        "value": "completed",
        "defining_code": {
          "terminology_id": {
            "value": "openehr"
          },
          "code_string": 532
        }
      }
    }
  }
}

DATATYPES (the result set can be not grouped, grouped by path (good for charting), grouped by composition (good for table display))

not grouped

[
  {
    "archetypeId": "openEHR-EHR-OBSERVATION.blood_pressure.v1",
    "archetypePath": "/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
    "magnitude": 69,
    "owner": {
      "uid": "123123123-..."
    },
    "path": "/content[archetype_id=openEHR-EHR-OBSERVATION.blood_pressure.v1]/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
    "templateId": "Signos",
    "units": "mm[Hg]"
  },
  {
    "archetypeId": "openEHR-EHR-OBSERVATION.blood_pressure.v1",
    "archetypePath": "/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
    "magnitude": 107,
    "owner": {
      "uid": "123123123-..."
    },
    "path": "/content[archetype_id=openEHR-EHR-OBSERVATION.blood_pressure.v1]/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
    "templateId": "Signos",
    "units": "mm[Hg]"
  },
  {
    "archetypeId": "openEHR-EHR-OBSERVATION.body_temperature.v1",
    "archetypePath": "/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
    "magnitude": 38,
    "owner": {
      "uid": "123123123-..."
    },
    "path": "/content[archetype_id=openEHR-EHR-OBSERVATION.body_temperature.v1]/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
    "templateId": "Signos",
    "units": "°C"
  },
  ...
]

grouped by path

{
  "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value": {
    "type": "DV_QUANTITY",
    "name": "Sistólica",
    "serie": [
      {
        "magnitude": 140,
        "units": "mm[Hg]",
        "date": "2016-04-23 03:12:20"
      },
      {
        "magnitude": 121,
        "units": "mm[Hg]",
        "date": "2016-04-30 06:58:05"
      },
      {
        "magnitude": 180,
        "units": "mm[Hg]",
        "date": "2016-05-02 21:45:26"
      },
      {
        "magnitude": 107,
        "units": "mm[Hg]",
        "date": "2016-05-23 22:52:34"
      }
    ]
  },
  "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value": {
    "type": "DV_QUANTITY",
    "name": "Diastólica",
    "serie": [
      {
        "magnitude": 76,
        "units": "mm[Hg]",
        "date": "2016-04-23 03:12:20"
      },
      {
        "magnitude": 54,
        "units": "mm[Hg]",
        "date": "2016-04-30 06:58:05"
      },
      {
        "magnitude": 92,
        "units": "mm[Hg]",
        "date": "2016-05-02 21:45:26"
      },
      {
        "magnitude": 69,
        "units": "mm[Hg]",
        "date": "2016-05-23 22:52:34"
      }
    ]
  },
  "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
    "type": "DV_QUANTITY",
    "name": "Temperature",
    "serie": [
      {
        "magnitude": 36,
        "units": "°C",
        "date": "2016-04-23 03:12:20"
      },
      {
        "magnitude": 39,
        "units": "°C",
        "date": "2016-04-30 06:58:05"
      },
      {
        "magnitude": 39,
        "units": "°C",
        "date": "2016-05-02 21:45:26"
      },
      {
        "magnitude": 38,
        "units": "°C",
        "date": "2016-05-23 22:52:34"
      }
    ]
  },
  "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
    "type": "DV_QUANTITY",
    "name": "Peso",
    "serie": [
      {
        "magnitude": 81,
        "units": "kg",
        "date": "2016-04-23 03:12:20"
      },
      {
        "magnitude": 75,
        "units": "kg",
        "date": "2016-04-30 06:58:05"
      },
      {
        "magnitude": 48,
        "units": "kg",
        "date": "2016-05-02 21:45:26"
      },
      {
        "magnitude": 44,
        "units": "kg",
        "date": "2016-05-23 22:52:34"
      }
    ]
  },
  "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value": {
    "type": "DV_QUANTITY",
    "name": "Rate",
    "serie": [
      {
        "magnitude": 50,
        "units": "/min",
        "date": "2016-04-23 03:12:20"
      },
      {
        "magnitude": 41,
        "units": "/min",
        "date": "2016-04-30 06:58:05"
      },
      {
        "magnitude": 66,
        "units": "/min",
        "date": "2016-05-02 21:45:26"
      },
      {
        "magnitude": 61,
        "units": "/min",
        "date": "2016-05-23 22:52:34"
      }
    ]
  },
  "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
    "type": "DV_QUANTITY",
    "name": "Frecuencia",
    "serie": [
      {
        "magnitude": 91,
        "units": "/min",
        "date": "2016-04-23 03:12:20"
      },
      {
        "magnitude": 47,
        "units": "/min",
        "date": "2016-04-30 06:58:05"
      },
      {
        "magnitude": 65,
        "units": "/min",
        "date": "2016-05-02 21:45:26"
      },
      {
        "magnitude": 42,
        "units": "/min",
        "date": "2016-05-23 22:52:34"
      }
    ]
  }
}

grouped by composition

[
  {
    "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value": {
      "type": "DV_QUANTITY",
      "name": "Sistólica",
      "attrs": [
        "magnitude",
        "units"
      ]
    },
    "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value": {
      "type": "DV_QUANTITY",
      "name": "Diastólica",
      "attrs": [
        "magnitude",
        "units"
      ]
    },
    "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
      "type": "DV_QUANTITY",
      "name": "Temperature",
      "attrs": [
        "magnitude",
        "units"
      ]
    },
    "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
      "type": "DV_QUANTITY",
      "name": "Peso",
      "attrs": [
        "magnitude",
        "units"
      ]
    },
    "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value": {
      "type": "DV_QUANTITY",
      "name": "Rate",
      "attrs": [
        "magnitude",
        "units"
      ]
    },
    "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
      "type": "DV_QUANTITY",
      "name": "Frecuencia",
      "attrs": [
        "magnitude",
        "units"
      ]
    }
  },
  {
    "73c9fa14-a5e3-45d2-bf08-7e3a97ef3de4": {
      "date": "2016-04-23 03:12:20",
      "cols": [
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
          "magnitude": 140,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
          "magnitude": 76,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 36,
          "units": "°C"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 81,
          "units": "kg"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
          "magnitude": 50,
          "units": "/min"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 91,
          "units": "/min"
        }
      ]
    },
    "58c55bd6-e4b5-47dd-b96e-0dff42a0270e": {
      "date": "2016-04-30 06:58:05",
      "cols": [
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
          "magnitude": 121,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
          "magnitude": 54,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 39,
          "units": "°C"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 75,
          "units": "kg"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
          "magnitude": 41,
          "units": "/min"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 47,
          "units": "/min"
        }
      ]
    },
    "6ee98578-06e7-486b-a903-2a2fea21b1e9": {
      "date": "2016-05-02 21:45:26",
      "cols": [
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
          "magnitude": 180,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
          "magnitude": 92,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 39,
          "units": "°C"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 48,
          "units": "kg"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
          "magnitude": 66,
          "units": "/min"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 65,
          "units": "/min"
        }
      ]
    },
    "a51fcc18-5dcd-4711-ad4b-969fa1407894": {
      "date": "2016-05-23 22:52:34",
      "cols": [
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
          "magnitude": 107,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
          "magnitude": 69,
          "units": "mm[Hg]"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 38,
          "units": "°C"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 44,
          "units": "kg"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
          "magnitude": 61,
          "units": "/min"
        },
        {
          "type": "DV_QUANTITY",
          "path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
          "magnitude": 42,
          "units": "/min"
        }
      ]
    }
  }
]

JSON Specifics

Proposed Standard