Hi @MendyS ,
You can using the APIs, yes. The easiest way to do this is using the Qlik-CLI. This utility works for both Qlik Cloud and Qlik Sense Enterprise Client-Managed, however the script below was built for Qlik Cloud. If you are using Qlik Sense Enterprise Client-Managed, it will need to be modified (i.e., it would likely be easier to do steps 1-4 below manually and just use the variable removal section which should be pretty much the same across platforms).
In essence, this is the flow:
1. Get the current load script of the app and save it to a file.
2. Set the load script of the app to `exit script;`.
3. Reload the app to make all of the script variables non-script variables so that they can be deleted.
4. Reset the script to the original.
5. Get a list of all variables.
6. Delete each variable (only saving on the last -- this speeds things up dramatically).
The script I've included below does this process automatically. Just set the app Id. Note that you will still have to delete the variables in the script manually from your script of course before you reload the app again.
$app = '<your-appId-here>';
$OutputEncoding = [Console]::InputEncoding = [Console]::OutputEncoding = New-Object System.Text.UTF8Encoding;
$script = qlik app script get -a $app;
Set-Content -Path "current_script.qvs" -Value $script;
Set-Content -Path "empty_script.qvs" -Value 'exit script;'
qlik app script set ./empty_script.qvs -a $app;
$reloadId = (qlik reload create --appId $app | ConvertFrom-Json).id;
$status = $null;
while ($status -ne 'SUCCEEDED') {
Start-Sleep -Seconds 3;
$status = (qlik reload get $reloadId | ConvertFrom-Json).status;
}
qlik app script set ./current_script.qvs -a $app;
$vars = qlik app variable ls -a $app --json | ConvertFrom-Json;
$i = 1;
foreach ($var in $vars) {
if ($i -ne $vars.length) {
qlik app variable rm $var.title -a $app --no-save;
}
else {
qlik app variable rm $var.title -a $app;
}
$i += 1;
}
Remove-Item -Path "empty_script.qvs";
Note that I do not remove the `current_script.qvs` file so you don't lose your original script in case it does not work for whatever reason. I would suggest running the script on a duplicated copy of the app to be safe.
Cheers,
