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!