Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
In qlikview I could make http call with the dynamic address, how to do the same in Qliksense?
in qlikview:
best regards
Ricardo
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
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
Great, that is the solution