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.

This topic contains the following sections:

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

 

Engine API Explorer

  • Go to the Engine API Explorer: https://yourdomain.com/dev-hub/engine-api-explorer

  • Connect to engine and select the relevant application.

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 this case, there is only one table, so you 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 6: 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 7: ExportData

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

Figure 8: 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.