When encountering errors with XSLT I usually try to execute it here to check that it is valid and produces correct result.

As you're trying to use XSLT2 package, have you tried XSLT package?

Have you tried XSLT without callback?

You can mark correct answer by pressing a checkmark left of the answer.

If you want to run Ensemble REST Services, here's how.

Check REST.DocServer class in SAMPLES namespace.

Have you read documentation?

What do you want to achieve?

Use scrollable resultset.

Process memory is allocated as required, so decreasing $ZSTORAGE would not decrease actual memory usage.

Compare Angular results with REST API debugger, such as Postman and debug proxy, i.e. Charles.

Add these lines at the beginning of your REST method if you're on older versions (pre 16.1 I think):

Set %response.CharSet = "utf-8"
Set %response.ContentType="application/json"

If you're on a newer version add class params to your broker class:

Parameter CHARSET = "utf-8";
Parameter CONTENTTYPE = "application/json";

For HTML files:

• Move them to another non-web-app folder
• Convert them all to utf-8
• Execute in a terminal: set ^%SYS("CSP","DefaultFileCharset")="utf-8"
• Move them back

see weird characters on a query to the DB

REST output or input REST params? What locale are you using for server?

%occOID.inc defines macros to use for work with oid:

set id = $$$oidPrimary(oid)
set class = $$$oidClassName(oid)
set global = $$$oidSysAd1(oid) // streams only
set oid = $$$idCurrent //get current object oid

Please provide code sample.

Filename is appended to directory, so if you have a directory: /tmp/ you can call

set tSC = ..Adapter.PutString("old/plan.txt",output)
set tSC = ..Adapter.PutString("new/plan.txt",output)

and it should produce two files /tmp/old/plan.txt and /tmp/new/plan.txt in two different subdirectories. of /tmp

The benefits of using list of %String  over just %String are:

• You can easily index individual values
• You can project and access values as a separate table

I actually had a use case for exactly this data. Requirements were:

• There are alerts and users
• Alerts are sent once an hour
• Each alert is sent to multiple users
• Each user should receive only one digest email with all relevant alerts

List of %String was extremely useful in this case. First I wrote a temp table:

/// Store alerts (for current process and runtime-only)
Class Util.Alert Extends %Persistent
{

/// Alert topic
Property topic As %String(MAXLEN = 1000) [ Required ];

/// Alert text
Property text As %String(MAXLEN = "");

/// Recipients
Property emails As list Of %String(SQLPROJECTION = "table/column", STORAGEDEFAULT = "array");

/// Index
Index emailsIndex On emails(ELEMENTS);

/// Add one Alert
/// w ##class(Util.Alert).add("Error", $lb("1@1.com","2@2.com"), "text")
ClassMethod add(topic As %String, text As %String, emails As %List) As %Status
{
    set obj = ..%New()
    set obj.topic = topic
    set obj.text = text
    
    if $listvalid(emails) {
        for i=1:1:$ll(emails){
            do obj.emails.Insert($lg(emails,i))
        }
    }
    return obj.%Save()
}

}

Next I wrote a business service which searched for alerts and added them to this table (not relevant for this discussion). And then once all alerts for an hour are in the Util.Alert table, sendEmails method can easily send alerts in digest mode:

/// Generate emails from alerts and send them
ClassMethod sendEmails()
{
    &sql(DECLARE C1 CURSOR FOR
         SELECT DISTINCT emails  
         INTO :email
         FROM Util.Alert
    )
 
    &sql(OPEN C1)
    &sql(FETCH C1)

    While (SQLCODE = 0) {
        set text = ..generateEmailText(email)
        do ..SendEmail(email, text)
        &sql(FETCH C1)
    }
    &sql(CLOSE C1)
}

/// Create email with all alerts for user
ClassMethod generateEmailText(email As %String) As %String
{
    set emailText = ""
    &sql(DECLARE C2 CURSOR FOR
         SELECT topic, text  
         INTO :topic, :text
         FROM Util.Alert
         WHERE FOR SOME %ELEMENT(emails) (%VALUE=:email)
    )

    &sql(OPEN C2)
    &sql(FETCH C2)

    While (SQLCODE = 0) {        
        set emailText = emailText _  topic _ ": " _ text _ $$$NL
         &sql(FETCH C2)
    }
    &sql(CLOSE C2)
    
    return emailText
}

Without list of %String SQL here would be far harder to write or slower.