topic Re: Power shell scripting to delete multiple bookmarks owned by users in Integration, Extension & APIs

Power shell scripting to delete multiple bookmarks owned by users

Raju_6952 — Sun, 10 Nov 2024 14:32:44 GMT

Hi,

I am planning to below power shell scripting to delete the bookmark owned by specific users and that are never published.

Is this code finde or need to make any changes here.

# Define your Qlik server, app ID, and credentials

$qlikServer = "https://<QlikServer>:4242"

$appId = "<YourAppID>"

$headers = @{

"X-Qlik-User" = "UserDirectory=Internal;UserId=sa_repository"

}

# Define a list of specific owners (usernames) whose unpublished bookmarks should be deleted

$specificOwners = @("user1", "user2", "user3") # replace with actual usernames

# Step 1: Get all bookmarks in the app

$bookmarks = Invoke-RestMethod -Uri "$qlikServer/qrs/bookmark/full?filter=app.id eq '$appId'" -Headers $headers -Method Get

# Step 2: Loop through bookmarks and delete only unpublished (never published) bookmarks from specific owners

foreach ($bookmark in $bookmarks) {

# Check if the bookmark is unpublished (no publishTime and published is false) and the owner is in the specified list

if (-not $bookmark.publishTime -and !$bookmark.published -and $specificOwners -contains $bookmark.owner.userId) {

# Delete the unpublished bookmark

$bookmarkId = $bookmark.id

Invoke-RestMethod -Uri "$qlikServer/qrs/bookmark/$bookmarkId" -Headers $headers -Method Delete

Write-Output "Deleted unpublished bookmark with ID: $bookmarkId, owned by $($bookmark.owner.userId)"

}

Any suggestions would be highly appreciated.

Regards,

Raju

Re: Power shell scripting to delete multiple bookmarks owned by users

Marc — Tue, 15 Apr 2025 04:17:07 GMT

This will only remove the bookmarks from the QRS (Metadata), they will still exist in the App Binary file.
to remove them from the binary, you need to use the engine APIs to remove the Bookmarks from the app.

e.g. Qlik Sense SDK,

You will need a process similar to the one outlined here: Exporting-Qlik-Script-QVS-with-Powershell-QSefW to get the $QEApp so you can call DestroyGenericBookmark with the Bookmark Engine ObjectID
$QEApp.DestroyGenericBookmark($bookmark.EngineObjectID)

Re: Power shell scripting to delete multiple bookmarks owned by users

Raju_6952 — Tue, 15 Apr 2025 04:22:03 GMT

Hi @Marc ,

We got some python script which can be used to delete the bookmarks from app binary by listening the bookmarks object ifs in the CSV file .

Regards,

Raju

Re: Power shell scripting to delete multiple bookmarks owned by users

Marc — Tue, 15 Apr 2025 13:41:55 GMT

if you are just deleting the app objects from the QRS, you can use the QlikSenseCLI in the tools folder

Import-Module 'C:\Program Files\Qlik\Sense\Tools\QlikSenseCLI\QlikSenseCLI.psd1' Connect-QlikSense $specificOwners = @("user1", "user2", "user3") # replace with actual usernames $appId = 'AppGuid' $QSBookmarks = Get-QSAppObject -Filter "app.id eq $($appId) and ObjectType eq 'bookmark' and ($(($specificOwners|%{"Owner.userid eq '$_'"}) -join(" or ")))" foreach($QSBookmark in $QSBookmarks){ Remove-QSAppObject -Id $QSBookmark.id }