topic filters for qlik license consumption ls in Integration, Extension & APIs

filters for qlik license consumption ls

matteoredaelli — Fri, 22 Dec 2023 17:05:35 GMT

Hello

Which filters can I use for

filters for qlik license consumption ls

I cannot find any info at

https://qlik.dev/toolkits/qlik-cli/license/license-consumption-ls/

I'd' like to filter for endTime and LicenseUsage

but I get

```

qlik license consumption ls --filter 'licenseUsage eq "ASSIGNED_LICENSE"'

Error: {
"error": "LICENSES-InternalServerError",
"message": "could not convert filter, expression is invalid: unsupported attribute received: licenseusage",
"errors": [
{
"code": "LICENSES-037",
"title": "could not convert filter, expression is invalid: unsupported attribute received: licenseusage"
}
]
}

Re: filters for qlik license consumption ls

jprdonnelly — Wed, 27 Dec 2023 14:23:04 GMT

@matteoredaelli - it appears that the endpoint does not support filtering with the licenseUsage attribute, though it does work with endTime.

qlik license consumption ls --filter 'endTime ge "2023-11-21T18:21:51.635Z"'

Another option would be to parse using PowerShell or jq to help isolate the values

qlik license consumption ls --raw | jq '.data[].licenseUsage'

Re: filters for qlik license consumption ls

Dave_Channon — Tue, 02 Jan 2024 11:15:43 GMT

For future reference, you should be able to tell which fields are filterable by looking for filterable in the response property list (note filterable is tagged only against endTime) on https://qlik.dev/apis/rest/licenses/#%23%2Fdefinitions%2FconsumptionEventsResponse

Re: filters for qlik license consumption ls

matteoredaelli — Thu, 04 Jan 2024 09:45:51 GMT

Many thanks!

Re: filters for qlik license consumption ls

matteoredaelli — Thu, 11 Jan 2024 09:06:14 GMT

Hello

I can see the "filtrable" text from your screenshot but I cannot find it following the link you shared...

Regards

Matteo

Re: filters for qlik license consumption ls

Dave_Channon — Thu, 11 Jan 2024 11:15:16 GMT

You might need to follow the link and then Ctrl+F in the browser. We currently have a problem with qlik.dev which isn't taking you to deep links correctly (sorry!). Or search for consumptionEventsResponse and go from there.