article Exporting and importing Security rules using Qlik-Cli in Official Support Articles

Exporting and importing Security rules using Qlik-Cli

Andre_Sostizzo — Wed, 02 Jun 2021 18:35:51 GMT

Scenario:

Have Qlik-Cli installed and configured (see How to install Qlik-CLI for Qlik Sense on Windows) for more insight on how to install and configure Qlik-Cli)
Create a PowerShell script using the following code as a base:

! Note that the code is provided as is and will need to be modified to suit specific needs. For assistance, please contact the original creators of Qlik-Cli.

Connect-Qlik -computername "QlikSenseServer.company.com"
# This will export the custom security rules and output them as secrules.json
Get-QlikRule -filter "type eq 'Custom' and category eq 'security'" -full -raw  | ConvertTo-Json  | Out-File secrules.json
# This will import secrules.json into a Sense site
# The ideal use case would be to move the developedsecurity rules from one environment to another, so connecting to another Sense site would likely be needed here
Get-Content -raw .\secrules.json |% {$_ -replace '.*"id":.*','' } | ConvertFrom-Json | Import-QlikObject

Environment:

, all versions

Re: Exporting and importing Security rules using Qlik-Cli

Jio — Tue, 07 Mar 2023 14:42:39 GMT

Hi i try to use the above qlik-cli commands.
The export works well n oproblem, but when i try to import the security rules, i got the error
Invoke-RestMethod : The remote server returned an error: (403) Forbidden.
At C:\Program Files\WindowsPowerShell\Modules\Qlik-Cli\functions\core.ps1:65 char:23
+ ... $result = Invoke-RestMethod @paramInvokeRestMethod @params
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand
Anyone an idea what the problem is and an idea how i can resolve this?

Re: Exporting and importing Security rules using Qlik-Cli

Sonja_Bauernfeind — Mon, 13 Mar 2023 09:47:13 GMT

Hello @Jio

As we do not provide direct support for this tool, I would recommend that you contact the Qlik-CLI subject matter experts directly. You can do so here: https://github.com/ahaydon/Qlik-Cli-Windows/issues

All the best,
Sonja

Re: Exporting and importing Security rules using Qlik-Cli

Giovanni_Civardi — Mon, 07 Jul 2025 07:01:23 GMT

The regex '.*"id":.*' is quite aggressive and will remove any line containing "id":, even if it is part of a string value. For a safer approach I would suggest:

Get-Content -raw .\test_secrules.json | ConvertFrom-Json | select-object * -ExcludeProperty id | Import-QlikObject -Verbose