You're missing one step. The SDA your DTL is producing is in the form of an XML vDOC (EnsLib.EDI.XML.Document) which is using the SDA schema. The SDA3.InboundProcess needs to receive an HS.Message.ECRUpdateRequest with the raw XML for the SDA stored in its contentstream property. To fix this, you can create a second DTL which takes the EnsLib.EDI.XML.Document as input and outputs an ECRUpdateRequest. In the DTL you'll just need to call the VDoc's method to generate the XML stream and then set ECRUpdateRequest.ContentStream to that stream.

This is absolutely possible. First, you'll want to use a SQL Business Operation rather than a Business Service. Your function will send a simple request message to the Business Operation containing any parameters you want to pass to the SP (if you only have one parameter you can use Ens.StringContainer). The Operation will execute the SP on SQL Server and return a response message to your function.

You didn't mention where you plan to call this function from (a DTL? a Business Process?). If it's a Business Process then you don't need a custom function, you can just use a "call" action to send the request to the Operation.

If you need to do this from a DTL, then in order to send a message to the Operation you'll need to call a method of the business process or router. You can get a reference to the process/router this way:

set bp=%Ensemble("%Process")

And then you can send your request message like this:

set tSC=bp.SendRequestSync("My.SQLServer.Business.Operation",req,.resp)

Vinay, the typical approach to send to CUPS for TrakCare would be to use Zen reports or JReports. TrakCare's EPS print server can run the report automatically and send the result to the configured printer through CUPs.

It's possible for methods to accept a variable number of arguments.  More details here.

SoapUI and Postman use HTTP to send requests. HL7 over TCP (MLLP) is not an HTTP-based protocol.

You can use a business operation as you mentioned, or there are some commonly used third-party tools for testing HL7 interfaces, such as Interface Explorer.

There's also a convenience function for this:

set origTime=$h
set newTime=$$HorologAddSecs^EnsUtil(origTime,60)

The first parameter is the time in $horolog format, the second parameter is the number of seconds to add. It returns the new time in $horolog format.

Hi Yuri, have a look at this online training course.

I think you just need to change your business rule so the first parameter you pass to CacheExists is wrapped in quotes:

CacheExists("osuwmc_Tecsys...",...)

There are several utilities available for converting XLSX to CSV. You could run the conversion using $ZF(-100) and then read the CSV using a RecordMap.

Here's one example:
https://csvkit.readthedocs.io/en/1.0.2/scripts/in2csv.html

Can you paste in the full class definition for ORMFARM.amplitudeHTTPRequest?

I want to get message body to parse it before insert

What kind of parsing and changes do you need to make to the message?

Can you provide some more details about what you're trying to do and what the process that you're trying to change looks like?

Here's an overview of productions and message flows. In most cases, you would add business logic using a Business Process. Here's a nice online course about developing Business Processes.

Sure. You're already extending %XML.Adaptor, which includes the methods XMLExportToStream and XMLExportToString.

The wkhtmltopdf website has an example of the command-line usage -- looks fairly simple.

And have a look at our product documentation for $ZF(-100) on how to execute an external program from ObjectScript.