Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR June 25, 2025: Build on Apache Iceberg with Qlik Open Lakehouse - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
blaise
Partner - Specialist
Partner - Specialist

[QlikCloud] Get private sheets with API

Hi

For Qlik Cloud i would like to list all sheets, regardless if they are private or not (app in managed space). I tried with a node.js app together with @qlik.SDK and an OAuth2 client (M2M) but my code only lists public sheets - anyone know a solution?

const Qlik = require('@qlik/sdk').default;
const { AuthType } = require("@qlik/sdk");

//config-values
const host = 'xxx.eu.qlikcloud.com';
const clientId = 'asdfasdfasdfasdfasdf';
const clientSecret = 'asdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdf';
const appId = 'asdfasdfasdfasdfasdf';

const config =  {
  authType: AuthType.OAuth2,
  host: host,
  clientId: clientId,
  clientSecret: clientSecret
};

(async () => {
  const qlik = new Qlik(config);
  await qlik.auth.authorize();
  const app = await qlik.apps.get(appId);
  await app.open();

  const oList = await app.getObjects({
    qTypes: ["sheet"],
    qIncludeSessionObjects: true,
});
  console.log(oList);
  process.exit();
}
)();
Labels (2)
5 Replies
jprdonnelly
Employee
Employee

@blaise - Unfortunately, this is not currently possible. Product is working towards this capability, but at this time, private content is not addressable/manageable by an Admin role.

- @jprdonnelly
Jeffrey_Goldberg
Employee
Employee

@blaise , this is indeed coming soon. FYI, I recommend checking out @qlik/api as well. Very similar to your code up above, but with official Qlik supported typescript typings.

Learn more about qlik/api here and stay tuned to the SaaS what's new and qlik.dev changelog for updates on private content.

alessandrozagoto
Contributor III
Contributor III

 

To obtain the list of sheets in an application using Qlik Cloud, use the rest 
evaluations API, it returns the list of all public sheets.
POST/v1/apps/{guid}/evaluations
GET/v1/apps/{guid}/evaluations

 

paulcalvet
Partner - Specialist
Partner - Specialist

Hello @jprdonnelly

Any news on this topic ? I need access to retrieve all sheets on my tenant to monitor licence usage 🙂

Thanks,

 

paulcalvet
Partner - Specialist
Partner - Specialist