Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)
3 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