Hello.

Can you please publish it as a GitHub repository?

Unfortunately there is no such thing. Would be great to have this feature. Currently in my projects I manually write all possible paths, for example here.

Jobbed process runs independently of parent process.

Killing a  parent does not kill its children.

That said, you can use events for interprocess communication.

Hello.

While there is currently no way to it, you can see %DeepSee.UI.MDXExcel class, which does excel export and write your own csv exporter. It would be a simplified copy of %DeepSee.UI.MDXExcel.

All output is done via &html so you need to replace that with the usual write.

You can use %SerialObject for that:

Class Utils.Serial Extends %SerialObject
{

Property Payload As %String;

/// zw ##class(Utils.Serial).Test()
ClassMethod Test(input As %String = {$lb(1,2,3,",",5)}) As %String
{
    
    set obj = ##class(Utils.Serial).%New()
    set obj.Payload = input
    do obj.%SerializeObject(.str)
    kill (str)
    
    set obj = ##class(Utils.Serial).%Open(str)
    return obj.Payload
}
}

For example:

zw ##class(Utils.Serial).Test("1,2,3,,,5")
>"1,2,3,,,5"

zw ##class(Utils.Serial).Test($lb(1,2,3,",",5))
>$lb(1,2,3,",",5)

Q1:

1. JS client sends URL encoded string automatically or almost automatically (most frameworks do URL encoding for any URL)

2. In your broker override OnPreDispatch method and unescape pURL with:

set pURL = $ZCONVERT($ZCONVERT(pURL,"I","URL") ,"I","UTF8")

Q2: It is against core REST architecture principles, so I hope not.

Why do you need MDX expression as a query string, through?

If you're okay with /api/deepsee as it is - use it.

If, however, you want to change some settings (auth methods for one), then it's better to define your own application, since your changes may be lost during system update.

 s array = []
 While (result.Next()) {
     s object = {}
     s object.data = {}

     s object.data.id = result.Data("ID")
     s object.data.reg = result.Data("Registration")
     s object.data.snNum = result.Data("SatNavVehNumber")
     do array.$push(object)
     }
  w !!,array.$toJSON()

This should produce the desired output.

Some comments on code.

• rename fileToImport to mysqldumpFile
• remove 2 references to other classes

That said, it does not work on my sql script on the table creation part, despite throwing no errors (data insert throws an error -  Table not found, but previous  statement which creates the table seems to run okay, but the table does not get created)

UPD: Reread your post, only INSERT, ok.

Documentation, Measures That Refer to Other Cells. There is an example in Samples which shows how to implement 'relative' measure: "Pareto Chart for Category" dashboard.