Transform JSON as VDOC

Question

Question

Ori Tsarfati · Nov 15, 2022

#Data Import and Export #Data Model #DTL #JSON #InterSystems IRIS for Health

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)

Discussion (2)2

Log in or sign up to continue

score 1 · Answer 1 · 2023-01-05T21:27:35-05:00

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.

JSON input

{
	"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 &quot;body-height&quot; </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> &quot;Peter CHALMERS&quot;</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:

DTL (Code)

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>
}

}

DTL (UI)

So, I create a method to test it:

DTL test method


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 &quot;body-height&quot; </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> &quot;Peter CHALMERS&quot;</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é

score 1 · Answer 2 · 2023-01-09T07:36:16-05:00

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.