Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ricardo_tamagni
Contributor

Qliksense Dynamic call to rest connect

hi,

In qlikview I could make http call with the dynamic address, how to do the same in Qliksense?

in qlikview:

from [http://api.wunderground.com/api/My-key/history_$(vGetDate_char)/q/$(VCountryInstall)/$(VCityInstall)...]

best regards

Ricardo

1 Solution

Accepted Solutions
silviaganhao
Contributor II

Re: Qliksense Dynamic call to rest connect

Try change that form of yours to this:

CUSTOM CONNECT TO

"Provider=QvRestConnector.exe;

url=YOUR_URL;

timeout=30;

method=GET;

autoDetectResponseType=true;

keyGenerationStrategy=0;

useWindowsAuthentication=false;

useCertificate=No;

certificateStoreLocation=CurrentUser;

certificateStoreName=My;

queryParameters=id%21;

queryHeaders=Authorization%2Bearer $(vAccessToken2);

PaginationType=None;";

But please note that you have to go to C:\Users\YOUR_USERNAME\Documents\Qlik\Sense (in case it is desktop version), edit the file Settings.ini with this:

[Settings 7]

StandardReload=0


Restart QlikSense Desktop.

then you can use this:

LET vURL = 'YOUR_URL';

[YOUR_TABLE]:

LOAD

  [YOURFIEDLS];

SQL SELECT

  "__KEY_root",

  (SELECT

YOUR FIELDS)

WITH CONNECTION (

  URL "$(vURL)"

);

Sílvia

2 Replies
silviaganhao
Contributor II

Re: Qliksense Dynamic call to rest connect

Try change that form of yours to this:

CUSTOM CONNECT TO

"Provider=QvRestConnector.exe;

url=YOUR_URL;

timeout=30;

method=GET;

autoDetectResponseType=true;

keyGenerationStrategy=0;

useWindowsAuthentication=false;

useCertificate=No;

certificateStoreLocation=CurrentUser;

certificateStoreName=My;

queryParameters=id%21;

queryHeaders=Authorization%2Bearer $(vAccessToken2);

PaginationType=None;";

But please note that you have to go to C:\Users\YOUR_USERNAME\Documents\Qlik\Sense (in case it is desktop version), edit the file Settings.ini with this:

[Settings 7]

StandardReload=0


Restart QlikSense Desktop.

then you can use this:

LET vURL = 'YOUR_URL';

[YOUR_TABLE]:

LOAD

  [YOURFIEDLS];

SQL SELECT

  "__KEY_root",

  (SELECT

YOUR FIELDS)

WITH CONNECTION (

  URL "$(vURL)"

);

Sílvia

ricardo_tamagni
Contributor

Re: Qliksense Dynamic call to rest connect

Great, that is the solution