5 Replies Latest reply: Mar 17, 2017 6:33 AM by Erik Gustafsson RSS

    Loading external data into extensions with javascript

    Erik Gustafsson

      Hello!

       

      I'm currently looking into custom visualisations in Qlik Sense and Qlik View, trying to get a grasp on the capabilities and limitations. One interesting area is loading data from external web API's. I'm aware that Qlik load scripts can do this as a part of normal data loading, and that such data is available to extensions, which is great, but not what I'm looking for right here. I want a way to load data live and on demand.

       

      So, coming from a web developer background, the first thing I tried was using jQuerys AJAX methods. This fails for normal web API's, but works for API's that allow cross-origin requests, so I'm guessing the restriction is the same as with any web page trying to access data from another domain with client-side code. I've verified an API that uses JSONP to accomplish cross-origin capabilities, and I'm guessing that it would work with CORS as well, although I haven't verified that yet.

       

      This makes sense, but what I would really like to see is a method in the Qlik JS API's that would trigger a request from the native environment (bypassing cross-origin restrictions) and then return the data to the JS environment asynchronously.

       

      I've been reading documentations, but can't seem to find anything like that. I'm interested in this for both Qlik View and Qlik Sense. Am I missing something, or is this not supported or even discouraged? Is there an alternative approach besides the ones I've mentioned above?

       

      Best regards,

      Erik Gustafsson

      Elvenite AB, Sweden

        • Re: Loading external data into extensions with javascript
          Alexander Karlsson

          No such function and it probably wouldn't help anyways. The http origin is going to be the same if the server executes the request or your client/browser.


          But a extension is free to execute any xhr requests it wants to. It's up to the receiving end to manage cors correctly.

            • Re: Loading external data into extensions with javascript
              Erik Gustafsson

              Thanks for your reply!

               

              Too bad there isn't a function like that. I think it would be quite useful, since the majority of API's out there don't allow direct cross-origin access.

               

              Before I mark your reply as the correct answer, I feel I must object to your claim that it wouldn't matter - servers or desktop applications normally don't enforce any same-origin-policy like browsers do. If Qlik's desktop or server application did that, they wouldn't be able to use external web API's as data sources in normal load scripts either, and they certainly are able to do that. Right? Or maybe I just misunderstood your comment.

               

              /Erik

                • Re: Loading external data into extensions with javascript
                  Alexander Karlsson

                  Well what a browser can't do is to "fake" it's origin if that's what you mean.
                  But a normal API would implement some kind of re-write on their end to accept different http origins.

                   

                  Javascript and browsers by themselves have no issues with requesting cross domain resources. But if the responding party, the API, don't allow cors requests it's likely also not a API you don't want to consume or they want you to consume.

                   

                  I admit that CORS used to be a more important issue but with modern browsers, and the ones Sense supports, that implement html5 it's a lot less of an issue these days. The XMLHttpRequest supports all kinds of cors requests these days.

                   

                  But if you can provide a good use-case then sure, we can put it into consideration!
                  Opening up your server to external http traffic feels scary though...

                    • Re: Loading external data into extensions with javascript
                      Alexander Karlsson

                      Oh and if you have examples of API that don't support CORS let us know because for us it's the opposite, it's rare these days to encounter APIs that don't support CORS.

                        • Re: Loading external data into extensions with javascript
                          Erik Gustafsson

                          Hi,

                           

                          The API I was trying to use in this was a weather API at met.no, see https://api.met.no/weatherapi/documentation.

                           

                          In the end, I went with another weather API - Yahoo Weather, which supports CORS, but has less data with less precision for my use case. I shouldn't talk about what's more common because I don't know, but I'm sure there are plenty of potentially useful API's out there that still do not support CORS.

                           

                          What people normally do when they want to use an API like that as part of a web application is that they let the web server do the request instead, acting like a proxy and passing the result back to the client. The web server has no problem with making a request to any public URL.

                           

                          My though here is that the QV/QS desktop or server application could do the same thing, since it has the same role as a web server to some extent. After all, QV/QS can make requests to API's like that when executing the load script. So that's the idea that you could take into consideration, if you want.

                           

                          And, just for arguments sake, I'm not quite sure how web servers and other applications like curl and such do it, but my understanding is that it is the browser that enforces the CORS policy, adds the special request headers and respects the response headers. It only does this on AJAX requests, not in requests for resources like images or scripts, so it definitely COULD do it. I know that in Chrome, you can even bypass this behaviour with special startup flags, which will then allow the client to do any cross-domain requests it wants. This is off course not a way to solve any problem here, but just to illustrate.

                           

                          Best Regards,

                          Erik