topic Re: How to get Space -> Apps -> Sheets information into a QVD file using single Automation in Qlik Automate

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

VijaySekar — Fri, 23 Feb 2024 15:44:13 GMT

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

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

henrikalmen — Sat, 24 Feb 2024 12:42:24 GMT

I suggest you take a look at the monitoring apps - they have that kind of information. You can learn from their code how to do it, or you can modify the approporiate monitoring app so that it stores the data you want in a qvd.

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

salmankojar — Mon, 26 Feb 2024 10:42:54 GMT

Hi @VijaySekar ..using Qlik Automation you can create csv with all the columns you mentioned..you can even store it in Cloud Database Like GCP or SQL server Directly..you can also regularly update it on schedule..but from Automation you cant store in Qvd..
for storing in Qvd you can use qlik app...

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

Dave_Channon — Mon, 26 Feb 2024 11:08:10 GMT

For Qlik Cloud, you'll want these monitoring apps instead: https://community.qlik.com/t5/Official-Support-Articles/The-Qlik-Sense-Monitoring-Applications-for-Cloud-and-On-Premise/ta-p/1822454

It's also important to note that in Cloud, you cannot currently retrieve a list of private sheets.

You can, as @salmankojar said, create an automation to create a list of spaces, apps, and sheets (which you have access to), then store these to CSV (we don't have a native QVD adapter).

The main complexity with doing this is your user needs to be a member of every space with consumer access in order to open the list of sheets in the app.

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

VijaySekar — Mon, 26 Feb 2024 12:05:04 GMT

Hi Salmankojar

How can we get the list of public sheets from an app. Could you please share any reference to this?

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

salmankojar — Mon, 26 Feb 2024 13:11:36 GMT

@Dave_Channon There is no need to add member all spaces..you can create the automation with the Admin Id and run that automation on schedule everyday..it will get all the apps and its sheets from all spaces and store it into Csv file..

@VijaySekar As i said earlier this can be done through Automation but there is no reference for it..

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

Dave_Channon — Mon, 26 Feb 2024 13:38:24 GMT

OK, if you're using a TenantAdmin or AnalyticsAdmin then you'll be fine. I have an example from a while back:

Automation code attached

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

VijaySekar — Mon, 26 Feb 2024 14:35:51 GMT

Hi DaveChannon

How do i use this json file in qlik?

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

Dave_Channon — Mon, 26 Feb 2024 15:00:39 GMT

Once logged into Qlik Cloud:

Click Add New
Click New Automation > Blank > Create (will open the canvas)
Right click on the canvas and select upload, select the JSON file and submit
You'll see the automation and should be able to run it

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

salmankojar — Tue, 27 Feb 2024 05:11:55 GMT

Hi @Dave_Channon i was talking about this Automation only..

@VijaySekar you can use this automation and store your data in some online database like SharePoint or one drive or google drive and run it on schedule every day to have latest data.

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

VijaySekar — Wed, 28 Feb 2024 16:14:20 GMT

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

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

Harsha-Lodha — Tue, 16 Jul 2024 02:06:04 GMT

Hello @Dave_Channon 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.

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

Napus — Wed, 15 Jan 2025 14:43:36 GMT

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

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

salmankojar — Thu, 16 Jan 2025 03:54:18 GMT

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.

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

Napus — Tue, 21 Jan 2025 10:09:48 GMT

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 ->

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

salmankojar — Wed, 22 Jan 2025 11:22:22 GMT

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.

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

Napus — Thu, 23 Jan 2025 10:49:37 GMT

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 🙂

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

salmankojar — Thu, 23 Jan 2025 11:30:42 GMT

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.

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

Napus — Thu, 23 Jan 2025 16:02:57 GMT

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