Transform JSON as VDOC
Hi
Is there a way to read JSON and transform it (in DTL) by using a VDOC of this JSON (without transform it to internal message) like I can do with HL7 or XML?
If it possible, I guess that I should have a schema of the JSON so the second question is how to build a schema for JSON and load it to the IRIS?
Thanks, Ori.
Product version: IRIS 2022.1
$ZV: IRIS for Windows (x86-64) 2022.2 (Build 368U)
Hi @Ori Tsarfati!
Recently, I had a similar requirement in a personal project and found JSON2Persistent in OpenExchange from @Michael Braam.
I don't know if this is exactly what you need, but using this tool you can transform an ordinary JSON into in a set of persistent IRIS classes which could be used in DTLs.
For instance, I took this FHIR resrouce example and save it to a file.
{ "fullUrl": "", "search": { "mode": "match" }, "resource": { "resourceType" : "Observation", "id" : "body-height", "meta" : { "profile" : ["http://hl7.org/fhir/StructureDefinition/vitalsigns"], "lastUpdated": "2022-12-11T16:21:20Z", "versionId": "1" }, "text" : { "status" : "generated", "div" : "<div xmlns=\"http://www.w3.org/1999/xhtml\"><p><b>Generated Narrative: Observation</b><a name=\"body-height\"> </a></p><div style=\"display: inline-block; background-color: #d9e0e7; padding: 6px; margin: 4px; border: 1px solid #8da1b4; border-radius: 5px; line-height: 60%\"><p style=\"margin-bottom: 0px\">Resource Observation "body-height" </p><p style=\"margin-bottom: 0px\">Profile: <a href=\"vitalsigns.html\">Vital Signs Profile</a></p></div><p><b>status</b>: final</p><p><b>category</b>: Vital Signs <span style=\"background: LightGoldenRodYellow; margin: 4px; border: 1px solid khaki\"> (<a href=\"http://terminology.hl7.org/4.0.0/CodeSystem-observation-category.html\">Observation Category Codes</a>#vital-signs)</span></p><p><b>code</b>: Body height <span style=\"background: LightGoldenRodYellow; margin: 4px; border: 1px solid khaki\"> (<a href=\"https://loinc.org/\">LOINC</a>#8302-2)</span></p><p><b>subject</b>: <a href=\"patient-example.html\">Patient/example</a> "Peter CHALMERS"</p><p><b>effective</b>: 1999-07-02</p><p><b>value</b>: 66.899999999999991 in<span style=\"background: LightGoldenRodYellow\"> (Details: UCUM code [in_i] = 'in_i')</span></p></div>" }, "status" : "final", "category" : [{ "coding" : [{ "system" : "http://terminology.hl7.org/CodeSystem/observation-category", "code" : "vital-signs", "display" : "Vital Signs" }], "text" : "Vital Signs" }], "code" : { "coding" : [{ "system" : "http://loinc.org", "code" : "8302-2", "display" : "Body height" }], "text" : "Body height" }, "subject" : { "reference" : "Patient/example" }, "effectiveDateTime" : "1999-07-02", "valueQuantity" : { "value" : 66.899999999999991, "unit" : "in", "system" : "http://unitsofmeasure.org", "code" : "[in_i]" }, "encounter": { "reference": "Encounter/529" }, "issued": "2012-09-10T11:59:49.565+00:00" } }Then I exctracted a set of persistent classes organized in a package called tmp.FHIRObservationSchema from that file using JSON2Persistent, like this:
$$$TOE(sc, ##class(ISC.SE.Tools.JSON).GenerateClasses("/tmp/file.json", "tmp", "FHIRObservationSchema", 0, 1, "crk", 1))After that, I was able to create a DTLs using the schema created from the FHIR resource JSON:
Class dc.FHIRServer.FHIRConditionToStringRequestDTL Extends Ens.DataTransformDTL [ DependsOn = (tmp.FHIRObservationSchema, Ens.StringRequest) ] { Parameter IGNOREMISSINGSOURCE = 1; Parameter REPORTERRORS = 1; Parameter TREATEMPTYREPEATINGFIELDASNULL = 0; XData DTL [ XMLNamespace = "http://www.intersystems.com/dtl" ] { <transform sourceClass='tmp.FHIRObservationSchema' targetClass='Ens.StringRequest' create='new' language='objectscript' > <assign value='source.resource.id' property='auxId' action='set' /> <assign value='""' property='auxCoding' action='set' /> <foreach property='source.resource.code.coding()' key='k1' > <assign value='auxCoding_source.resource.code.coding.(k1).code_" "' property='auxCoding' action='set' /> </foreach> <assign value='"ID: "_auxId_", Codes: "_auxCoding' property='target.StringValue' action='set' /> </transform> } }So, I create a method to test it:
ClassMethod TestDTL() { Set bodyHeight = { "fullUrl": "", "search": { "mode": "match" }, "resource": { "resourceType" : "Observation", "id" : "body-height", "meta" : { "profile" : ["http://hl7.org/fhir/StructureDefinition/vitalsigns"], "lastUpdated": "2022-12-11T16:21:20Z", "versionId": "1" }, "text" : { "status" : "generated", "div" : "<div xmlns=\"http://www.w3.org/1999/xhtml\"><p><b>Generated Narrative: Observation</b><a name=\"body-height\"> </a></p><div style=\"display: inline-block; background-color: #d9e0e7; padding: 6px; margin: 4px; border: 1px solid #8da1b4; border-radius: 5px; line-height: 60%\"><p style=\"margin-bottom: 0px\">Resource Observation "body-height" </p><p style=\"margin-bottom: 0px\">Profile: <a href=\"vitalsigns.html\">Vital Signs Profile</a></p></div><p><b>status</b>: final</p><p><b>category</b>: Vital Signs <span style=\"background: LightGoldenRodYellow; margin: 4px; border: 1px solid khaki\"> (<a href=\"http://terminology.hl7.org/4.0.0/CodeSystem-observation-category.html\">Observation Category Codes</a>#vital-signs)</span></p><p><b>code</b>: Body height <span style=\"background: LightGoldenRodYellow; margin: 4px; border: 1px solid khaki\"> (<a href=\"https://loinc.org/\">LOINC</a>#8302-2)</span></p><p><b>subject</b>: <a href=\"patient-example.html\">Patient/example</a> "Peter CHALMERS"</p><p><b>effective</b>: 1999-07-02</p><p><b>value</b>: 66.899999999999991 in<span style=\"background: LightGoldenRodYellow\"> (Details: UCUM code [in_i] = 'in_i')</span></p></div>" }, "status" : "final", "category" : [{ "coding" : [{ "system" : "http://terminology.hl7.org/CodeSystem/observation-category", "code" : "vital-signs", "display" : "Vital Signs" }], "text" : "Vital Signs" }], "code" : { "coding" : [{ "system" : "http://loinc.org", "code" : "8302-2", "display" : "Body height" }], "text" : "Body height" }, "subject" : { "reference" : "Patient/example" }, "effectiveDateTime" : "1999-07-02", "valueQuantity" : { "value" : 66.899999999999991, "unit" : "in", "system" : "http://unitsofmeasure.org", "code" : "[in_i]" }, "encounter": { "reference": "Encounter/529" }, "issued": "2012-09-10T11:59:49.565+00:00" } } Set input = ##class(tmp.FHIRObservationSchema).%New() $$$TOE(st, input.%JSONImport(bodyHeight)) $$$TOE(st, ##class(dc.FHIRServer.FHIRConditionToStringRequestDTL).Transform(input, .output)) ZWrite output }And got this output:
HTH,
José
Thanks Jose
My aim was to avoid of generating classes and to work with schema instead (VDoc)
But thanks for this project JSON2Persistent you mentioned it looks useful.