Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
VijaySekar
Contributor II
Contributor II

How to get Space -> Apps -> Sheets information into a QVD file using single Automation

I am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to achieve this in Qlik Sense SaaS version please.?

Ex. I need to create a table like below

SpaceName     AppName    SheetName                             SheetType

Dev                  Test              Space_App_Sheets                Public

Prod                 Test1            Demo                                      Private

Labels (3)
18 Replies
VijaySekar
Contributor II
Contributor II
Author

This is what i want. Thanks for the solution DaveChannon. 

Harsha-Lodha
Contributor III
Contributor III

Hello @DaveChannon  Thank you for sharing this. I am trying to track the changes in the app on backend (such in load script or data connection) also frontend changes (such as addition of new sheet or change in expression). I want to use this to trigger my automation to backup that app. When I make any backend changes App's Modified date changes. Can you please help tweak your automation a bit to use this to track or just get flagged if there are any frontend changes in any apps.

Napus
Contributor II
Contributor II

I successfully ran the automation. Could you please explain how I can save this file to SharePoint?

salmankojar
Partner - Creator II
Partner - Creator II

Hi @Napus you can use Create CSV File Block from Microsoft Sharepoint Connector and write data in it using Loop Block and in Loop block pass all the data list in it.

Napus
Contributor II
Contributor II

Hi @salmankojar , 
thanks for the reply. would you please tell me how i can do it step by step i am so new to the topic. 
I added these 3 SharePoint node, the automazione give me exactly list of Managed spaces with their App as i want. but i can't save them in QVD or CSV. I will add the node i added -> 

 

 

salmankojar
Partner - Creator II
Partner - Creator II

Hi @Napus , i have altered the Automation as per your requirement. please use the attached Automation json file and make necessary changes as per your storage location.

Napus
Contributor II
Contributor II

Thanks a lot it works now @salmankojar 🙏. I have only a question when we create an app in QlikSense every app also have description. in this automation we retrieve App Id and App Name. Is is possible also to retrieve every app Description? 

Thank you so much 🙂

salmankojar
Partner - Creator II
Partner - Creator II

Hi @Napus you can use Get APP Information block and pass your app Id in it.you will get description of the App from this block's output as shown in image below.

salmankojar_0-1737631828602.png

 

Napus
Contributor II
Contributor II

Thank you so much @salmankojar it works now as i expected.