topic Re: audits api for capturing sheet usage by date? in Integration, Extension & APIs

audits api for capturing sheet usage by date?

110 — Thu, 05 Jun 2025 08:29:08 GMT

I've been asked on some of our self-serve apps to review usage.

Where users are able to build their own sheets in the app, some now have 80+ sheets, and from the app itself or the current Qlik monitoring apps, it's hard to tell which sheets are in regular use, either by automation runs or by users accessing the sheets.

I've managed to pull the Audit Log archive by data from the below API

https://qlik.dev/apis/rest/audits/#get-v1-audits-sources

It's not clear in the documents, but is it possible to drill to only audit request that:

use specific app ids
reside in a specific space
event type is a sheet view/interaction or automation step that creates a report page from a sheet

I've already got a subset of apps that I'd like to specifically query on in a Pandas Dataframe already

Is there a way to optimise the Audits ( Archive ) query beyond just date?

Python code - currently just querying by date:

url = "https://MyTennant.eu.qlikcloud.com/api/v1/audits/archive?date=2025-05-04"

resp = requests.get(url, headers=headers).json()

resp[0]

Re: audits api for capturing sheet usage by date?

Dave_Channon — Fri, 06 Jun 2025 11:56:39 GMT

Consider taking a look at https://qlik.dev/apis/rest/audits/. The base audits path offers up the past 90 days of data while accepting filtering by event type, source, time, and originating user. The audits endpoint you're currently using doesn't offer these filters.

Note that sheet usage information is available in the newer versions of the App Analyzer: https://github.com/qlik-oss/qlik-cloud-app-analyzer

Further filtering within the event isn't supported at the moment, but will be something possible in the new telemetry solution we're currently working on.

Re: audits api for capturing sheet usage by date?

110 — Fri, 06 Jun 2025 17:53:34 GMT

Oh very cool! Thanks for sharing.

I can use this as a rough barometer of what's used in a 90-Day rolling window.

Perhaps I can build something to record the 'never-used' sheets that have no recorded sessions and flag those for clean-up.

I just added a sheet with a treemap breaking down App/Sheet by days since last accessed with some eye-burning colours