Hi Saurabh - (Jagan thanks for bringing this to our attention)
This is possible if you disable Standard mode - documentation here:
It looks like you were attempting to use the Web File data connection and then populate the URL field with the URL you put in the original post. This WILL NOT WORK - with the default data connection mode. If you disable standard mode, YOU CAN USE the variables - but you need to put the connection information in the script - JUST LIKE YOU WOULD when using QlikView.
(txt, codepage is 1252, no labels, delimiter is ',', msq);
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
let us know how you do
Thanks for your help.Thanks Jagan for pointing the question to you.
I am aware of the Server side Legacy mode settings. I wanted to try and implement it in Desktop mode.
What I currently do is create qvds in QlikView and then import into Sense.
I wanted to reload data directly in Qlik Sense app which I should be able to do now by using the server only.
There seems no option to do it via legacy mode in Desktop.
Though it is not much of a problem as App development can seamlessly be done on the server.
You can achieve it by disabling standard mode (=enabling legacy mode). Please refer to the following URL:
Just a note worth mentioning in relation to someone facing similar issues.
Sometimes the client may have different groups accessing the same app and then need to refresh from separate data sources. We would typically use variables in similar situation.
You can explore applying the new rule based security to data connections via the server to solve the issue.
Hope that helps.
Better to pass the variables to the REST Connector like this.
WITH CONNECTION (
QUERY "param1" "$(param1)",
QUERY "param2" "$(param2)"
There's a full worked example here: ZOHO API with Qlik REST Connector and table transpose