API_datatable_default_limit = -1 does'nt work?

Support & Bugs
1

Hi all,

For performance reasons, I would like to limit the display of ’ lines of pages’ to 500 for example, and allow the all display only by export.

I saw the parameter API_datatable_default_limit, for which it is mentioned that “if set to -1, a click on ‘Export as’ will export all rows independently of the current ‘# Rows to display’.” Eureka !

Unfortunatly, it does’nt work ! In all cases, even with "API_datatable_default_limit’ set to -1, the number of exported lines is always the number of limited displayed rows.

Is it a bug ? in there another way to force to export all the lines independently of the number of displayed lines ?

My piwik version is 3.2.1.

Thank in advance for your help
FR

2

Hi,

Did you try adding &filter_limit=-1 to the API request?
https://developer.matomo.org/api-reference/reporting-api

3

Yes I did, it works.
But if you ask for an export to csv file, there is no display of the API, and you cannot modify the line.
And it seems not to be serious to give to a user this kind of solution ! It’s a little bit DIY :slight_smile:

1 Like
4

Hm,

Reading

I expected the export to return the correct API path. (Even though that issue is quite old)