Export data from Pivot Table in a mashup

blink — Thu, 23 Jun 2022 14:58:11 GMT

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

Re: Export data from Pivot Table in a mashup

blink — Thu, 23 Jun 2022 14:57:40 GMT

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).

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?

topic Re: Export data from Pivot Table in a mashup in Integration, Extension & APIs

Export data from Pivot Table in a mashup

Re: Export data from Pivot Table in a mashup