Mirth Converts MSH|^~\&| to MSH|^~\&amp:|

[LanciaH]

Hi All, First post, apologies if this has been answered before. I tried searching and found posts kinda related but not exactly my problem.

This is our first time using Mirth, We are using Mirth to convert a CSV file to HL7 file and then send the HL7 file through a web service in a SOAP wrapper.

The HL7 file get created fine and has been validated. Looks like when MIRTH converts the HL7 file to XML, MIRTH converts & to &amp: from MSH|^**&**| to <MSH.2>^**&amp:**</MSH.2> causing problems in the webservice file transfer. At least that is what the vendor tells me.

Is there a way to prevent this conversion of & to &amp:?

Thanks,
Ralph

[jonbartels]

Hi All, First post, apologies if this has been answered before. I tried searching and found posts kinda related but not exactly my problem.

Great first post. Welcome to the community. Please share what you searched for and where you looked. Github discussions are good. https://forums.mirthproject.io/ has decades of old threads.

Please also make sure your screenshots do not contain real patient information.

If you can, please also edit your post to include:

• XML snippets of your inbound and outbound messages. Use the code formatting tags please
• Show your "data types" settings from the MC channel

This is definitely an XML escaping issue but I can't quite see where the problem is. The inbound RequestHL7Message has an ampersand in it but it is XML, if you escape the inbound message to have & does your HL7 render correctly?

[LanciaH]

Hi Jo,.
In Google I searched for the following MIRTH &amp: and received the following results which led me to this forum.
I did not setup the channel but I'll take a look. Not sure how to do this part, "if you escape the inbound message to have &"

Channel Data Types?

Raw Message
MSH|^~&|NJDOCCentricity|9999|NJIIS|NJDOH|2022042014720||VXU^V04^VXU_V04|NJDOCCentricity64412022042014720|T|2.5.1|||NE|AL|||||Z22^CDCPHINVS|

Transformed & Encoded


<MSH.1>|</MSH.1>
<MSH.2>^~&amp;</MSH.2>
<MSH.3>
<MSH.3.1>NJDOCCentricity</MSH.3.1>
</MSH.3>
<MSH.4>
<MSH.4.1>9999</MSH.4.1>
</MSH.4>
<MSH.5>
<MSH.5.1>NJIIS</MSH.5.1>
</MSH.5>
<MSH.6>
<MSH.6.1>NJDOH</MSH.6.1>
</MSH.6>
<MSH.7>
<MSH.7.1>2022042014720</MSH.7.1>

