Can documentation be expanded to include information about SQL search. I always forget&rediscover where things are and especially how they are related

Do not forget to mark answer as accepted.

Check UserAction method of %Studio.Extension.Base class. You can call CSP pages from there.

Use %ZEN.Auxiliary.JSONProvider class.

SQLCODE=100

would be a codepath for no data.

It's a valid sample. You just can't write directly into ZEN context. Well, you can, obviously, but that causes errors.

Where exactly in samples?

Try commenting out all write statements in sqlTest method.

You can use RESTForms. It supplies converting object-to-JSON and JSON-to-object.

1. https certificate would apply to the cache and csp sites defined under IIS.  It would apply  to everyrhing really.

2. Not sure about html landing page being a security threat. That depends on your setup. Do you embed http parts in your (future) https pages?

I'd recommend as a first step to install let's encrypt certificate - it's free and easy.

Then force http->https redirect on your iis server.

After that check how your html landing page behaves.

I'm not raising exceptions, but rather do logging. Here's the article.

Thank you! That's very useful.

Is there a way to return real implementation class?

For example, consider these classes:

Class App.Use {

ClassMethod Test()
{
    w 1/0
}
}

and:

Class App.Use2 Extends App.Use
{
}

If I call:

do ##class(App.Use2).Test()

I get  the following CLS source line:

App.Use2:Test+1

Yet, the relevant code is actually implemented in

App.Use:Test+1

One approach I see is checking %Dictionary.MethodDefinition recursively till I find a method definition, but there's bound to be many problems multiple inheritance.

I don't understand your question. Please elaborate on the following points:

1. Do you want to create arbitrary relationships programmatically at design time (possible) or at runtime (not really)?
2. What difficulties in managing relationships you have encountered?
3. Can you provide some mock code demonstrating what you want to achieve?

Documentation.

Use TO_DATE SQL function.