Hi There ,
   We are trying to do a small POC trying to integrate NHS Careconnect with Ensemble/Healthconnect. Does anyone have implemented this before. It would be good that you provide some suggestions or any sample implementation. It would be good to get suggestions any interesting use casesÂ
within NHS England for the POC.
So, one day you're working away at WidgetsDirect, the leading supplier of widget and widget accessories, when your boss asks you to develop the new customer facing portal to allow the client base to access the next generation of Widgets..... and he wants you to use Angular 1.x to read into the department's Caché server.  Â
There's only one problem:  You've never used Angular, and don't know how to make it talk to Caché.
This guide is going to walk through the process of setting up a full Angular stack which communicates with a Caché backend using JSON over REST. Â
Part 1 - Setup
To start fresh, we will create a Namespace for our new application - WIDGETDIRECT, and set this up with Code and Data databases, and appropriate Security roles. Â
Our next step is to set up 2 Applications to serve web content; one for the Angular web content and one to serve the REST conten
Referencing this post:
https://community.intersystems.com/post/producing-json-sql
I'm not sure how to actually interact with the result set I get from doing something like this. I want to return something like:
[{"field1":1, "field2":2}, {"field1":2, "field2":10}]
I'm finding it very difficult to get it in this format, since %Print appends a newline onto the end of the {} object it prints.
Here's the closest I've gotten:
set query = "select JSON_OBJECT('field1': field1, 'field2":field2) from MyTable where x=? and y=?"
   set tStatement = ##class(%SQL.Statement).%New()
   set qStatus = tStatement.%Prepare(query)
   if qStatus'=1 {WRITE "%Prepare failed:" DO $System.Status.DisplayError(qStatus) QUIT
