Export Data, Image and Pdf from Qlik Sense September 2018 Capability API

[Yianni_Ververis]

In every new Qlik Sense release, we see some cool additions and features that make our life easier. All of the major ones, are discussed here, https://community.qlik.com/blogs/qlikproductinnovation/2018/09/11/qlik-sense-september-2018-has-arri...‌, but for those that work a lot with the Capability Api, there are 3 very much desired and long expected features: exportData, exportImg and exportPdf. With these, you can export any embedded object from your mashup in the above formats. You can also customize them by passing the desired options.

Below are the links to the help files so you can experiment more.

ExportData

https://help.qlik.com/en-US/sense-developer/September2018/Subsystems/APIs/Content/Sense_ClientAPIs/C...

ExportImg

https://help.qlik.com/en-US/sense-developer/September2018/Subsystems/APIs/Content/Sense_ClientAPIs/C...

ExportPdf

https://help.qlik.com/en-US/sense-developer/September2018/Subsystems/APIs/Content/Sense_ClientAPIs/C...‌

You can view all of these in action by visiting the qdt-components webpage

React template with qdt-components

Best,

Yianni

[Yianni_Ververis]

Hello Veggard,

Here it is working but I need to setup the certs properly. Will fix that this week

https://webapps.qlik.com/qdt-components/react/index.html?&_ga=2.226333010.975571039.1539169738-96304...

Check your security rules in the Qmc for "ExportAppData" and "OwnerAnonymousTempContent"

You may need to create another rule that gives access to the anonymous users to read the TempContent_* by a condition like "((user.name="*"))"

[vegard_bakke]

Thank you,Yianni, for swift respons!

I have not looked into the OwnerAnonymousTempContent security rule.  But I have created a copy of the ExportAppData for the stream we use.

But does the OwnerAnonymousTempContent treat anonymous access differently, depending on whether it is an Excel file, or a PNG file? Because the anonymous user can easily download the Excel book.

[vegard_bakke]

My OwnerAnonymousTempContent is

user.IsAnonymous() and resource.anonymousOwnerUserId = user.userId

Which makes sense to me: The content is accessible for anonymous users, but only for the content owned by that particular anonymous user.

I don't understand why this should not work for PNG files, when it works for Excel-files. 😕

[Yianni_Ververis]

OK qdt-components with the new export features is working now

https://webapps.qlik.com/qdt-components/react/index.html#/embed-object

[bramkn]

jvs‌

Can you tell me if the export image call will also be available in the .NET SDK. I have checked last week, could not find it.

[alastairmcdonald]

I have tried this and get the same result.

If i call model.exportData() i get an excel file with the possible values of the table but I am trying to give users the option to download either all values or the possible values.

So according to the documentation i neeed to pass options = { 'state' : 'A' }

or options = { 'state' : 'P' } for all or possible values respectively.

I have tried both and get the following error:

portal.js:25 Qlik error Error: Invalid method parameter(s)

    at t.J (4.b1640e38a27383e10f53.js:8)

    at l (require.js:18)

    at require.js:18

    at f.$digest (require.js:18)

    at require.js:18

    at p (require.js:18)

    at require.js:18

portal.js:27 [Error: Invalid method parameter(s)

    at t.J (https://entademoqap.entadatacenter.com/eton-travel/re…]

I even tried with the adding format to the options object but get the same result:

i.e. options = { format: 'OOXML', state: 'A' } ....etc.

But i get the same result.

Is this a bug?

I have also tried creating a new table from the object model and exporting this as was indicated as the method for earlier verisons of Qlik Sense in various posts but this didn't work either.

Does anyone know what the solution to this is? Or should i be speaking to Qlik Support?

[bramkn]

 @Yianni_Ververis Please answer my question: 

Can you tell me if the export image call will also be available in the .NET SDK. I have checked last week, could not find it.

I have been waiting for this possibility for  a while. It should already be possible but is not refferenced. So please help me out.

[Yianni_Ververis]

@bramkn No idea. I will look into it and let you know.

[Yianni_Ververis]

I encourage everyone, if you have not done already, to join qlik-branch.slack.com.

[bramkn]

@Yianni_Ververis Did you find any info on this?