Setting part of a URL as a variable

[kdaniels-obrien]

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!