Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mr_novice
Creator II
Creator II

Rest Connector with variable as query parameter

Hi All!

Im working with the REST-connector. Which works fine! But, I need to change one of the query parameters every day. I need to send current date every time in the URL as a parameter and want to create a variable with this date. How can I accomplish this?

Br

Cris

1 Solution

Accepted Solutions
mr_novice
Creator II
Creator II
Author

This works fine. I created a dummy REST-connection to "open a connection". Then its modified by the "with connection".

LIB CONNECT TO 'DummyGetConnection';

LET vStartDate = date(addmonths(Today(),-6),'D.M.YYYY');

LET vEndDate = date(Today(),'D.M.YYYY');

Let vURL = 'https://X/NordicSharesEOD/EODPricesDD?';

LET vURL = vURL & '&token=GUSER-31fbe38f-43d9-427f-8dfa-b6e82570';

LET vURL = vURL & '&todate=' & '$(vEndDate)';

LET vURL = vURL & '&fromdate=' &  '$(vStartDate)';

LET vURL = vURL & '&Accept=text/json';

[DailySymbols]:

SQL SELECT

"symbol",

"trading_date",

"official_last",

"paid_first",

"paid_high",

"paid_low",

"volume_traded",

"exchangename"

FROM JSON (wrap on) "root" QDL

WITH CONNECTION (

URL "$(vURL)"

)

;

View solution in original post

3 Replies
mr_novice
Creator II
Creator II
Author

Hi,

I created this script but it throws me an error "There is no open data connection. The generated URL is correct and I can copy it from the error message and paste it in the browser and it works. Any ideas what to do? How can I open the connection?

Im using QlikSense Business Cloud.

LET vStartDate = date(addmonths(Today(),-6),'D.M.YYYY');

LET vEndDate = date(Today(),'D.M.YYYY');

Let vURL = 'https://X/NordicSharesEOD/EODPricesDD?';

LET vURL = vURL & '&token=GUSER-1f13bf6d-516e-4d0f-96fe-93011d77c791';

LET vURL = vURL & '&todate=' & '$(vEndDate)';

LET vURL = vURL & '&fromdate=' &  '$(vStartDate)';

LET vURL = vURL & '&Accept=text/json';

[DailySymbols]:

SQL SELECT

"symbol",

"trading_date",

"official_last",

"paid_first",

"paid_high",

"paid_low",

"volume_traded",

"exchangename"

FROM JSON (wrap on) "root" QDL

WITH CONNECTION (

URL "$(vURL)"

)

;

Any help or suggestion is appreciated.

Br

Cris

mr_novice
Creator II
Creator II
Author

This works fine. I created a dummy REST-connection to "open a connection". Then its modified by the "with connection".

LIB CONNECT TO 'DummyGetConnection';

LET vStartDate = date(addmonths(Today(),-6),'D.M.YYYY');

LET vEndDate = date(Today(),'D.M.YYYY');

Let vURL = 'https://X/NordicSharesEOD/EODPricesDD?';

LET vURL = vURL & '&token=GUSER-31fbe38f-43d9-427f-8dfa-b6e82570';

LET vURL = vURL & '&todate=' & '$(vEndDate)';

LET vURL = vURL & '&fromdate=' &  '$(vStartDate)';

LET vURL = vURL & '&Accept=text/json';

[DailySymbols]:

SQL SELECT

"symbol",

"trading_date",

"official_last",

"paid_first",

"paid_high",

"paid_low",

"volume_traded",

"exchangename"

FROM JSON (wrap on) "root" QDL

WITH CONNECTION (

URL "$(vURL)"

)

;

nategreen
Contributor III
Contributor III

I am having a similar issue wit a Rest connection where i need to have a dynamic date in the query parameter (yesterday). When i run the connection in legacy mode with the date as a QS variable, i get an authorization error. However, when i use the QS data connection with authorization, i can't figure out how to pass the QS variable to the data connection's query parameter. How are you retrieving the "&token=GUSER-31fbe38f-43d9-427f-8dfa-b6e82570" from the data connection in the above example? do you have a recommendation of how to execute my problem?

thx!

Nate