topic Re: Qlik Sense License Management through API in Integration, Extension & APIs

Qlik Sense License Management through API

ghaliabed — Mon, 23 Jul 2018 15:48:43 GMT

Hello

We are working on a project to possibly manage the assignment/removal of license using API calls and event triggered events.

The goal is to address the below cases:

Continued monitoring and deallocation of licenses for Users that have never used it
Bulk allocation/removal of licenses to users (ex: list defined in an excel sheet)
The assignment of a full license for users leveraging group tokens but are consuming too many shared tokens

Where can we find documentation or the correct APIs to build such features against our Qlik Sense server.

We have qliksense server running on version: Qlik Sense June 2018 12.26.1

Currently we are checking the following API calls but nothing substantial has been found yet, based on documentation found here.

GET /qrs/license/loginaccessusage/{id}?privileges={appendprivileges}
GET /qrs/selection/{id}/license/loginaccessusage/full?filter={filter}&orderby={orderby}&privileges={appendprivileges}

Any help on this is very appreciated

Re: Qlik Sense License Management through API

Levi_Turner — Mon, 23 Jul 2018 19:41:37 GMT

Continued monitoring and deallocation of licenses for Users that have never used it

DELETE /qrs/license/useraccesstype/ID

Example code: https://github.com/levi-turner/QlikSenseScripts/blob/master/qlik_sense_purge_unused_user_access_passes.ps1 (uses Qlik CLI)

Bulk allocation/removal of licenses to users (ex: list defined in an excel sheet)

Adding: POST /qrs/license/useraccesstype

Body (where ID = the ID of the user): {"user": {"id": "447d3ce4-5492-41bb-99c6-460456ae4363"}}

Removing: Same as above

Re: Qlik Sense License Management through API

weiqiang_wang — Tue, 11 Dec 2018 07:19:46 GMT

But why I got "(400)Bad Request" when I try to POST /qrs/license/useraccesstype with your method.

the url I am posting to is: https://***.southeastasia.cloudapp.azure.com:4242/qrs/license/useraccesstype?Xrfkey=Dorph1HyqLsZGeKg

And I found most open api end points with GET method working well, such as:

https://***.southeastasia.cloudapp.azure.com:4242/qrs/user?Xrfkey=Dorph1HyqLsZGeKg

Re: Qlik Sense License Management through API

ryanplkam — Wed, 08 Jul 2020 16:22:42 GMT

@Levi_Turner , I'm trying to de-allocate professional licenses based on the user's id... will this work

{FQDN}:4242/qrs/license/professionalaccesstype/full?Xrfkey=1234567890123456&filter=(user.id eq 'f5806d7d-6758-4422-b803-1b2fd3950fa4')

I tried this but it says

Cannot convert the constant value "Guid" to the following: f5806d7d-6758-4422-b803-1b2fd3950fa4

Re: Qlik Sense License Management through API

Levi_Turner — Wed, 08 Jul 2020 18:35:36 GMT

The call for removal would be:

DELETE /qrs/license/professionalaccesstype/6fa395c1-4de6-47bf-96e1-5ca484168a9d

So you get the ID from:

GET /qrs/license/professionalaccesstype/full

do your app logic for group membership then call DELETE with the IDs from the GET

Re: Qlik Sense License Management through API

ryanplkam — Fri, 17 Jul 2020 17:33:04 GMT

Thank you! @Levi_Turner

Re: Qlik Sense License Management through API

babitaku — Tue, 06 Apr 2021 14:58:33 GMT

Hi @Levi_Turner ,

Endpoint POST /qrs/license/useraccesstype allocate license for single user.

Is there any way if we could allocate multiple users? Help would be much appreciated.

Thanks!
Babita

Re: Qlik Sense License Management through API

Levi_Turner — Tue, 06 Apr 2021 15:37:33 GMT

Option 1: Just loop over them in your code. In PowerShell it'd be something like

$ids = '1','2' foreach ($id in $ids) { # Do stuff }

But similar approaches exist in all scripting or programming languages.

Option 2: Toy with the Selection endpoint (https://help.qlik.com/en-US/sense-developer/APIs/RepositoryServiceAPI/index.html?page=1099) which allows you to do edits to multiple things. It's how the QMC works. I honestly haven't played with this approach at all myself.

Personally, option 1 is easier to deploy, simpler to understand and maintain, and is more conducive to adding robustness checks / logging.

Re: Qlik Sense License Management through API

babitaku — Thu, 08 Apr 2021 05:04:28 GMT

Thank you @Levi_Turner for the quick response.

But, how to call Qlik api endpoint from powershell? Also, the id which we pass in loop, is that GUID or Name?

Thanks!

Babita

Re: Qlik Sense License Management through API

Giovanni_Civardi — Tue, 21 Sep 2021 09:04:07 GMT

hi guys,

I managed to create a script that assign tokens getting users from csv file. The tokens are correctly assigned and binded to the users in QMC but opening an app I still get the No Access Pass error. Any idea?

thanks in advance,

best,

Re: Qlik Sense License Management through API

Jaeger — Thu, 21 Dec 2023 08:51:30 GMT

GET /qrs/license/analyzeraccesstype/full

works but I get 403 (Forbidden) if I try to

DELETE /qrs/license/analyzeraccesstype/{id}

I am admin and I can deallocate and delete users from qmc.
So what to do?