Hi Guys,

I'm using the below to export a query result to excel file and the only file type is .csv (100) but the resulting has two problems,

first the row header is including the field type and second the resulting file is a tab delimited so columns aren't properly separated (see attached below)

set st = ##class(%SQL.Statement).%New(2,"Sample")
set sql = "select ID, name from MyClass"
do st.%Prepare(.sql)
set type="csv"
set rs = st.%Execute()
do rs.%DisplayFormatted(type,"C:\Temp\report")

0 5
0 494
Question
· Jun 7, 2022
Connecting two ensemble instances

Hi Guys,

We currently running all our clients in Ensemble 2014, but now we are having a problem that 2014 can't resolve (TLS version is 1 where we need TLS 1.2 or higher).

0 1
0 201
Question
· Jun 4, 2022
SSL/TLS connection error

Hi Guys,

I'm getting the below TLS error in SSL_connect(), SSL_ERROR_SYSCALL, I've treid mulitple SSL/TLS configuration and still get the same error, so should I be asking the client that I'm trying to connect if there a specific certificate or configuration!?

0 4
0 759
Question
· Jun 1, 2022
Production Service connections

Hi Guys,

I have a service that picks up jobs and process them, is there a way that I can cap the number of attempts to pickup a certain job eg. 10 times if no response then just discard ?

Thanks

0 1
0 198
Question
· May 28, 2022
Write JSON file in HTTPREQUEST

Hi Guys,

how can I write a json file in httprequest, I'm using the below but when I check what's in mystring it's actually truncated and doen't include all my file?

0 10
0 506
Question
· May 22, 2022
Convert JSON to objectstream

Hi Guys,

I'm running Ensemble 2014 and I'm using this to convert JSON to object:

class(%ZEN.Auxiliary.jsonProvider).%ConvertJSONToObject

but how can I convert to %CharacterStream because I'm saving a %CharacterStream field

Thanks

0 1
0 287
Question
· May 17, 2022
Create aJSON file

Hi Guys,

How do I create a JSON with the below structure pls:

{
"field 1": "123",
"field 2": "1.1.1",
"field 3": "4.428",
"Lines": [
[ 0.00523, 0.00952, 0.01626 ],
[ -0.00303, -0.00286, 0.00387 ],
[ 0.00110, 0.00814, 0.00800 ],
[ -0.00991, 0.00952, 0.00800 ]
]
}

thanks

0 2
0 309

Hi Guys,

I currently have a service that uses an InboundAdapter to get a JSON file and process it given that the client is pushing data to us, but now we have another client where we need to request the JSON file by sending a HTTP request then get the file and process it, kind of a Get rather than push, how can I create a service that handle that?

0 1
0 299