topic Limit Table Download in Integration, Extension & APIs

Limit Table Download

Anonymous — Mon, 18 Dec 2017 13:02:12 GMT

Hi everyone,

I am trying to limit the number of rows that are downloaded from a table.

The tabel is created "on the fly" via app.visualization.create('table',...) and the download is initiated via table.exportData(...).

Therefore I see two potential working points for limiting the number of rows, the table object itself and the exportData function. However I could not figure out how to implement this functionality.

As of now I just dump the complete download in a Blob and get rid of the unnecessary rows there. However when the Dataset is large this becomes a performance issue, so I really would like to get rid of the abundant rows before initiating the download.

Has anyone some advice on how to takle this issue?

Best,

Marco

Re: Limit Table Download

YoussefBelloum — Mon, 18 Dec 2017 13:16:16 GMT

Hi,

can't you use WHERE at the end of the load before the export ??

Re: Limit Table Download

Anonymous — Mon, 18 Dec 2017 14:08:18 GMT

Hey Youssef,

thaks for your response, but could you please elaborate what you mean with end of load?

Are you refereing to the load script of the underlying qlik application?

That would unfortunately not help me as I am performing the download on the client side.

Or is there a way I can use it within js?

Best,

Marco

Re: Limit Table Download

YoussefBelloum — Mon, 18 Dec 2017 14:22:24 GMT

Sorry i was talking about the script..

don't know if you can do it within Js..