Stream: implementers
Topic: JSON to JSON transformation - problem statement
Liron Shahar-Atia (Dec 01 2021 at 20:07):
In the frame of ongoing interfaces transformation activities from propriety JSON-based structure to the FHIR JSON structure, we are looking for a tool/method/document structure/visualization tool, providing capabilities to create a specification document describing the source to target mapping and transformation between different JSON structures.
The target population for the document is the development team responsible for source-to-target process deployment using the organizational ESB platform.
Multiple attempts to build a suitable template for JSON to JSON transformation using conventional tools like MS Excel and MS Word didn't bring the desired results due to lack of visual representation support for complex, structure to structure mappings and transformation between hierarchy elements using lookup tables and other data transformation methods.
First example attached, Excel-based: JSON-to-JSON-transformation-Excel-based.jpg
In the simple example we can see two trasnfomrations:
subject.type+subject.id -> subject reference &
subject.name.given+subject.name.family -> subject.display (inlcuding values)
Second example attached, Word-based: JSON-to-JSON-transformation-Word-based.png
In the following example, transformation is done by applying specific logic on identifier described separately in the Word-based specification document.
In many cases, the described method causes incorrect interpretation and, as a result, logical bugs in JSON to JSON conversion.
Lloyd McKenzie (Dec 01 2021 at 23:39):
Have you looked at StructureMap? It'll handle the complexity, though it won't necessarily give you a pretty rendering.
Liron Shahar-Atia (Dec 02 2021 at 19:58):
Thank you Lloyd for your response.
The StructureMap resource doesn’t have visualization, so it is not exactly what we are looking for. In the meantime, we are using Jsonata, which reminds the StructureMap, but it also lacks the ability to display the differences between one Json to another.
Last updated: Apr 12 2022 at 19:14 UTC
