How to send a large amount of data with an API on Qlik extension
Hi experts,
I created a Qlik extension so that I could retrieve a dataset via this extension to make predictions using machine learning and store the results in a database.
The problem is that I can't send more than 3 columns (even though there are more than 4,000 rows). I tried sending data in blocks using JavaScript, but I'm still limited.
How can I write the code to send all my data? For example, 4,000*15 cells.
What columns you get is defined by the "Left" and "Width" parts of the NxPage-instance you use when getting data, so that's probably where you have the settings you're looking for. Be aware that the engine enforces a limit so that you get an error if you have a page larger than 10000 cells, so if you have 15 columns and 4000 rows, then you'll have to do pagination to get them all. If you for instance choose to get 500 rows at a time (total cells per page 15*500=7500) you could use this as your first page:
{ Top = 0, Left = 0, Height = 500, Width = 15 }
And this as your second:
{ Top = 500, Left = 0, Height = 500, Width = 15 }
The first page will return row 0-499 and the second one will return row 500-999.
What columns you get is defined by the "Left" and "Width" parts of the NxPage-instance you use when getting data, so that's probably where you have the settings you're looking for. Be aware that the engine enforces a limit so that you get an error if you have a page larger than 10000 cells, so if you have 15 columns and 4000 rows, then you'll have to do pagination to get them all. If you for instance choose to get 500 rows at a time (total cells per page 15*500=7500) you could use this as your first page:
{ Top = 0, Left = 0, Height = 500, Width = 15 }
And this as your second:
{ Top = 500, Left = 0, Height = 500, Width = 15 }
The first page will return row 0-499 and the second one will return row 500-999.
