Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am looking to get all chart names or IDs from QlikSense App of sheets.
In the QMC app object, we can find all sheets but not all charts.
What method does the NPrinting designer use to get all charts, and how can we achieve this in Qlik or any other way?
Your help would be greatly appreciated.
Best Regards,
Arunesh
Hi @aruneshgupta,
If your environment is Qlik Cloud, you can use an Automation like the one below:
This is the output:
Another option, if you are comfortable using Rest APIs, is to use Get Evaluations Qlik Cloud End Point:
https://qlik.dev/apis/rest/apps/#get-v1-apps-guid-evaluations
Please let us know if you are using Qlik Sense on-prem. There are other alternatives if that is your environment.
Thank you @marksouzacosta !
I am using Qlik Sense on-prem. I would appreicate if you could tell me somehing for on prem?
Best Regards,
Arunesh Kumar
If you add "/options/developer" to the end of the url, you can right click on the objects and select "developer" in the menu. There you can see the ID + other info about the object.
No, actually I have many applications and I am looking for a way to list the charts for each sheet. Instead of manually listing them, I thought there might be an automated way to get this list.
Best Regards,
Arunesh Kumar
Ok so, for on-prem you can develop your own solution to consume the data from QRS API. The Endpoint you are looking for is:
This is one example of a request I did to collect some objects from an App ID in a custom .NET Application:
var getRequestUrl = $"/qrs/app/object/full?filter=app.id eq {appId} and ((objectType eq 'sheet') or (objectType eq 'dimension') or (objectType eq 'measure') or (objectType eq 'masterobject'))";
You can also try the use a PowerShell Script provided by Qlik that does the magic. This is probably the fastest way. More information here:
Qlik Sense QRS API - get full App Objects
Regards,
Mark Costa
Thanks for your reply Kim.. I am not good to use API.. but I have tried to use Powershell script which gives full infomation till sheet label but not object/chart names..
Best Regards,
Arunesh
May be try this 'add sense' google extension from Erik to get object names -
https://upper88.com/addsensechrome.html