Is it possible to use a variable in a REST connection?

[Anonymous]

Good Afternoon All,

i am new to all this and this is my first question so please bare with me

I am using a REST connector to connect qlik view to my SmartSurvey account to retrieve the surveys that have been conducted via the use of API.

I initially collect list of all the surveys that have been completed with uniqueIDs. Using the uniqueID i will be able to collect the responses to each survey,  As am sure you can tell the uniqueID is generated every time so for this reason i am using a peek statement to assign the latest survey uniqueID to a variable which i would like to use in the REST connection so that it will load that into my qlikview.

i have used WITH Connection, but this doesnt work as well as mulitiple attempt of using it within the REST connection script.

-------------------------------

Current Script:

url = https://api.smartsurvey.io/v1/surveys/335393/exports;

vURLDownload:  https://api.smartsurvey.io/v1/surveys/335393/exports/519048/download

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;

url=https://api.smartsurvey.io/v1/surveys/335393/exports;

timeout=30;

method=GET;........

i want to do the following:

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;

url=$(vURLDownload);

timeout=30;

method=GET;........

-------------------------------

I am sorry i cant give the other script information as it includes the API keys etc however if there is any other information just let me know and i will attempt to provide.

I am stuck now and open to ideas.

Thank you Very much

[sasiparupudi1]

Should work..try the variable in quotes

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;

url='$(vURLDownload)';

timeout=30;

method=GET;........

[Anonymous]

HI,

Thank you for your suggestion but i have already tried this and i get the following error message.

[sasiparupudi1]

May be try like this

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url="& "$(vURLDownload)" & ";

timeout=30;

method=GET;........"

[Anonymous · Accepted solution]

I played around, the following script has worked for me.