Vizlib Home Try Vizlib
Welcome
Login

Vizlib Custom Report Best Practice and Troubleshooting - Exporting Objects Located in a Mashup

This article contains instructions that can be used as a workaround for exporting Mashup Objects within Vizlib Custom Report


TABLE OF CONTENTS


Enable Developer Option


The following procedure allows you to get the export URL of the object nested inside the Vizlib Custom Report.


  • On the Qlik Sense sheet where the Vizlib Custom Report object is located, add "options/developer" at the end of the URL 
  • Right-click on the Vizlib Custom Report object and select "Developer"


Figure 1: Developer


This will give you the ID of the Vizlib Custom Report object (take note of this ID, we will need it later).


Figure 2: Custom Report ID


Back to Contents


Engine API Explorer 



Figure 3: Connect to Engine


  • Select the GetObject function, add the ID of the Vizlib Custom Report object in the request, and click on the Execute button


Figure 4: GetObject 


  • Now we can see that a new object has been added to the table: Select the GetProperties method, and click on the Execute Button.


Figure 5: GetProperties


  • In discovered objects, you will find the IDs of the objects that are nested inside the Vizlib Custom report. In my case, I only have one table, so I will only see one ID. Choose the relevant ID of the discovered object that you would like to export and click on the Execute button.


Figure 5: Select Object


  • On the newly selected object, please select the ExportData method and change the params of the Request with the following value: "params": [ "OOXML", "/qHyperCubeDef" ] 


Figure 6: ExportData


  • The output of the last step should give you the export URL of the object that has been selected:


Figure 7: Export 


Note: You will see here that the export file contains all the data defined inside the master item data set that is connected with the Custom Report. So it won’t be filtered. All this happens internally inside the Custom Report and we are not able to get filtered data.


Back to Contents

 

D
Daniel is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.