topic Re: QlikSense exportData API not working as expected in Integration, Extension & APIs

QlikSense exportData API not working as expected

Manish_Kumar_ — Sat, 04 Jun 2022 17:36:05 GMT

Hi,

I have tried the below code in mashup js file:

It worked fine for small dataset but when data was more than 10 lakh in the visualization.It exported only around 1.2 lakhs of rows rest were truncated,but what it is supposed to do is to exported each and every row in the visualization as export type is csv,which has no rows limmited

Re: QlikSense exportData API not working as expected

NadiaB — Mon, 06 Jun 2022 20:44:04 GMT

Hi @Manish_Kumar_

Could you try changing the MaxSizeOfResponse to something big. The default value Is 20971520, maybe adding 2 extra zeros(2097152000), the value can be placed in the Settings. ini

Kind Regards.

Re: QlikSense exportData API not working as expected

Manish_Kumar_ — Thu, 09 Jun 2022 14:59:07 GMT

Hi @NadiaB ,

Please guide detailed steps to do so, as I am not known to this already.

I am using Qlik sense server, where would I find this settings.ini file and what if there no "MaxSizeOfResponse" variable defined in that file

Re: QlikSense exportData API not working as expected

NadiaB — Thu, 16 Jun 2022 19:23:29 GMT

Hi @Manish_Kumar_

The following article describes the steps to follow:

How to modify Qlik Sense Engine's Settings.ini
https://community.qlik.com/t5/Knowledge/How-to-modify-Qlik-Sense-Engine-s-Settings-ini/ta-p/1714789

Hope it helps!

Re: QlikSense exportData API not working as expected

NadiaB — Mon, 27 Jun 2022 12:42:49 GMT

Hi @Manish_Kumar_

By any chance did you have the opportunity to add the parameter in the Settings.ini and verify the outcome?

Kind Regards.

Re: QlikSense exportData API not working as expected

Manish_Kumar_ — Fri, 22 Jul 2022 15:12:39 GMT

Hi,

Followed the steps below to add MaxSizeOfResponse:

Stopped the Qlik sense qngine service and qlik sense dispatcher service.

Then added the key and value as provided by you..but still data is exported in truncated manner in csv

What if there no number of rows issue but the size issue or something else..please provide me with all keys and respective values related to that to update in settings.ini file...

And Second thing can i export this data in qvd by any chance..by making changes in my code

Re: QlikSense exportData API not working as expected

Manish_Kumar_ — Sat, 27 Aug 2022 18:11:01 GMT

Hey @NadiaB

Appologies for amy kind of delays!! But still I am stuck with it..I have updated the setting for MaxResponseSize as per link provided by you ..but still csv outputs limited rows !!!!

Any suggestions would be appreciated!!!!