Question Nezla · Jul 14, 2022 Deleted records Hi Guys, is there a way to get an audit or a record of deleted records in a class? #Ensemble 0 6 0 466
Question Nezla · Jul 7, 2022 Crystal Report 2020 compatibility Hi Guys, this might be a dumb question but is Crystal report 2020 compatible with Ensemble 2014 datasource driver? Thanks #Ensemble 0 1 0 314
Question Nezla · Jul 5, 2022 Exporting to Excel with %DisplayFormatted 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") #Ensemble 0 5 0 494
Question Nezla · 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). #Ensemble 0 1 0 201
Question Nezla · 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!? #Ensemble 0 4 0 759
Question Nezla · Jun 2, 2022 Converting from UTC Hi Guy, is there like a utility or a function that convert from UTC to Locale time? Thanks #Ensemble 0 4 0 381
Question Nezla · Jun 1, 2022 <COMMAND>zRunTask+72^%SYS.TaskSuper.1 Hi Guys, I had a task that was running ok but then crashed and now getting this error <COMMAND>zRunTask+72^%SYS.TaskSuper.1? Thanks #Ensemble 0 1 0 206
Question Nezla · 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 #Ensemble 0 1 0 198
Question Nezla · May 30, 2022 HTTP/1.1 500 Internal Server Error Hi Guys, I'm using the below code to post a JSON file: #Ensemble 0 3 0 540
Question Nezla · 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? #Ensemble 0 10 0 506
Question Nezla · May 27, 2022 HTTP/1.1 415 Unsupported Media Type error when posting httprequest Hi Guys, I've a JSON file and I'm using the below code to post it but I'm geting "HTTP/1.1 415 Unsupported Media Type" error, could help pls? #Ensemble 0 4 0 412
Question Nezla · May 24, 2022 reading JSON file Hi Guys, I'm using the below so I can put JSON file in an object and read each property: #Ensemble 0 7 0 394
Question Nezla · 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 #Ensemble 0 1 0 287
Question Nezla · May 22, 2022 Using a Service to get data (Inbound or outbound adapters) Hi Guys. I'm a newbie in productions and services and I'm using this code to get HTTP response with JSON file, is a way to do this via a production service? #Ensemble 0 2 0 227
Question Nezla · May 17, 2022 Get HTTP response using Token Hi Guys, I'm using the below code to get a JSON file using a Token, I can get json file with not problem from the the command prompt as below, #Ensemble 0 3 0 454
Question Nezla · 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 #Ensemble 0 2 0 309
Question Nezla · May 16, 2022 Handling HTTP requests with InboundAdapter 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? #Ensemble 0 1 0 299
Question Nezla · May 16, 2022 Send HTTP request and get a response Hi Guys, is there a sample code where I can basically send a HTTP request given a URL and authentication and handle the JSON response? Thanks #Ensemble 1 10 0 1.6K