List all private sheets in a published app using Qlik Automation

[Congrid]

I'm looking to extract a list of all private sheets(objects) in an app owned by all users using Qlik Automation.

The List sheets block under Qlik Cloud Services only gives me a list of public sheets and private ones that I own.

I know its possible via CLI but checking if its possible via Qlik Automation.

[Dave_Channon · Accepted solution]

The Qlik Cloud Services connector can only call using the current user's auth. To retrieve all sheets you must use the admin.apps scope and a machine-to-machine OAuth client, and we don't have a connector designed to make engine calls at this time which can accept that auth.

For now, CLI is the preferred route, however coming soon is REST API access to this information.

Is there anything you can share about your use case for this data to help us determine whether what we're working on will be sufficient?

[Congrid]

Hi Dave, 

Thanks for this information, looking forward to the new API.

My use case is from an administration perspective.

I am looking for a possible solution where I can identify all the private user sheets, filter on the one I need and change its owner.

[Dave_Channon]

Thanks! That aligns well with our roadmap item.