Hi Dev Community,
My team is currently working on a project where we need to post pdf documents to a 3rd party REST API.
The API specifies a field in the JSON request message to contain the 'physical content' of the file as an array of bytes, example of the JSON request as follows - data truncated for readability purposes:
{
  "CaptureSource":2,
  "RecipientID":"ID34",
  "Document": {
    "Guid":"5D847A4E9CC1485382DC4A5F5DC80D6C",
    "EventDate":"2019-01-14T13:23:46",
    "FileExtension":"pdf",
    "FileContent":"JVBERi0xLjQNCiXi48/TDQoxIDAgb2JqDQogIDw8DQogICA......"
   },
  "ActionRequired":false,
This article is translation of one from Habrahabr InterSystems blog (Russian).
The original post can be found here:Â https://habrahabr.ru/company/intersystems/blog/251611/
Â
Everyone familiar with InterSystems Ensemble, an integration and application development platform, knows what the Ensemble Workflow subsystem is and how useful it can be for automating human interaction. For those who don’t know Ensemble (and/or Workflow), I will briefly describe its capabilities (others may skip this part and learn how they can use the Workflow interface in Angular.js)
Good afternoon - I am in the process of writing a AngularJS front-end for some CoS functions that my integration team uses for auditing, analyzing and various other purposes. I have re-tooled the functions to return JSON results that AngularJS can then interpret and display. Many kudos to the AngularJS series on this site for giving me a jump start.
One of these functions uses %SQL.Statement to prepare a class query on %Dictionary.CompiledClassQuery, Summary. This works perfectly if I give the web app making the call %All privileges but obviously I don't want to do that. I cannot determine the appropriate privilege(s) needed to execute this query otherwise however. My REST call simply returns ERROR 5540 - UserUnknownUserisnotprivilegedfortheoperation.
I have attempted to the give the Web App's unique Role EXECUTE privileges to %Dictionary.CompiledClassQuery_Summary and several other things without success.
Â
Hi dev community,
I am currently working on a project to send documents to a RESTful based API that supports bearerÂ
Token Authorization.
When we try to fire a JSON request from our EnsLib.Rest.Operation towards the 3rd party API with aÂ
valid Token we keep receiving Authorization Error codes HTTP 401 back.
If we use the same request and same Token from a test utility such as Postman the request isÂ
successful and we are able to move past the authorization stage.
We are inputting the Token in the header of the HTTP request as specified by the 3rd party APIÂ
specification. We therefore are using the following code from the operation side, being tHttpRequest a %Net.HttpRequest object
This question is about calling AWS REST APIs. Based on:
http://docs.aws.amazon.com/general/latest/gr/sigv4_signing.html
AWS requires REST clients to call their APIs using Signature Version 4 which in case you don't know what I am talking about is a pain in the neck. Â Here comes the question:
Has anybody, by any chance implemented the v4 signing alg. in COS? If yes, would she or he have the kind heart to share?
Thanks,
Chris
Â
Â
Is it possible to mimic what selenium does like navigating to a site and logging in and filling out a form then logout in COS.I am trying to do that in COS using %Net.HttpRequest class or should I be using a different class the idea is to be able to call a web app login into it and fill out form and log out
Hi guys,
  I'm trying to develop a  program calling Cache REST service twice with Cors. My Cache version is 20181.1.312.
  The REST service was implemented as below:
Hi there,
  I'm trying to develop a  program calling Cache REST service twice with Cors. The first is fetching some information of a patient with GET request, the second is using obtained information to call another REST service(implemented in the same class though) with POST to  perform other tasks.
I successfully got everything in this guide to work:Â https://community.intersystems.com/post/ensemble-rabbitmq-java-client-qu...
I am now using the information I gained from this guide along side with this guide:
https://www.rabbitmq.com/tutorials/tutorial-one-spring-amqp.html
Â
I am running into an issue though. In the RabbitMQ guide I just posted, they have a "Receive message" functionality. I use that alongside with the SendMsg from Ensemble method in the InterSystems guide. The issue I have is the message I receive looks like "[B@2c421093(byte[21])" instead of "Hello from Ensemble!"
Hi all,
I'm wondering if is possible to extend the UrlMap.
I want to create a base class and one method will be in all extended classes, so I've tried to create the map route in parent class, and the specific methods in extended class. But it doesn't work.
I've create the method in parent class and I've wrote the map in extended class. It works, but I want to put it in base class to prevent forget this call.
Note: The base class extend to %CSP.RES
Best regards,
Francisco Lopez
Hi All,
I am trying to get JSON data from a REST api. I am using my web browser to get the data by hitting the URL.
The data is receiving properly, but the JSON contains a few HTML tags.
These tags are not not receiving in the browser while hitting the url. Is there any way to overcome this issue ?
Thanks,
Hi
I'm trying to send a request to a REST API Service.
I'm using this code (Adapter isÂ
{
set tSC = $$$OK
try
{
We have a Cache database in Azure, and want to expose it as an OData source (link).
My first attempt was to use Microsoft's Visual Studio 2017 and Entity Framework to create the data models...but it seems as if EF and Cache don't work together. (I do have those instructions from 2013, but they don't work. (See other post. Best answer seems to be "migrate to IRIS 2019.1.") Â
Is there any other form of OData support?
Hello Cache Developers: I was curious if anyone has ever created a TWAIN interface to their Cache Application?  I am new to TWAIN and hence the reason for this question. From what I understand, TWAIN is software used by various digital imaging software and TWAIN provides an API for applications to call to be able to import images into their application.  I work with a healthcare application and was wondering what types of things are required for a Cache Web Application to call the TWAIN API to be able to load images into a Cache table.   Any input, sample code, or suggestions is appreciated.  Thanks and Have a Great Day!   Happy Coding.
Hi I'm using ensemble/cache 2016 is a NTML auth possible. Any code examples?
Currently I've got
set hr3 = ##class(%Net.HttpRequest).%New()
set hr3.Username = "xxxxxx/xxxxxxxxx"Â
set hr3.Password = "xxxxxxx"
do hr3.Get("http://xxxxxxxxx/CaseNoteTracking/api/CaseNoteTrackingAPI/Get")
From the looks of things I need a http 1.1 request?
Hi All,
Actually I am trying to implement a RESt API where in I will get ZIPCODE as request and I need to call external API which will take ZIPCODE as input and give State and City in response.
But the problem is the request is in XML Format and also response is in XML format.
Example :
https://XYZ.com/ABC.dll?API=CSLookUP&XML=<CSLookupRequest USERID="USERID">
<ZipCode ID='0'>
<Zip5>20024</Zip5>
</ZipCode>
</CityStateLookupRequest>
and in ResponseÂ
<?xml version="1.0" encoding="UTF-8"?>
<CSLookupResponse>
  <ZipCode ID="0">
    <Zip5>20024</Zip5>
    <City>WASHINGTON</City>
    <State>DC</State>
  </ZipCode>
</CSLookupResponse>
Is there any good documentation/tutorials on creating gateways in both directions between FHIR and Hl7v2 (for Health Connect)?
the scenarios I'm most interested in
1. Client application sends a FHIR demographic query to Health Connect - and the interface has to convert this to Hl7v2 QBP^Q11 message to the PAS.
2. Health connect sends a PDF document (from a file or HL7v2 interface) to an EPR over FHIR.
Thanks
Stephen
UPDATE
We are using Health Connect 15.03 - Cache for Windows (x86-64) 2017.2.1 (Build 801U) Wed Dec 6 2017 09:07:51 EST [HealthShare Modules:Core:15.03.9901 + Linkage Engine:15.03.9901]
There hasn't been a HealthShare Connect release on HS Core 16.
There's a new and exciting enhancement to QEWD that has just been released - it's an additional layer of abstraction known as QEWD-Up. QEWD-Up hides away all the mechanics of QEWD itself, allowing you to focus on just your REST APIs and the code that implements them.
Additionally, and importantly, QEWD-Up simplifies the maintenance of your REST APIs, allowing you (and others) to quickly and easily understand their life-cycle and implementation.
QEWD-Up supports both monolithic application designs and MicroService-based architectures where APIs are broken down by, for example, functional role.
You can read all about QEWD-Up here:Â https://github.com/robtweed/qewd/tree/master/up
Importantly, QEWD-Up runs QEWD as standard under the covers - there's nothing new or unusual that it does - it just automates out of the way all the QEWD-specific stuff that you previously had to write manually
I am trying to explore some new possibilities outside of the normal day to day HL7 interfacing we do. I have only done 1 other Web Service interface but it was using a SOAP proxy wizard. Now I am tasked with trying to make a call to an external APIÂ
https://npiregistry.cms.hhs.gov/api/
but I am a bit confused about how to go about doing it. Since they don't have a wsdl, this means it is a REST web service correct? or is it considered an API call? When I read the documentation it feels like it is more geared to building REST services/operations within Ensemble then connecting to one on the outside, am I missing something here.
Can someone help clarify this for me?
Is a API considered a Web Service?Â
Am I missing something in the Documentation?
ThanksÂ
Scott
Developing a Full-Stack JavaScript web app with Caché requires you to bring together the right building blocks. In the previous part, we created a basic front-end React application. In the second part of this article series I will show how to choose the right back-end technology for your application. You will see Caché allows you to use many different approaches to link your front-end to your Caché server, depending on your application's needs. In this part we will set up a back-end with Node.js/QEWD and CSP/REST. In the next part we will enhance our basic web app and connect it to Caché using these technologies.
So, one day you're working away at WidgetsDirect, the leading supplier of widget and widget accessories, when your boss asks you to develop the new customer facing portal to allow the client base to access the next generation of Widgets..... and he wants you to use Angular 1.x to read into the department's Caché server.  Â
There's only one problem:  You've never used Angular, and don't know how to make it talk to Caché.
This guide is going to walk through the process of setting up a full Angular stack which communicates with a Caché backend using JSON over REST. Â
This is a parent page for the multipart series on creating a Material-Angular1x-REST-JSON-Caché application.  The current list of articles is
As a result of Evgeny's recent questions regarding the use of QEWD.js with IRIS in another post, I thought it would be a good idea to create a separate post focusing specifically on how to use QEWD.js to create REST APIs for IRIS.
QEWD.js is, of course, a Node.js framework, and all the REST API code can be written entirely in JavaScript.Â
The RealWorld Conduit reference application makes a great exemplar for this kind of thing, as the APIs are all published and there are numerous implementations of both front-ends and back-ends for it, using different technologies, frameworks and databases. So you'll be able to compare this QEWD / IRIS implementation with lots of other technologies and databases and see how they compare. You should find that QEWD + IRIS is extremely fast - it would be interesting to see some comparisons with other back-end implementations
Hi,
I'm having the following error when returning a large dataset from a REST API.
"errors":[ {
         "code":5002,
         "domain":"%ObjectErrors",
         "error":"ERROR #5002: Cache error: <STORE>%0NmGk1+5^xxxxxx",
         "id":"CacheError",
         "params":["<STORE>%0NmGk1+5^xxxxxxxxxxxxxxxxxxxx"
         ]
      }
   ],
   "summary":"ERROR #5002: Cache error: <STORE>%0NmGk1+5^xxxxxxxxxxx"My understanding is that this error is related to the amount of memory available.Â
Please see my method implementation below. The SQL query has about 50 columns and can return more than 30 000 rows.
Can someone advice me on the best implementation approach for this scenario?
I'm using Cache 2015.2.
Thank yo
In this article, I would show how you can upload and download files from InterSystems products via http.
The questions about working with files over http arise fairly often on community and I'm usually linking to my FileServer project which demonstrates file upload/download but I'd like to talk a bit more on how we can serve and receive files from InterSystems products.
If you have a file in on a file system and you know the path you can serve it from REST or CSP context by calling this method
Hi,
I'm using InterSystem Cache v2015.2.5 and I'm implementing a REST API and returning JSON.
Following the documentation I see examples like this
Set obj = {"destinations": ["London","Madrid","Tokyo"]}
Write obj.%ToJSON()
However, I have a compilation errorÂ
ERROR #1054: Invalid expression : '{"destinations":'Â
Is there something that needs to be enabled on Studio to allow this syntax?
Thank you,
Rui
Hi,
How Can I get sentiment analysis (positive or negative attribute) from a source or entity from iKnow REST API?
