Your would use JMeter to launch multiple calls in a row. 

Do you mean the populate library?

https://docs.intersystems.com/csp/docbook/Doc.View.cls?FIND=CLASSES+%25L...

You can take a look to this article and the associated Open Exchange application: https://community.intersystems.com/post/creating-rest-service-iris

Are you using an aggregate function in your query? You can see in the documentation that %SQLCODE = 0 is returned for queries with aggregates as SUM or AVG because it's returning a row even with a null value of the aggregation function.

It's true! Thank you @David Hockenbroch , I didn't realize that it was deprecated.

for x=1:1:rs.%ResultColumnCount{
     //Get the value of each column
         set colValue = rs.%GetData(x)
         //Get the name of each column
         set colName = cols.GetAt(x).colName
         set colType = rs.GetColumnType(x)

Have you tried this code?

Yes, the i is the number of the column.

You can use the method GetColumnType, here is the url to the official documentation: https://docs.intersystems.com/iris20231/csp/documatic/%25CSP.Documatic.cls?LIBRARY=%25SYS&CLASSNAME=%25Library.ResultSet#GetColumnType

If you want something low-code you can create a Data Transformation with a HL7 message as source and as destination a class created ad-hoc with the structure that you need. Take a look to this example:

The destination in a class called RestTest.FirstRestObject with this definition:

Class RestTest.FirstRestObject Extends (%Persistent, %JSON.Adaptor, Ens.Util.MessageBodyMethods, Ens.Request)
{

/// Description
Property Name As %String;
/// Description
Property LastName As %String;
Property Childs As list Of NestedRestObject;
}

This object has an SQL representation wich you could use later for your analysis:

What do you mean with "API Automation"? API management?

Cool!

Thanks a lot!!!

Hi Yone!

Take a look at the XSLT transformations:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

You can extract and format information from the XML 

Really helpful Muhammad! I'll use it to introduce it to our customers.

I would try to export all the classes of the production and import it into a new namespace. After that try to open a DTL and check if it works. If there is no error the problem would be a corruption in the original namespace.