Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
blink
Contributor II
Contributor II

Export data from Pivot Table in a mashup

Hi everyone,

 

I'm building a Qlik Sense mashup. The mashup has several tables ("VizlibTable" and  "VizlibPivotTable").

I'm using a Capability API's exportData method to export data. It works great for charts and tables, but it doesn't work for Pivot tables. For Pivot tables I always get an error:  { code: 13001, message: "no data" } .

 

The questions are: Why I get this error? and How can I export data from pivot tables in a mashup?

 

Thanks in advance

Labels (3)
1 Reply
blink
Contributor II
Contributor II
Author

I've found out that my exportData() request has different handle from other this table requests, like pagination.

I get a model using Capability API's getObject() method. Then I use the model to make an exportData() request.

const model = await application.getObject('htmlId', 'tableId';)

model.exportData(options);

This request has handle (54) and it ends with an error. As you can see on the image, the pagination request has another handle (59).

blink_1-1655996197445.png

All other charts and tables in the mashup works fine, I can export data. But I can't do it for "VizlibPivotTable". Any ideas why is this happening?