XML to JSON

[LanciaH]

Hi Me Again,
Version Mirth Connect Server 4.0.1.

I created a channel where the source is a Database Reader into an oracle database.
Simple sql statement that transforms into XML. This part is working correctly/

I have to send this data in JSON format via HTTP,

My Question is where do I do the conversion from XML to JSON? I see other post mentioning code, but where is the code placed?

The vendor provided the JSON fields.
Thanks

[pacmano1]

In a transformer step of type Javascript in general. You can find videos on YouTube that do walkthroughs. While not your data type conversion, see https://www.youtube.com/watch?v=0cuhCL9xKmg. There are others videos for other data type conversions.

[pacmano1]

Also, Oracle like other databases can generate native JSON. While the database reader will wrap that JSON in XML in a single XML tag, you can "unwrap" it in the first step of your transformer.

[LanciaH]

Great idea about using Oracle to create the JSON, let me investigate that option.

Thanks!

[LanciaH]

I used a Transformer to convert the XML into JSON, so far so good.
Thanks all

var jsEntity = GetEntities();
  
  var jsMedications = GetMedications();
  jsMedications.name = msg['name'].toString();
  jsMedications.parentid = msg['parentid'].toString();
  jsMedications.externalid = msg['externalid'].toString();
  
 

  jsEntity.entities.push(jsMedications);  // ADD IT TO THE ENTITY ARRAY
  channelMap.put('Entity_Locations',JSON.stringify(jsEntity));

  
  
//=============================
function GetEntities()
{
  var jsData = 
	{
	  entities: []
	};

  return jsData;
}

//===========================
function GetMedications()
{
  var jsData = 
	{
	 name: "",
      parentid: "",
      externalid: "",
	};

  return jsData;
}

[LanciaH]

Sorry but how do you do code highlighting? Thanks

[FTK7]

Select the code and mark it as code, in the editor options:

[LanciaH]

Did that but how do you get it to use the colors? I tried ...JSON and all the text turns red

[FTK7]

You can specify the language after de backticks:

```javascript
code
```

[LanciaH]

got it, Thanks!