
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @DaveChannon 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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is what i want. Thanks for the solution DaveChannon.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For Qlik Cloud, you'll want these monitoring apps instead: https://community.qlik.com/t5/Official-Support-Articles/The-Qlik-Sense-Monitoring-Applications-for-C...
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Salmankojar
How can we get the list of public sheets from an app. Could you please share any reference to this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@DaveChannon 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..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi DaveChannon
How do i use this json file in qlik?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @DaveChannon 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.

- « Previous Replies
-
- 1
- 2
- Next Replies »