Question Krishnaveni Kapu · Nov 20, 2024 Reading values from JSON Hi , I receive below JSON from a https outbound operation { "Link": "www.sample.com", "Practice": [ { "Node": "Record1" } ]} I am able to read Link as - JSON.%Get("Link") How can I read Node value ? #Ensemble 0 2 0 82
Question Krishnaveni Kapu · Sep 26, 2024 CHARSET options for the FTP outbound adapter Hi , I am sending my DTL response (which is an xml stream) to an FTP out location. My XML stream has CRLF , but after sending FTP'ing out , it displays as LF before writing it to FTP At FTP out location What Chatset will do it ? Currently Charset is set as Binary. Appreciate quick response. #Ensemble 0 3 0 64
Question Krishnaveni Kapu · Sep 23, 2024 Large Stream to base64Encoded I have below method , which receives a PDF ; this method throws error for a PDF file of 3MB size <MAXSTRING>zBase64Encode+9 -- logged as '-' number - @' set encodedData = $system.Encryption.Base64Encode(content)' How do I fix this. ---------------- #Ensemble 0 2 0 133
Question Krishnaveni Kapu · Sep 21, 2024 fileName in an FTP out Hi All , I would like to add session ID to the fileName in an FTP out pass thru business operation.How can I do that ? <Setting Target="Host" Name="Filename">SessionID_%f_%Q.txt</Setting> #Ensemble 0 2 0 88
Question Krishnaveni Kapu · Sep 20, 2024 xml attribute in double quotes I am converting a HL7 msg to xml and one of the field is as below - DTL = <assign value='"Message"' property='target.{req.ID.scope}' action='set' /> DTL response = <ID scope='Message'>3</ID> my xsd has -<xsd:element name="ID"><xsd:complexType><xsd:sequence><xsd:element name="SimpleContent" minOccurs="0"/></xsd:sequence><xsd:attribute name="scope"/></xsd:complexType></xsd:element> #Ensemble 0 4 0 73
Question Krishnaveni Kapu · Sep 16, 2024 padding zeros to the desired length I receive a number as input length = ln = 7 if input = 25I need to add zeros to make make it as - 0000025 (a total length of ln) if input = 9I need to add zeros to make make it as - 0000009 (a total length ofln) #Ensemble 1 6 0 150
Question Krishnaveni Kapu · Sep 13, 2024 ..AppendTimestamp in FTP ..AppendTimestamp in FTP what are the different values that can be passed to ..AppendTimestamp in FTP ?Can we pass dynamic values to it ? if so how can we do that ? #Ensemble 0 1 0 63
Question Krishnaveni Kapu · Sep 11, 2024 SQL query to get multiple records I have an SQL table as below (columns - ID and Value) I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID as - if ID = 11 ; QRY output = aaa,bbb if ID = 22 ; QRY output = xxx,yyy,zzz can someone help me with query ID Value----------11 aaa22 xxx22 yyy11 bbb22 zzz----------- #Ensemble 0 2 0 93
Question Krishnaveni Kapu · Sep 3, 2024 $ZDATETIME($h,3,1,3) Hi, I am using this "$ZDATETIME($h,3,1,3)" and getting response as 2024-09-03 12:07:45.000But I need proper values at the end instead of zeros (000) Something like below -2024-09-03 12:07:45.658 #Ensemble 1 6 0 170
Question Krishnaveni Kapu · Aug 23, 2024 String to HL7 format I have a requirement where in I had to read a HL7 message string ( which is a String )from a SQL TBL to my Business Service.and I need to convert that string to EnsLib.HL7.Message format and traverse through the PID segment. I need some inputs please. #Business Service #HL7 #HealthShare #InterSystems IRIS for Health #Ensemble #Health Connect 0 1 1 107
Question Krishnaveni Kapu · Aug 7, 2024 DateTimeDifference in seconds Hi All , I have a dateTime in the format = "2024-08-07 17:58:51.563"I need the difference between current date time and above one I need it in seconds. #Ensemble 0 5 0 120
Question Krishnaveni Kapu · Jul 4, 2024 Convert 2024-07-04 13:21:16.477 to 20240704132116 How can I convert From = 2024-07-04 13:21:16.477 To = 20240704132116 #Ensemble 1 3 1 92
Question Krishnaveni Kapu · Jun 17, 2024 xml object to stream I receive request xml object as pRequest = <getURL><Url1><![CDATA[https://test/cs/icdfg?&RevisionSelectionMethod=LatestReleased&allowInter...</getURL> I need to send this to a stream Set XmlStream = ##class(%Stream.GlobalCharacter).%New() // how do I send my pRequest into XmlStream ?? Do httpRequest.EntityBody.CopyFrom(XmlStream) #Ensemble 0 5 0 143
Question Krishnaveni Kapu · Jun 13, 2024 DateTime from yyyy-mm-dd hh:mm:ss.000 to yyyymmdd how do I convert DateTime from yyyy-mm-dd hh:mm:ss.000 to yyyymmdd #Ensemble 0 5 0 203
Question Krishnaveni Kapu · Jun 6, 2024 DateTime from yyyy-mm-dd hh:mm:ss.000 to ISO 8601 UTC I receive a time stamp as = 1988-08-18 00:00:00.000I need this to be converted as - 1988-08-18T00:00:00+01:00 #Ensemble 0 1 0 79
Question Krishnaveni Kapu · Jun 4, 2024 Business process terminating Hi , I receive xml as incoming request , I convert that into HL7 in my business process class as below Set tSC = $CLASSMETHOD("myDTL","Transform", .pRequest,.dtlRes) then , I am sending the dtlRes which is a HL7 message to a router "TEST_ROUTER" in the router , I am checking for HL7.{MSH:9.2} , where I am getting below error : #Ensemble 0 5 0 123
Question Krishnaveni Kapu · Jun 3, 2024 datetime in format - yyyymmddhhmmss I receive dateTime in this format - yyyy-mm-ddThh:mm:ss+01:00 for ex : 2024-05-31T17:33:08+01:00I wanted it to convert to yyyymmddhhmmss desired output = 20240531173308 #Ensemble 0 3 0 187
Question Krishnaveni Kapu · May 23, 2024 Sending FHIR bundle object to a router failing I would like to send bundle object to a router and then perform a DTL with in the routing rule ( this BundleObject as a source to my DTL). during this process , I get below exception reqStream = json content in a stream Set BundleObject=##class(HS.FHIR.DTL.vR4.Model.Resource.Bundle).FromJSON(reqStream,"vR4") Set tSC = BusinessService.SendRequestSync("SAMPLE_ROUTER", BundleObj) expection : #Ensemble 0 3 0 87
Question Krishnaveni Kapu · May 13, 2024 Issue in generating Double quotes for a property in Json Stream. Hello Community, I have below issue - I have an ID with 123456.(ID as a dynamic value coming from request message) I wanted it to be displayed as "123456" in Json Stream. Code Example: set object = ##class(%ZEN.proxyObject).%New() set object.ID = ID set x = ##class(%ZEN.Auxiliary.jsonArrayProvider).%WriteJSONStreamFromObject(.json,object) Case:1ID : 123456 Will output: { "ID": 123456 } but I need : { "ID": "123456" } #Ensemble 0 3 0 126
Question Krishnaveni Kapu · Apr 26, 2024 How to read XML data in a routing rule I am receiving an XML input to my router and in the routing rule I need to traverse through the xml data , apply a for loop and fetch data. How can I do that ? Input : #Business Rules #XML #Ensemble #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 3 0 148