Requirement: Transform source XML message to target JSON.

step1: First create json equivalent xml from any online tool.

step2: use add in  studio utility create persistent classes from json equivalent xml and compile it , now target persistent classes are ready

step3: Do the above step for source xml or xsd and generate persistent classes for source and compile it

step4: complete the DTL by selecting root node from source, target persistent classes and complete the mappings and compile it

step5: use the below code to apply Transformation on source XML string and create Target JSON

Assume

Did you catch an Experience Lab at the 2021 Virtual Summit? Head over to the InterSystems Learning site to access all four of these hands-on exercises, and get up to speed on:

Hey Community, 

Learn about the changes we've made to InterSystems IRIS Containers, including security updates and the new web gateway container:

⏯ InterSystems IRIS Container Updates

Sometimes it is necessary to transfer or migrate data and data schema from Postgres to IRIS. There are currently a few options for doing this, but the two most popular options are using DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway. The first will be demonstrated in this article and the second is presented in an excellent article by Robert Cemper, DB Migration using SQLgateway (https://community.intersystems.com/post/db-migration-using-sqlgateway), see in this article how to perform this migration using DBeaver:

Get the sample data to the migration process

In

Astronomers’ tools

5 years ago, on December 19, 2013, the ESA launched an orbital telescope called Gaia. Learn more about the Gaia mission on the official website of the European Space Agency or in the article by Vitaly Egorov (Billion pixels for a billion stars).

However, few people know what technology the agency chose for storing and processing the data collected by Gaia. Two years before the launch, in 2011, the developers were considering a number of candidates (see “Astrostatistics and Data Mining” by Luis Manuel Sarro, Laurent Eyer, William O’Mullane, Joris De Ridder, pp. 111-112):

• IBM DB2,
• PostgreSQL,
• Apache Hadoop,
• Apache Cassandra and
• InterSystems Caché (to be more precise, the Caché eXTreme Event Persistence technology).

Comparing the technologies side-by-side produced the following results (source):

The first four will probably sound familiar even to schoolchildren. But what is Caché XEP?

Hi Community,

Welcome to the first InterSystems Spanish technical article writing competition! Write an article in Spanish on any topic related to InterSystems technology:

🏆 1st Spanish Tech Article Contest 🏆

Duration: February 1-28, 2022

Prizes for everyone: Everyone who publishes an article on Spanish Dev Community during this period will receive a special prize pack!

Main prize: Apple iPad

I want an example that converts CDA to FHIR R4.

Need Full production pipelines like service, process, and operations.

I'm using this Dockerfile to build .Net Gateway with my PEX BS. It works fine. If I change the image reference here to store/intersystems/iris-community:2021.2.0.617.0 in line 8 (so update from 2020.2 to 2021.2) it fails to build with:

KafkaConsumer.cs(4,20): error CS0234: The type or namespace name 'EnsLib' does not exist in the namespace 'InterSystems' (are you missing an assembly reference?) [/source/KafkaConsumer.csproj]

KafkaConsumer.cs(9,34): error CS0246: The type or namespace name 'BusinessService' could not be found (are you missing a using directive or an assembly reference?) [/s

Hi Community,

I have created persistent classes for source, target XSDs and completed DTL. When I tested in DTL window by passing source xml it is generating below target xml as result.

DTL result:

<root>
  <CaptureSource>2</CaptureSource>
  <Document>
    <Description>1235@TEST.COM.Message.ReportType</Description>
    <EventDate>1489@TEST.COM.Message.EventDateZ</EventDate>
    <ExternalSystemId>1213@TEST.COM.Message.ReportID</ExternalSystemId>
    <FileContent>1142@TEST.COM.Message.TextBlock</FileContent>
  </Document>
</root>
 

Here I am expecting value of source xml , but it is showing reference

Hello everyone,

I am having a challenge with the IRIS community version in Docker with wsl2. Host machine is Win 11 and the IRIS/Ubuntu image is Ubuntu-20.04 from running 'wsl -l -v.

I am not able to reach the WebPortal in IRIS nor the Super User port. docker ps -a = containers.intersystems.com/intersystems/iris-community:2021.1.0.215.3   "/tini -- /iris-main"   3 weeks ago   Up 26 hours (healthy)   0.0.0.0:1972->1972/tcp, 2188/tcp, 53773/tcp, 0.0.0.0:52773->52773/tcp, 54773/tcp   iris

Now, I was under the impression that the ports forwarded through the Host to the Image so I should be able

I am looking for a way to find all properties defined in any given class through coding, including those inherited from parent class(s). In case of inherited properties, I would like to know from which class etc.

A related question: XML adaptor provides a way to export xml schema for a class. Is there a similar method for JSON adaptor to generate a JSON schema for a class?

Thanks in advance for your help.

Hello Community,

to return data from the OnPage() method of a %CSP.Page I used to simply write out the value of a %DynamicArray e.g. via

write tResponse.%ToJSON()

and return $$$OK afterwards.

Large objects bigger than 4MB result in an exception when trying to create return values using this way. What is best practice for returning values as JSON, especially if values exceeding the capcity of the %String class are to be expected? I saw that it is possible to write data to a file with e.g.:

set tmp = tResponse.%ToJSON("/opt/home/tmp/test_stream.txt")

Am I supposed to do this and afterwa

When I installed the IRIS 2021.2 Community Edition, I found some Globals, which seem to be set for the Intersystems Ensemble and DeepSee products. For me that is an annoying design error in those products and only confusing my developers.

As I do not want to use these, I tried to delete them, because they interfere in the list of globals mixed with our own Globals.

But for several of the EnsEdi Globals I get an error message telling me, they can't be deleted, because they are wrong.

Is there a way to get rid of them? Or do I have to wait for a new IRIS version?

We are using the out-of-the-box  IHE components to exchange CCDs with an external system. A requirement to audit the outbound CCDs has arisen.

Is there an existing report that will show these ? If not, how can we audit these?

Thank you for reading

Hi Guys,

I've set DEFAULTMODE ="xlsx" in my report to be exported to Excel but it's exporting as .zip, is there something I need to add or set or maybe MS Excel to be installed in the server?

Thanks 

We are running HealthShare on Linux Redhat via Azure.

A couple of days ago, the Azure server rebooted. Which we were unaware of. 

Resulting in the Instance being in a downed status.

In the short term I put together a quick script to check the status, if it is down to restart it.

However, before I go down that road, I thought it would be best to inquire if there is a much better and more streamlined solution?

In a nutshell I just want to check and see if the Instance is up or in a state such as  down or hung then start it.

I attached my spaghetti code, full disclosure I am not a scripting

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Datasets contest!

You'll have an opportunity to have a discussion with InterSystems Product Managers on new LOAD DATA functionality, Q&A on datasets, etc. Our winners' demo included!  

Date & Time: Thursday, January 20, 2022 – 11:00 EDT

Hey Community,

We're pleased to welcome @Weidong Li as our new Moderator on the Developer Community in Chinese!

Let's greet Weidong Li with big applause and take a closer look at his bio!

Is there any recommended KPI's we should be using to monitor our IRIS configurations in Azure?

I started some development with the IRIS 2020.4 version and did not continue it for some months.

Now I just wanted to continue, but saw the license is not valid anymore.

Is there still a possibility to upgrade to 2021.2 community edition and to recover the globals from the old edition without having a valid license key?

How to execute it from the command line? I am able to use SQL in Management Portal, but I need to do it in Unix 

 select * from Ens_Util.Log where ConfigName='SFTPTo.HQ.SAFETRACE.DFT' AND Text LIKE '%Put Stream%' and TimeLogged LIKE '%2021-10-16%'

I have a user value set for an HL7 component that was removed from the source message.  How can I pull that value for use in a Routing Rule suppression logic?  Or do I have to create a custom class in order to do so?

Hi Developers,

I have created SOAP webservice , did not mentioned any security. Configured business service.

When I try to invoke from soaup UI, getting below error.

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-sece…">
   <SOAP-ENV:Body>
      <SOAP-ENV:Fault>
         <faultcode>wsse:FailedAuthentication</faultcode>
         <faultstring>The security token could not be authentica

Hi,

We a currently looking at a way of securing any future REST API's using OAuth2, where the Authorisation Server (OAuth2) and Resource Server would be on the same server.

However, as we have mirrored environment the Resource Server, and therefore the Authorisation Server, need work with a Virtual IP Address and be able to failover to either of the mirror member servers.

Is that possible with OAuth2 and if so what are the best practices for this?

Any advise or guidance much appreciated.

Thank you.

Hey Developers,

Watch as the presenter uses IKO to deploy the WebGateway, SAM, and InterSystems API Manager with the latest version of the InterSystems Kubernetes Operator: 

⏯ IKO: The InterSystems Kubernetes Operator (Version 3.0)

Hey Developers,

It's time to announce the winners of the InterSystems Datasets contest! Are you ready?

A storm of applause goes to these developers and their applications:

Hi Guys,

I was testing the Zen report from Samples namespace ( ZENReports.PageLayouts) by changing the DEFAULTMODE  from PDF to xlsx and html and noticed that each time I get different output and fields! I thought that the output should be the same and the only difference would be the report format, or am I missing something? try yourself and you will see.

Thanks

HealthShare Unified Care Record Overview  January 26-27, 2022   9:00am-5:00 US-Eastern Time (EST)

• This a live instructor-led interactive virtual training.
• The HealthShare Unified Care Record Overview course is a great way for HealthShare Customers, Partners and InterSystems Employees to become familiar with Unified Care Record, but especially those who need to understand its capabilities but not how to configure HealthShare Unified Care Record.
• This is a non-technical, instructor-led virtual training course providing a comprehensive introduction to HealthShare Unified Care Record.
• This c

Hi all,

I am testing asynchronous Bulk Data retrieve with a large EHR vendor. When I retrieve the bulk data, they are returning ndjson (CONTENT-TYPE of "application/fhir+ndjson; charset=utf-8"). If I attempt to process that content using JSON functions - I get

ERROR #5035: General exception Name 'Parsing error' Code '3' Data ''

For example, the following generates the error

s objArray={}.%FromJSON(quickStreamOut)

The error makes sense in that ndjson is not a valid json format (I assume at least).

But how then should ndjson be parsed in COS? I was going to use $listfromstring with a newline

How can we strip a non-breaking space (hexadecimal code "C2A0")?

The other spaces like $c(9) and $c(20) should not be stripped along with that.