I had that feeling that it might be more.
And took a look to ##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject() as it is visible.
It's nothing I would like nor to touch nor ever to maintain over future releases in parallel to ISC.
Following your code example, this might be the quickest workaround
Not to pretty but useful.
very short:
.NET binding in Caché projects Caché Object classes to .NET with properties and methods
and services them with a private protocol. It is dependent on synchronized objects at both ends.
you may know this picture:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GBMP_intro
A RESTful API does something total different.
You define request (for data or actions) and sent the request to Caché.
And you get it back preferred in JSON style expressed.
Your requests are straight HTTP with someWebServer in between on your way to Caché.
SOAP does something similar. But it has an incredible overhead of XML.
And as with .NET binding you need predefined data structures to be serviced.
In extrem: With REST you just get back a string / stream and it is up to you to decide what this means:
No predefinded structures. It is all your task to organize yourself.
For .NET end I found this link:
https://docs.microsoft.com/en-us/aspnet/web-api/overview/advanced/calling-a-web-api-from-a-net-client
For Caché side there are lots of useful articles in the forum already and examples in SAMPLES.
Simple summary:
For RESTapi you will not need
InterSystems.Data.CacheClient.dll nor generated proxy classes using the Caché Object Binding Wizard for .NET
You are the owner of the exchanged data structures.
Are looking for this?
SELECT JSON_OBJECT('ID':ID,'Column1':COLUMN1,'Column2':COLUMN2,'DataID':DataID) FROM SQLUser.SampleData
Cache for Windows (x86-64) 2017.2.1 (Build 801U)
Sorry I don't have your data to show your result
somewhat similar.
SELECT top 3 JSON_OBJECT('name:':Name,'home':HOME_CITY,'dob':DOB) FROm Sample.Person
Or all together:
SELECT '{"result":'||List(xx)||'}' FROM
(SELECT top 3 JSON_OBJECT('name:':Name,'home':HOME_CITY,'dob':DOB) xx
FROM Sample.Person)
The difference in DOB is just display mode vs. ODBC mode
Sorry you went to CLASSES not to SQL !!!
These are different worlds with different rules and syntax.
And while your classname is WINSURGEDMP.WINSURGERESULTFACT
I expect your TABLE to be named WINSURGE_DMP.WINSURGE_RESULT_FACT
It is just by accident if TABLEs and CLASSes have the same name !!!!!
Especially if you refer to an EXTERNAl TABLE in a different (non Caché) database
Recompile deletes all Cached Queries !
See Dmitry's comment.
and Mgmt Portal > System Explorer > SQL > Actions > Purge...
#1) check that there exists a valid class WINSURGE*...
#2) in Mgmt Portal > System Explorer > SQL you should see as Table WINSURGE_DMP.WINSURGE_RESULT_FACT
#3) #SQLCompile Path=cancreg
seems the real source of your problem as it sets a default package cancreg wherever that may come from
Eliminate it as your table is already full qualified WINSURGE_DMP.WINSURGE_RESULT_FACT
In addition : - VALUES :FIELD()
do you really write to ALL fields of the external table ???
Hint:
try to execute your SQL statement first from Mgmt Portal using dummy values before coding with strange macros directives
start with a simple statement to see if the connection works as expected:
SELECT COUNT(*) FROM WINSURGE_DMP.WINSURGE_RESULT_FACT
then try:
INSERT INTO WINSURGE_DMP.WINSURGE_RESULT_FACT VALUES (1,2,3,4,5,6) -- whatever it needs
I like that ! 
BUT: as in the original request I seem to miss the file.Read() to fill Line somewhere in the loop. 
Enable long strings in System Mgmt Portal and get strings up to 3.4 MB
System > Configuration > Memory and Startup
Time in Posix is the time as %Integer counting from Jan 1st, 1970. A UNIX definition.
dates before are negative integers (e.g. birthdate before 1970 )
[that was a reason to start $h with Jan 1st, 1840. The year the oldest veteran (in 1960) from civil war at MGH was born ]
the WRITE is just to visualize the example
the loop in YOUR class could be:
but that's just standard COS programming. Nothing special. see here
Then you have the local array msg with your SOAP message
Similiar the Try{ } Catch {} construct that ignores the error that you experience as you don't get a real SOAP response here.
You may create a normal SOAP Client in Studio using the Wizard.
Then you add a transport class to display / dump your request. (example in SAMPLES)
Example to use it :
so you get Envelope + Body well separated
that's default anyhow
in technology space it's nice and compatible to the UNIX/LINUX world
in the commercial arena it is just an alien
set s.TimeStamp=$zdt($H,3)
it is already in ODBC format.
%Date is just handling +$h, no time (that would be %Time)
%Timestamp is the real object equivalent of $h
That makes it more clear, but not easier.
Class %SOAP.WebClient is the base for any SOAP Client in Caché.
It has a property Transport to provide a registered class for alternate transport (or no immediate transport in your case)
check the code starting with Method InvokeClient(...
and look for transport within the next 50 lines to see how that works up to here
Just to be clear:
I personally won't do it that way because of all the related maintenance risks.
That's a possible end point.
If you don't do to detect the structure using TCPtrace or WireShark or similar you will not see it.
As I noted. It's an advice for hackers (and network engineers)
YES. and once you have identified the content you should be able to modify it in object script according to your needs with $REPLACE, $TRANSLATE, ...... as any other string
MgmtPortal : System Operation > Databases > Freespace > Compact / Truncate
Take a look to online docs first !
"Displaying Free Space Information"
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSA_check_databases_freespace
In order to use a table in an external DB you need to LINK this table to your Caché instance.
There's a Wizard in Mgmt Portal System > SQL > Wizards > Link Table
It connects to your external table using SQLgateway and creates a proxy class in your namespace
that presents the table with all SQLnames ...( underscores, ...) as if it was a local table but with a special external storage
Then you use this proxy class as you would do with a local one.
Table 'WINSURGE_RESULT_FACT' should then be visible and accessible.
It might be somewhat slower than Globals
Hacker's advice:
Create a SOAP client with Studio - Assist.
Send your request anywhere and hijack it with TCPtrace or WireShark or similar.
Now you have the string that you intend to modify and to send.
Anyhow, I'm somewhat surprised about the subject.
Mike,
please create a new question as the solution is not related to the previous one.
Thx.
Evgeny,
The type of mirror depends on how it should be used:
Typically a Message in Ensemble is inheriting from Ens.Request
e.g. Class EnsLib.Testing.Request Extends Ens.Request
I have no Healthshare at hands to identify your correct message
just to confirm Enslib.HL7.Message does NOT extend Ens.Request as it is a Persistent object on it's own.
Your message might be locked by some other process at that time.
Try to raise your Lock level to have exclusive access to your persistent object %GetLock(id) which you need during %Save()
If it fails you should find out who else is locking it.
I like that
$lf($lb(1,s,y,s-y+1),x)
Log in. Then 1 >> 2 >> 3
That's mine: