topic Re: Getting app object metadata via REST API in Qlik Cloud in Data Movement & Streaming

Getting app object metadata via REST API in Qlik Cloud

dmnab1 — Wed, 19 Mar 2025 22:43:16 GMT

Hi,

In the company that I work at, we've got many extensions and I want to get rid of most of them. To do that, I'd need first to check which dashboards they are used in.

I couldn't find it in https://qlik.dev/apis/rest/

I've seen there's an application "Extension Usage Dashboard-master" but unfortunately doesn't seem to be compatible with Qlik Cloud

Any clue? Thank you

Re: Getting app object metadata via REST API in Qlik Cloud

Daniel_Pilla — Fri, 12 Jan 2024 16:45:57 GMT

Hi @dmnab1 ,

This is a great question, and one that is a bit nuanced and evolving. Here is some information:

Object metadata is not yet available RESTfully. This is in active development, but is not yet there. Being able to RESTfully get and set scripts was phase 1 and that has been implemented.
Object metadata can be fetched via the Engine, and there are many ways of doing that (Qlik Application Automation, Qlik CLI, Enigma.js, etc). These vary in complexity and there are caveats to how some operate (e.g., QAA can only open applications with data).
Private sheet metadata is currently only available to the owner of the sheet in Qlik Cloud. This is also changing very soon. There will be a method in fetching all sheet metadata from the engine in the very near future without having to impersonate users.

Option 1:

With all of the above said, the most user-friendly way of getting this data is through using QAA. I have attached a sample automation that loops through each sheet (public, community, and private that you own) and lists out the object types and owners, etc. You do not want to do this for all applications on the tenant as currently QAA can only open apps with data. To use it, create a new automation, provide a name, right-click in the canvas area, and select "Upload workspace".

Just enter in an App Id and it will do the rest for you.

Option 2:

To scan everything in the tenant (because we can open the apps without data) you can use the Qlik-CLI. Again, this will be missing private content owned by other users for now (coming very soon). Here is an example snippet that will iterate through every app on the tenant and return all object titles, IDs, types, and whether they are a master object (including the underlying type).

$filePath = "C:\Test\metadata.csv"; New-Item -path $filePath -type "file" -Force $header = 'Object Title,Object Type,Object ID,App ID,Is Master Object'; Set-Content $filePath -Value $header; $apps = qlik app ls --limit 99999 --json | ConvertFrom-Json; foreach ($app in $apps) { $metadata = New-Object System.Collections.ArrayList; $tempMetadata = qlik app object ls -a $app.resourceId --no-data --json | ConvertFrom-Json; foreach ($object in $tempMetadata) { if (!@('LoadModel', 'sheet', 'appprops').contains($object.qType)) { $objectMetadata = @{}; $objectMetadata | Add-Member -Name appId -Value $app.resourceId -MemberType NoteProperty; $objectMetadata | Add-Member -Name isMasterObject -Value 0 -MemberType NoteProperty; if ($object.qType -eq "masterobject") { $objectType = (qlik app object properties -a $app.resourceId $object.qId --no-data --json | ConvertFrom-Json).visualization; $objectMetadata['qType'] = $objectType; $objectMetadata['isMasterObject'] = 1; } else { $objectMetadata['qType'] = $object.qType; } $objectMetadata['objectId'] = $object.qId; $objectMetadata['objectTitle'] = $object.title; $metadata.add($objectMetadata) | Out-Null; } } $metadata | ConvertTo-Csv | Select-Object -Skip 1 | Out-File -Append $filePath; }

Which will yield something like the below:

Object Title	Object Type	Object ID	App ID	Is Master Object
My Listbox	listbox	12c4cf53-e2e9-44d7-82f7-105ac4ba9716	0c3c8b42-5211-486a-9170-16bf7c6f7874	0
My Line Chart	linechart	16ed0a5b-b0de-4e5c-ba50-0bfa46a2b8bf	0c3c8b42-5211-486a-9170-16bf7c6f7874	0
My Listbox	listbox	29cda91c-07e6-4019-919d-ac193b8acefd	0c3c8b42-5211-486a-9170-16bf7c6f7874	0
My Line Chart	linechart	2a01f1e5-996a-4eac-8591-5257d9a0bfb8	0c3c8b42-5211-486a-9170-16bf7c6f7874	0
My KPI	kpi	31ce1f9a-b470-44e4-942b-db4ae2ba3679	0c3c8b42-5211-486a-9170-16bf7c6f7874	0
My Line Chart	linechart	35421fac-ef16-40df-9354-150edd28a34f	0c3c8b42-5211-486a-9170-16bf7c6f7874	1

