topic Re: How to setup a REST connection from Qlik Sense to Eurostat REST API in Connectivity & Data Prep

How to setup a REST connection from Qlik Sense to Eurostat REST API

jfdierckx — Wed, 22 Dec 2021 14:19:47 GMT

I would like to use the Qlik Sense Rest connector to connect to the Eurostat REST API :

http://ec.europa.eu/eurostat/web/json-and-unicode-web-services/getting-started/rest-request

However, when I try to use it in Qlik Sense, I get the following error message when testing the connection : HTTP protocol error 502 (Bad Gateway) - Your request has been denied for security reasons

Any idea why this is, and how to make it work ?

The query URL I'm trying is the following : http://ec.europa.eu/eurostat/wdds/rest/data/v2.1/json/en/hlth_ehis_sk1e?sex=F&sex=M&sex=T&precision=1&geo=EU28&unit=PC&time=2014&isced11=ED0-2&smoking=NSM&smoking=SM_CUR&smoking=SM_DAY&smoking=SM_OCC&age=TOTAL

(you can build REST API queries at Eurostat here :Query builder - Eurostat)

I'm using version 3.2.4 of Qlik Sense Desktop.

Re: How to setup a REST connection from Qlik Sense to Eurostat REST API

DavidŠtorek — Mon, 31 Jul 2017 08:07:24 GMT

Hi,

it seems to be some error on side of Qlik, because e.g. with Power BI I am able to connect. With Qlik Sense June 2017 I am getting error ACCESS DENIED - Your request has been denied for security reasons

Re: How to setup a REST connection from Qlik Sense to Eurostat REST API

fmarvnnt — Mon, 04 Sep 2017 14:47:09 GMT

Same with June 2017 Patch 1 and QlikCloud with site URL: https://ec.europa.eu/eurostat/wdds/rest/data/v2.1/json/en/nama_gdp_c?precision=1&unit=EUR_HAB&time=2010&time=2011&indic_…

Re: How to setup a REST connection from Qlik Sense to Eurostat REST API

Anonymous — Mon, 04 Sep 2017 17:00:15 GMT

It worked fine after I added a spoof User_Agent to the Query Header when creating the Qlik Data Connection as a Qlik Rest Connector

Query Headers

Name User-Agent

Value Spoof

Here is the url to a thread re a similar issue https://www.qlikcommunity.org/thread/237324 , albeit connecting to GitHub

Re: How to setup a REST connection from Qlik Sense to Eurostat REST API

fmarvnnt — Tue, 05 Sep 2017 09:27:04 GMT

This solves the issue. Thank U,

Francesco

P.S.: unfortunately I'm not able to mark as resolution

Re: How to setup a REST connection from Qlik Sense to Eurostat REST API

Anonymous — Tue, 05 Sep 2017 09:44:09 GMT

Only the person who created the thread can mark a resolution, but if you like a reply you can Like it.

It is a bit of a frig though, so could be worthwhile searching the web re User_Agent spoofing just in case Eurostat see loads of spoof requests and block them. It may be better instead of using a Value of Spoof to use your name.