Part of the Sent message, I can't show all of it due to medical info
WSDL URL: https://njiis-uat.nj.gov:443/ims/service?wsdl
SERVICE: {http:https://njiis.njdoh.gov/ims/service}NJIISIMSService
PORT / ENDPOINT: {http:https://njiis.njdoh.gov/ims/service}NJIISIMSServicePort
LOCATION URI: https://njiis-uat.nj.gov:443/ims/service
SOAP ACTION: http:https://njiis.nj.gov/ims/service/submitPatientImmInfo

[ATTACHMENTS]

[CONTENT]
<soap:Envelope xmlns:soap="http:https://www.w3.org/2003/05/soap-envelope" xmlns:req="http:https://njiis.njdoh.gov/ims/service/schema/hl7/put/request">
soap:Header/
soap:Body
req:NJIISIMSPutRequest
req:RequestHeader
req:FacilityID9999999</req:FacilityID>
req:FacilityKey999999</req:FacilityKey>
</req:RequestHeader>
req:PutRequest

req:NJIISProviderID9999</req:NJIISProviderID>
req:HL7MessageVersion2.5.1</req:HL7MessageVersion>
req:RequestHL7MessageMSH|^~&|NJDOCCentricity|9999|NJIIS|NJDOH|2022042014720||VXU^V04^VXU_V04|NJDOCCentricity64412022042014720|T|2.5.1|||NE|AL|||||Z22^CDCPHINVS|

Response Error
ERROR: Error creating web service dispatch [SOAPExceptionImpl: Error during saving a multipart message]

[tonygermano]

The \ is still missing in that XML snippet, and your & is double escaped. For the double escape to be correct, I would expect to see all of the < escaped as well.

[LanciaH]

Hi Tony, Not sure what you mean by , "I would expect to see all of the < escaped as well."

Thanks for trying to help. I'm about to give up, this should not be this obtuse, Of course I don't help matters by not knowing anything related to SOAP.

I changed
tmp['MSH']['MSH.2']="^\&"
to
tmp['MSH']['MSH.2']="^\&"

This causes the XML to look like, <MSH.2>^&amp;amp;</MSH.2>
SOAP Sent Message, req:RequestHL7MessageMSH|^&|NJDOCCentricity

[tonygermano]

You may want to look at this https://docs.github.com/en/get-started/writing-on-github/getting-started-with-writing-and-formatting-on-github/basic-writing-and-formatting-syntax#quoting-code

I'm not sure how many of the errors in what you are copy/pasting are actually just due to formatting since you aren't using code blocks.

[LanciaH]

Great thanks, I'll take a look.

[tonygermano]

you should be able to edit your existing posts and insert the markdown to clean them up and make them more readable.

[LanciaH]

We are getting the following SOAP Error; ERROR: Error creating web service dispatch [SOAPExceptionImpl: Error during saving a multipart message]

WSDL URL: https://njiis-uat.nj.gov:443/ims/service?wsdl
SERVICE: {http:https://njiis.TESTCV19.gov/ims/service}NJIISIMSService
PORT / ENDPOINT: {http:https://njiis.TESTCV19.gov/ims/service}NJIISIMSServicePort
LOCATION URI: https://njiis-uat.nj.gov:443/ims/service
SOAP ACTION: http:https://njiis.nj.gov/ims/service/submitPatientImmInfo

[ATTACHMENTS]

[CONTENT]
<soap:Envelope xmlns:soap="http:https://www.w3.org/2003/05/soap-envelope" xmlns:req="http:https://njiis.TESTCV19.gov/ims/service/schema/hl7/put/request">
soap:Header/
soap:Body
req:NJIISIMSPutRequest
req:RequestHeader
req:FacilityIDCOVID9999</req:FacilityID>
req:FacilityKeyCOVID123$</req:FacilityKey>
</req:RequestHeader>
req:PutRequest

req:NJIISProviderID9999</req:NJIISProviderID>
req:HL7MessageVersion2.5.1</req:HL7MessageVersion>
req:RequestHL7MessageMSH|^~&|NJDOCCentricity|9999|NJIIS|TESTCV19|2022042282440||VXU^V04^VXU_V04|NJDOCCentricity99992022042282440|T|2.5.1|||NE|AL|||||Z22^CDCPHINVS|PID|1||0000TESTC^^^9999^MR||TEST^TEST^^^^^L||19700606|M|||TEST WING-2 DOWN-BED 02 B^^NJ^NJ^00000^^L|||||||||||||||PD1||||||||||||Y|20211027|NK1|1|VARGAS^DAWN^^^L|OTH^SISTER IN LAW^HL70063|THOMPSON PL^^PARLIN^NJ^8859^^L|||||||ORC|RE||COVID-19^^^DOCCentricity|RXA|0|1|20211027||207^Moderna COVID-19 Vaccine^CVX|0.5|mL^^UCUM||00^New Immunization Record^NIP001|Brewer Arthur|^^^9999||||011F21A||MOD^Moderna US, Inc.^MVX|||CP|A|RXR|IM^^INTRAMUSCULAR^HL70162|RD^^RIGHT DELTOID^HL70163|OBX|1|CE|59780-7^Immunization Series Name^LN|10|850^COVID Vaccine Group^L||||||F|||||||ORC|RE||COVID-19^^^DOCCentricity|RXA|0|1|20211124||207^Moderna COVID-19 Vaccine^CVX|0.5|mL^^UCUM||00^New Immunization Record^NIP001|G KRAUS LPN|^^^9999||||011F21A||MOD^Moderna US, Inc.^MVX|||CP|A|RXR|IM^^INTRAMUSCULAR^HL70162|LA^^Left Upper Arm^HL70163|OBX|2|CE|59780-7^Immunization Series Name^LN|10|850^COVID Vaccine Group^L||||||F|||||||NTE||||</req:RequestHL7Message>
</req:PutRequest>
</req:NJIISIMSPutRequest>
</soap:Body>
</soap:Envelope>

[pacmano1]

This looks like it is going to New Jersey immunization information system (IIS).

Build your tmp message normally and then enclose it is CDATA tags. You don't need to escape anything.

[LanciaH]

Success, I think.
In Mirth we were escaping the destination, my co worker escaped the source and the message went through. But she thinks the data review will fail because the HL7 message not contains amp not &

See below.

<soapenv:Envelope xmlns:env="http:https://www.w3.org/2003/05/soap-envelope" xmlns:soapenv="http:https://www.w3.org/2003/05/soap-envelope">
env:Header/
<soapenv:Body xmlns:res="http:https://njiis.njdoh.gov/ims/service/schema/hl7/put/response">
res:NJIISIMSPutResponse
res:ResponseHeader

res:ServiceStatus
res:StatusCode200</res:StatusCode>
res:StatusMessageSuccess</res:StatusMessage>
</res:ServiceStatus>
</res:ResponseHeader>

res:PutResponse
res:TransactionIDPUTX9802041X20220425T121522713</res:TransactionID>
res:HL7MessageVersion2.5.1</res:HL7MessageVersion>
res:ResponseHL7MessageMSH|^~&amp;|NJIIS|NJDOH|

[pacmano1]

@LanciaH Format your code, your last post should look like this:

Success, I think.
In Mirth we were escaping the destination, my co worker escaped the source and the message went through. But she thinks the data review will fail because the HL7 message not contains amp not &

See below.

<soapenv:Envelope xmlns:env="http:https://www.w3.org/2003/05/soap-envelope" xmlns:soapenv="[http:https://www.w3.org/2003/05/soap-envelope">](http:https://www.w3.org/2003/05/soap-envelope%22%3E)
env:Header/
<soapenv:Body xmlns:res="[http:https://njiis.njdoh.gov/ims/service/schema/hl7/put/response">](http:https://njiis.njdoh.gov/ims/service/schema/hl7/put/response%22%3E)
res:NJIISIMSPutResponse
res:ResponseHeader

res:ServiceStatus
res:StatusCode200</res:StatusCode>
res:StatusMessageSuccess</res:StatusMessage>
</res:ServiceStatus>
</res:ResponseHeader>

res:PutResponse
res:TransactionIDPUTX9802041X20220425T121522713</res:TransactionID>
res:HL7MessageVersion2.5.1</res:HL7MessageVersion>
res:ResponseHL7MessageMSH|^~&amp;|NJIIS|NJDOH|

[tonygermano]

Almost like that, except that's not valid xml. There's a bunch of symbols missing.

[pacmano1]

Yes, true, lol. And I already mentioned above for immunization registries that @LanciaH can just send the HL7 in a CDATA tag. That seems to have been ignored as well :)

[LanciaH]

Hi,
I send part messages to hide patient info, Our next submission we are going to try the CDATA Tag, at least I think she will.

Thanks again for all the suggestions

[LanciaH]

To bring this post to a closure, my partner created a separate channel just to handle the web service part and so far it is working. She got the idea form a youtube post. Which leads to a different error.

We left the & symbol double escaped and our partner accepted the data, we still don't think its right but we have to move on.
tmp['MSH']['MSH.2']= "^~\&";

[tonygermano]

There are three different places escaping are happening, javascript strings, hl7 messages, and xml. In this statement tmp['MSH']['MSH.2']= "^~\&" it is the backslash that needs to be escaped like tmp['MSH']['MSH.2']= "^~\\&", as the backslash character is the escape character for javascript strings (as well as being in the position that specifies the escape character for your HL7 message.)

The escaped string will put the value ^~\& into MSH.2. When the ER7 HL7 message is converted to xml, the ampersand will automatically be escaped to & as that is a requirement of xml. Any proper xml library will take an element like <MSH.2>^~\&amp;</MSH.2> and unescape it back to ^~\& when extracting the text content from the element.

[LanciaH]

Thanks I'll share this with my partner.