Again, this is a changing landscape in Qlik Cloud, so stay tuned for updates.

Cheers,

Re: Getting app object metadata via REST API in Qlik Cloud

dmnab1 — Mon, 15 Jan 2024 12:12:34 GMT

That's what I was looking for! Thanks @Daniel_Pilla for sharing it

Re: Getting app object metadata via REST API in Qlik Cloud

psublue98 — Tue, 30 Jan 2024 21:44:57 GMT

Hi @Daniel_Pilla - I tried option 2 and tested for a single app but get this output in the csv. Is there something I'm missing?

Re: Getting app object metadata via REST API in Qlik Cloud

Daniel_Pilla — Tue, 30 Jan 2024 22:29:56 GMT

Hi @psublue98 ,

What version of PS are you running? The above was built and tested on 7.3.11. I would also add in some logging and breaks to see what is happening along the way and where it breaks.

Cheers,

Re: Getting app object metadata via REST API in Qlik Cloud

psublue98 — Wed, 31 Jan 2024 20:46:47 GMT

Thanks Daniel, certainly closer using 7.4.1. The title isn't coming across though...

Re: Getting app object metadata via REST API in Qlik Cloud

TcnCunha_M — Tue, 28 May 2024 07:33:19 GMT

Hello @Daniel_Pilla Does that "very soon " has arrived?
Because i want migrate from one Tenant to other i facing the issue of Private content not getting

Re: Getting app object metadata via REST API in Qlik Cloud

Daniel_Pilla — Tue, 28 May 2024 16:22:36 GMT

Hi @TcnCunha_M - yes, this is now possible. You can list all sheets within an application using OAuth and the required scopes. You can find a guide on how to do that with Qlik-API here: https://qlik.dev/manage/platform-operations/private-content-bots/ -- For use with the CLI, follow the same steps to setup the OAuth client, and then connect the Qlik-CLI via OAuth.

Hope this helps!

Cheers,

Re: Getting app object metadata via REST API in Qlik Cloud

TcnCunha_M — Fri, 31 May 2024 09:02:24 GMT

about he bookmarks work in the same way ?

Re: Getting app object metadata via REST API in Qlik Cloud

TcnCunha_M — Fri, 07 Jun 2024 08:52:14 GMT

Hi @Daniel_Pilla

I am trying but my apps has session access. so even if using AUTH0 authentication doesn't work and I'm getting access is denied, I have added the Qlikbot user into the session access, Do you have any idea if there a trick to overlap this?

Re: Getting app object metadata via REST API in Qlik Cloud

Raju_6952 — Sat, 08 Mar 2025 04:13:35 GMT

Hi @Daniel_Pilla ,

I have a requirement like in one of the Qlik sense app that has been migrated from client managed I need to fetch both private sheets and private bookmarks from this to cross verify whether all the objects were migrated correctly or not , as a tenant admin I will be able to see public and community content but not the private content?

Any suggestions would be highly appreciated on this.

Regards,

Raju

Re: Getting app object metadata via REST API in Qlik Cloud

Raju_6952 — Sun, 09 Mar 2025 04:08:23 GMT

Hi @Daniel_Pilla ,

Can we also get user's private bookmark details using oauth along with qlik-api.

Regards,

Raju

Re: Getting app object metadata via REST API in Qlik Cloud

anthonyoctil1 — Tue, 22 Jul 2025 12:30:12 GMT

Hello @Daniel_Pilla

Do you have any updates on the availability of this feature ?

"Object metadata is not yet available RESTfully. This is in active development, but is not yet there"

For some customers, we still struggle to explain that a complete backup/recovery of an app (public, community and private sheets) in QlikCloud is not possible

Best regards,

Anthony

Re: Getting app object metadata via REST API in Qlik Cloud

luke_brady — Mon, 25 Aug 2025 15:16:33 GMT

@TcnCunha_M

I'm having the exact same problem, even trying to add the ID of the bot to the section access table doesn't seem to work - still getting access denied with the CLI.

Did you find a way around this?

@Daniel_Pilla

Is there even a way around this?