Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
kdaniels-obrien
Partner - Creator
Partner - Creator

Setting part of a URL as a variable

Hi, 

I am currently calling an API to gather some information from Qlik to store as a variable. I want to set a dynamic URL as a variable. 

This is what I do now: 

SQL SELECT

"id" AS "ConnectionID",
"name" AS "ConnectionName",
"connectionstring" as "ConnectionString"
FROM JSON (wrap on) "root"

WITH CONNECTION (
URL "https://localhost/qrs/dataconnection/",
QUERY "xrfkey" "0000000000000000",
QUERY "filter" "name eq '$(vSvEnvironment)BDI'",
HTTPHEADER "X-Qlik-XrfKey" "0000000000000000",
HTTPHEADER "User-Agent" "Windows"
);

/*connectionstring will have a url=https://(servername)/(part 2)/(part 3)/v1/, this will parse it out*/
Let vURL=  this is where i need help 

 Part 2 and 3 of the url are dynamic and I want to save everything from the https to '/v' as my vURL. The '/v' will always remain the same.  

TIA!

Labels (1)
0 Replies