Might want to look at https://openexchange.intersystems.com/package/IRIS-WHIZ---HL7v2-Browser-Extension-1
it allows to download the Search Results into a CSV. I have been using this to provide information to applications that have had me search for messages.
Stay Connected is set at 60, messages are sent to the BO in batches depending on when we receive the HL7 message that it requires a lookup.
Because this is going through a Java Gateway Business Service it seems like there is a disconnect on when the BO loses connection and pipe that it uses through the Java Gateway Business Service. The BO loses the connection, but the Java Gateway Business Service still thinks it is connected to the Database.
I have tried adding Connection Attributes to the BO, but it has not help.
Business Operation Settings
<ItemName="PatientBillingDBPoll"Category="PatientBilling,SQL,PROD,CC,VANW,PatFeeder"ClassName="osuwmc.PatientBilling.PatientBillingDBPollOperation"PoolSize="1"Enabled="true"Foreground="false"Comment="Is used to lookup items against clarity tables"LogTraceEvents="true"Schedule=""><SettingTarget="Adapter"Name="Credentials"></Setting><SettingTarget="Adapter"Name="DSN">MS-PatientBilling</Setting><SettingTarget="Adapter"Name="JGService">PatientBilling.JavaGateway</Setting><SettingTarget="Host"Name="FailureTimeout">20</Setting><SettingTarget="Host"Name="ReplyCodeActions">E=R</Setting><SettingTarget="Host"Name="AlertOnError">0</Setting><SettingTarget="Adapter"Name="StayConnected">60</Setting><SettingTarget="Adapter"Name="ConnectionAttributes">"queryTimeout = 30";"socketTimeout = 60";"cancelQueryTimeout = 45";"connectRetryCount = 100";"connectRetryInterval = 5"</Setting><SettingTarget="Host"Name="ArchiveIO">1</Setting></Item>Java Gateway Settings
<ItemName="PatientBilling.JavaGateway"Category="PROD"ClassName="EnsLib.JavaGateway.Service"PoolSize="1"Enabled="true"Foreground="false"Comment=""LogTraceEvents="true"Schedule=""><SettingTarget="Host"Name="Port">55558</Setting><SettingTarget="Host"Name="JavaHome">/usr</Setting><SettingTarget="Host"Name="Logfile"></Setting><SettingTarget="Host"Name="ClassPath">/nfs/data/drivers/java/*</Setting><SettingTarget="Host"Name="JVMArgs">-d64 -Xss512k -Xmx1024m -XX:+DisableExplicitGC -XX:+AggressiveOpts -XX:+ExplicitGCInvokesConcurrent -XX:+UseStringDeduplication -XX:MaxHeapFreeRatio=10 -XX:MinHeapFreeRatio=5</Setting></Item>Yes it was.
d ##class(EnsLib.HL7.SearchTable).BuildIndex()
d ##class(OSU.HL7.SearchTable).BuildIndex()
I have many examples of doing this, as we have Operations that write and read data from MS SQL using stored procedures.
You said your problem is with the email, how is the email defined within the Message Data Class?
Typically I create a Message Data Class for the Parameters of the Stored Procedure and use that Message Data Class to send to my EnsLib.SQL.OutboundAdapter which is using the Message Class to map to the Class Method that sends the Execution call to the Stored Procedure on MS SQL.
If you need more help, feel free to reach out.
When I had originally tried executing the POST request, it came back blank, but now it is coming back populated
Thanks, but when I try that I am getting nothing in return when I know the query should be returning something.
{
"status": {
"errors": [],
"summary": ""
},
"console": [],
"result": {}
}I don't believe I built it within that table. It is a simple table to reference Epic Department information that I query from Epic Clarity.
I just realized the Document I was looking at was for 2025.2 not 2025.1 that I am on. I think I will ahve to go down the route of building the API manually.
I found this information here... https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQLSRCH_rest#GSQLSRCH_rest_cmds
When I reformat the request to
{
"query": "SELECT ID, Name FROM osuwmc_Epic_Clarity.DepartmentMaster WHERE ID = 300000000",
"index": "IDKEY",
"option": 1,
"debug": true
}I am not getting any results back when I should be
I was never able to get this figured out. It happens because our Business Process sends to a Business Rule that is disabled and started from our cron.
We just make sure to go check for suspended messages after a fail-over.
Is there a way to make the file, pipe delimited vs comma delimited?
Even though the vendor is stating it, I don't think my name.list is SequenceOfHumanName
I was able to pull the Patient Resource out of the Bundle, but now I am still stuck on how to pull out the name.list..
.png)
Does anyone have any suggestions? %GetIterator() is not working just on target.name.list, I get a message that %GetIterator() does not exist.
Thanks
Scott
while writing to the screen works, I am trying to insert the Patient data into another data class to send back to an HL7 DTL so it can update the HL7 message. When I attempt that in a DTL where I extract the Bundle then send it to the Patient model it is not producing results.
.png)
I tried that however the zrwrite r4Patient.toString() didn't properly parse out the transaction
DEVCLIN>set patient = {"resourceType":"Bundle","type":"searchset","total":1,"link":[{"relation":"self","url":"https://ihismufhirnp.osumc.edu/fhir-poc/api/FHIR/R4/Patient?identifier=OSUMRN|415012765"}],"entry":[{"link":[{"relation":"self","url":"https://ihismufhirnp.osumc.edu/fhir-poc/api/FHIR/R4/Patient/efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3"}],"fullUrl":"https://ihismufhirnp.osumc.edu/fhir-poc/api/FHIR/R4/Patient/efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3","resource":{"resourceType":"Patient","id":"efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3","extension":[{"valueCodeableConcept":{"coding":[{"system":"urn:oid:1.2.840.114350.1.13.172.3.7.10.698084.130.768080.39128","code":"male","display":"male"}]},"url":"http://open.epic.com/FHIR/StructureDefinition/extension/legal-sex"},{"valueCodeableConcept":{"coding":[{"system":"urn:oid:1.2.840.114350.1.13.172.3.7.10.698084.130.768080.35144","code":"male","display":"male"}]},"url":"http://open.epic.com/FHIR/StructureDefinition/extension/sex-for-clinical-use"},{"extension":[{"valueCoding":{"system":"http://terminology.hl7.org/CodeSystem/v3-NullFlavor","code":"UNK","display":"Unknown"},"url":"ombCategory"},{"valueString":"Unknown","url":"text"}],"url":"http://hl7.org/fhir/us/core/StructureDefinition/us-core-race"},{"extension":[{"valueString":"Unknown","url":"text"}],"url":"http://hl7.org/fhir/us/core/StructureDefinition/us-core-ethnicity"},{"valueCode":"248153007","url":"http://hl7.org/fhir/us/core/StructureDefinition/us-core-sex"},{"valueCodeableConcept":{"coding":[{"system":"http://loinc.org","code":"LA29518-0","display":"he/him/his/his/himself"}]},"url":"http://open.epic.com/FHIR/StructureDefinition/extension/calculated-pronouns-to-use-for-text"}],"identifier":[{"use":"usual","type":{"text":"CEID"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.3.688884.100","value":"OSRDR3259GL4948"},{"use":"usual","type":{"text":"EPI"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.5.737384.0","value":"E4377"},{"use":"usual","type":{"text":"EXTERNAL"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.2.698084","value":"Z5151278"},{"use":"usual","type":{"text":"FHIR"},"system":"http://open.epic.com/FHIR/StructureDefinition/patient-dstu2-fhir-id","value":"TCPNfJueZx8Fjvm4g.lzD.vutNNRpQMfDXDRXJVlKkpcB"},{"use":"usual","type":{"text":"FHIR STU3"},"system":"http://open.epic.com/FHIR/StructureDefinition/patient-fhir-id","value":"efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3"},{"use":"usual","type":{"text":"INTERNAL"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.2.698084","value":" Z5151278"},{"use":"usual","type":{"text":"OSUMRN"},"system":"urn:oid:1.2.840.114350.1.13.172.2.7.5.737384.100","value":"415012765"},{"use":"usual","type":{"text":"WPRINTERNAL"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.2.878082","value":"2545814"}],"active":true,"name":[{"use":"official","text":"Case Stontest","family":"Stontest","given":["Case"]},{"use":"usual","text":"Case Stontest","family":"Stontest","given":["Case"]}],"gender":"male","birthDate":"1995-02-27","deceasedBoolean":false,"managingOrganization":{"reference":"Organization/eQi5EjSoIVOTHT0BXoZ4mNA3","display":"WILSON HEALTH"}},"search":{"mode":"match"}}]}
DEVCLIN>set r4Patient = ##class(HS.FHIRModel.R4.Patient).fromDao(patient)
DEVCLIN>zwrite r4Patient.toString()
"{""resourceType"":""Bundle"",""link"":[{}]}"
DEVCLIN>
I attempted that..
DEVCLIN>set patient = {"resourceType":"Bundle","type":"searchset","total":1,"link":[{"relation":"self","url":"https://ihismufhirnp.osumc.edu/fhir-poc/api/FHIR/R4/Patient?identifier=OSUMRN|415012765"}],"entry":[{"link":[{"relation":"self","url":"https://ihismufhirnp.osumc.edu/fhir-poc/api/FHIR/R4/Patient/efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3"}],"fullUrl":"https://ihismufhirnp.osumc.edu/fhir-poc/api/FHIR/R4/Patient/efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3","resource":{"resourceType":"Patient","id":"efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3","extension":[{"valueCodeableConcept":{"coding":[{"system":"urn:oid:1.2.840.114350.1.13.172.3.7.10.698084.130.768080.39128","code":"male","display":"male"}]},"url":"http://open.epic.com/FHIR/StructureDefinition/extension/legal-sex"},{"valueCodeableConcept":{"coding":[{"system":"urn:oid:1.2.840.114350.1.13.172.3.7.10.698084.130.768080.35144","code":"male","display":"male"}]},"url":"http://open.epic.com/FHIR/StructureDefinition/extension/sex-for-clinical-use"},{"extension":[{"valueCoding":{"system":"http://terminology.hl7.org/CodeSystem/v3-NullFlavor","code":"UNK","display":"Unknown"},"url":"ombCategory"},{"valueString":"Unknown","url":"text"}],"url":"http://hl7.org/fhir/us/core/StructureDefinition/us-core-race"},{"extension":[{"valueString":"Unknown","url":"text"}],"url":"http://hl7.org/fhir/us/core/StructureDefinition/us-core-ethnicity"},{"valueCode":"248153007","url":"http://hl7.org/fhir/us/core/StructureDefinition/us-core-sex"},{"valueCodeableConcept":{"coding":[{"system":"http://loinc.org","code":"LA29518-0","display":"he/him/his/his/himself"}]},"url":"http://open.epic.com/FHIR/StructureDefinition/extension/calculated-pronouns-to-use-for-text"}],"identifier":[{"use":"usual","type":{"text":"CEID"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.3.688884.100","value":"OSRDR3259GL4948"},{"use":"usual","type":{"text":"EPI"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.5.737384.0","value":"E4377"},{"use":"usual","type":{"text":"EXTERNAL"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.2.698084","value":"Z5151278"},{"use":"usual","type":{"text":"FHIR"},"system":"http://open.epic.com/FHIR/StructureDefinition/patient-dstu2-fhir-id","value":"TCPNfJueZx8Fjvm4g.lzD.vutNNRpQMfDXDRXJVlKkpcB"},{"use":"usual","type":{"text":"FHIR STU3"},"system":"http://open.epic.com/FHIR/StructureDefinition/patient-fhir-id","value":"efz6cSnh6If5cehlzObXZuO7BwSc77oXLYSL-92FLdec3"},{"use":"usual","type":{"text":"INTERNAL"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.2.698084","value":" Z5151278"},{"use":"usual","type":{"text":"OSUMRN"},"system":"urn:oid:1.2.840.114350.1.13.172.2.7.5.737384.100","value":"415012765"},{"use":"usual","type":{"text":"WPRINTERNAL"},"system":"urn:oid:1.2.840.114350.1.13.172.3.7.2.878082","value":"2545814"}],"active":true,"name":[{"use":"official","text":"Case Stontest","family":"Stontest","given":["Case"]},{"use":"usual","text":"Case Stontest","family":"Stontest","given":["Case"]}],"gender":"male","birthDate":"1995-02-27","deceasedBoolean":false,"managingOrganization":{"reference":"Organization/eQi5EjSoIVOTHT0BXoZ4mNA3","display":"WILSON HEALTH"}},"search":{"mode":"match"}}]}
DEVCLIN>set r4Patient = ##class(HS.FHIRModel.R4.Patient).fromDao(patient)
DEVCLIN>zwrite r4Patient.toString()
"{""resourceType"":""Bundle"",""link"":[{}]}"
DEVCLIN>
Found that the FHIR R4 Patient Resource that I was receiving from my EMR did not follow the Model R4 Patient Resource, so once the fromDao tries to transform the JSON it does not map correctly to the model R4 Patient.
I did not have any luck with either option within the DTL editor..
.png)
<INVALID OREF>Transform+16^osuwmc.Epic.FHIR.DTL.ResponsePatientSearch.1 -- logged as '-' number - @' set iter = target.name.list.%GetIterator()'
What I am trying to do is take the R4.PatientResponse and return it into a Data Class Structure format for those that are within my Team who can't read FHIR response or know how to code around it to use to update an HL7 message.
I tried taking the R4.PatientResponse and transforming it into a Record Map data class structure without success.
How would I iterate through the string result to parse the family and given name...
{"use":"official","text":"Archie Obrotest","family":"Obrotest","given":["Archie"]}I was a part of a presentation at #Ready2025 very similar to what you are looking for. At Ready 2025, I worked with @John Goodgame , @Justin Owens, @Julio Rodriguez to present a Change Control Audit (Stealth Control) in which a task queries for changes and inserts the data into SQL tables that could be alerted or queried on.
When it is posted look for a session named...Partnering for Success Collaborative Innovations in Interoperability
@John Goodgame is talking with Product to see if this could be included, or might be publishing the code somewhere for others to use.
Not as many as I hoped... Six
This is how i solved the issue
Set tSC = pRequest.NewResponse(.tResponse) Quit:$$$ISERR(tSC) tSC
Set tResponse.encodedMessage = $get(encodedMessage)
set dMsg = $SYSTEM.Encryption.Base64Decode(tResponse.encodedMessage)
set pResponse = ##class(EnsLib.HL7.Message).%New()
set pResponse = ##class(EnsLib.HL7.Message).ImportFromString($Get(dMsg))
set pResponse.DocType = ##class(EnsLib.HL7.Schema).ResolveSchemaTypeToDocType(pResponse.TypeVersion,pResponse.Name)This is how I solved the issue...
Set tSC = pRequest.NewResponse(.tResponse) Quit:$$$ISERR(tSC) tSC
Set tResponse.encodedMessage = $get(encodedMessage)
set dMsg = $SYSTEM.Encryption.Base64Decode(tResponse.encodedMessage)
set pResponse = ##class(EnsLib.HL7.Message).%New()
set pResponse = ##class(EnsLib.HL7.Message).ImportFromString($Get(dMsg))
set pResponse.DocType = ##class(EnsLib.HL7.Schema).ResolveSchemaTypeToDocType(pResponse.TypeVersion,pResponse.Name)How would I do nested iterations if I need to get something from say example "external Positions"
"externalPositions": [
{
"pureId": 0,
"appointment": {
"uri": "string",
"term": {
"en_GB": "Some text"
}
},
"appointmentString": {
"en_GB": "Some text"
},
"period": {
"startDate": {
"year": 0,
"month": 1,
"day": 1
},
"endDate": {
"year": 0,
"month": 1,
"day": 1
}
},Does ImportFromString automatically Decode Base64 HL7 messages?
Not sure I am following, the idea was to take the HL7 message, encode it, and put it into the osuwmc.Nutrition.OSU.CBOARDNetMenuRequest.SendMessageRequest as the encodedMessage. Using the osuwmc.Nutrition.OSU.CBOARDNetMenuRequest.SendMessageRequest to pass to the Web Service Class to send outbound to the vendor.
The two Parenthesis was a typo, and I was using the $Get(a) to dereference the %Stream to a string for the osuwmc.Nutrition.OSU.CBOARDNetMenuRequest.SendMessageRequest.
The Soap wizard created the osuwmc.Nutrition.OSU.CBOARDNetMenuRequest.SendMessageRequest as the vendor requires a key value and encoded message in the body of the soap request.