Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Bimal
Partner
Partner

Acquire meta data from QlikView documents?

Question: We have an internal project to harvest meta data from multiple qvw files to retrieve information on documents, load scripts, sheets, objects, fields, expressions and reports.  I can see that there are APIs that provide different levels of access, e.g. QMS SOAP API and QlikView Javascript API as described here: https://help.qlik.com/en-US/qlikview-developer/April2020/Content/QV_HelpSites/APIsAndSDKs.htm 

I can see in the QMS wsdl that we can use get fields but how to identify expressions and load scripts please?  I'm using Java rather than VB / .NET.  Any guidance appreciated.

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Did you try to load the xml-metadata of the qvw's? If not just use the table-wizard to pick the qvw and choose xml as file-format.

- Marcus

MichaelRobertshaw

The QMS API is SOAP-based, and enables you to inspect/maintain the QlikView deployment infrastructure but not the contents of the QlikView documents.

To see inside QlikView documents you'll need to consider the OCX API or OLE Automation using the QlikView client. There is no convenient Java API for QlikView. 

https://help.qlik.com/en-US/qlikview-developer/latest/Subsystems/Automation/Content/QV_Automation/au... 

QFabian
Specialist
Specialist

The best way without making code by yourself is QV Document Analyzer : 

https://qlikviewcookbook.com/tools/#squelch-taas-accordion-shortcode-content-6

@rwunderlich 

QFabian
rwunderlich
MVP & Luminary
MVP & Luminary

I've used com4j in the past to bridge java into the OLE Automation COM Api.  It works, still requires you to run a desktop.

You can get some information reading the xml metadata in the qvw files --  some document properties, Tables, Fields, Objects and Expressions used in the Expression pane.  No script or attribute expressions. 

You might also consider running my free Document Analyzer tool in batch (https://qlikviewcookbook.com/2017/07/document-analyzer-batch-analysis/) to collect data and process the CSV and QVD output with a tool of your choice. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com