从 Qlikview 应用程序中提取表格的正确 API/抓取方法 [英] The right API/scrape method to extract tables from a Qlikview app

问题描述

我试图在这个 qlikview 页面上获取一些带有特定过滤器的表格，以供将来分析:

I'm trying to get some tables with specific filters on this qlikview page, for future analysis: http://transferenciasabertas.planejamento.gov.br/QvAJAXZfc/opendoc.htm?document=painelcidadao.qvw&lang=en-US&host=QVS%40srvbsaiasprd01&anonymous=true

I don't want to do it manually (downloading tables for every filter). Therefore, I searched for API's for Python on qlikview website, but only found qliksense API's for SSE (like this https://github.com/qlik-oss/server-side-extension).

Is there any chance that I could automate the retrieving process that I explained using Python?

解决方案

Server side extensions are used for something else. They extend Qlik's functionality to process data (for example running some statistical functions on top of the displayed data if such functions do not exists in Qlik natively)

Interestingly is that the portal link (http://transferenciasabertas.planejamento.gov.br) is a QlikView app that later redirects to a Qlik Sense app(s). It seems that anonymous users are allowed on the platform (which makes automating data retrieval easier).

Qlik Sense communicates with the browser via web sockets. So the answer to your question is - yes. You can used Python to connect to the underlying Qlik Sense Engine and make some selections and get the data back.

The not very good news is that I dont think there is dedicated Python library so you'll have to send the raw web socket requests by yourself. The documentation for the Engine API can be found at Qlik's help site

If you are open for JS solution then you can use Qlik's enigma.js library for Engine communication.

The web sockets traffic can be monitored from the browser (to view what data is being send/received and its format)

这篇关于从 Qlikview 应用程序中提取表格的正确 API/抓取方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！