How to delete sheets(IDs available in external sheet) via repository API

[rohitk1609]

Hi techies,

I have a use case where I need to delete Qlik app sheets which are unused since last one year. I have collected the concern sheet ids from operation monitoring app. Lets say concern sheets are 500 from 1 app. I am looking for a way that I delete such sheets from   repository API by picking sheet ids from external sheet which has sheet id exported from operation monitoring app.

I have found a document which has information how to delete single sheet in one request but I need to send request for all 500 sheets in one go, like picking sheet id one by one and send request to QSR database via API.

https://support.qlik.com/articles/000055464

Please help me to achieve my goal

Thanks in Advance

Rohit

[rohitk1609]

Hi Levi,

I am about to acheieve my goal but stuck at last point where #npm install is failing. 

I don't have internet at my Qlik server where I install node.js

This is the error I am getting:

Please guide me how to fix it ?

Thanks,

Rohit

[Levi_Turner]

> Please guide me how to fix it ?

This is a Node question, so there may be guides online for how to install node modules without internet connectivity. What I'd do? I'd use some machine with internet access (e.g. your laptop) to complete the npm install step then move the entire directory with the downloaded modules to the server.

[Levi_Turner]

> Sort of Last Accessed column will rearrange table with such entries on top which has dates. On other hand, can you please suggest how to filter such records which has null in Last Accessed field. Where I am struggling, selection is not possible of null value in any field of table chart and filter is not allowing me to do so.

Yes, you cannot select null values. @Tyler_Waterfall : This would be an improvement for the Operations Monitor.

> Checking published date of any app is not enough to make the app go to Quarantine state, Published date data is available since you keep your log data, in my case I keep log data for last 3 months and centralized logging is off too . There are few apps whose Last Accessed Date is null this is possible due to Qlik migration issue or logging is off. Apps whose Last Accessed field value is null could have Last Reload date is lately. Perhaps Full load data extraction apps which usually run once in a while, these kind of apps have no visual to show, so people usually don't open it unless there is any need. So my point is we should take care of Last Reload time too before sending any app to Quarantine Stream.

Yes, the guide is intended to be a starter pack for guidance. It is expected to be adjusted to fit the organizational requirements. If your environment has apps where it isn't uncommon for some apps to be unused for months to quarters at a time, then don't remove them. This is relatively unusual but by no means unknown.

[rohitk1609]

Hi Levi,

I have successfully tested your solution https://adminplaybook.qlik-poc.com/docs/asset_management/apps/flag_unused_base_community_sheets.html

and I pretty sure I would do https://adminplaybook.qlik-poc.com/docs/asset_management/apps/remove_unused_private_sheets.html

Thanks for this important admin doc. I am sure this solution will be a milestone in admin work.

Thanks,

Rohit