matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.83k stars 2.64k forks source link

is it possible to return all the results from api call ? #11846

Closed idhard closed 7 years ago

idhard commented 7 years ago

according this ticket #8458 now all api call results apply a limit of 100 records , but in the documentation https://piwik.org/faq/how-to/faq_24536/ it shown that you could specify the format_limit=-1 to get all the results , which is not longer possible .

Is the documentation outdated ? is not possible to get all the results anymore ?

thanks

RMastop commented 7 years ago

Hi @idhard,

It's a typo, use filter_limit in those cases.

Important note about high traffic Piwik servers

If you export a lot of data, for example more than 10,000 visits and their associated actions and clickstream, then the HTTP request above may take a long time or even time out (depending on your server and PHP settings). Therefore when you export a lot of data, we recommend that you only export 10,000 at a time and use our paging &filter_offset= feature. Here is how this works: to export the first 10,000 records, instead of filter_limit=-1 you would write filter_limit=10000&filter_offset=0. Then, to export the next dataset, you would write filter_limit=10000&filter_offset=10000. Then to export the next dataset, you will write filter_limit=10000&filter_offset=20000. You repeat this until there is no more result in the dataset.

sgiehl commented 7 years ago

thx @RMastop for answering this.

RMastop commented 7 years ago

@sgiehl do we need a separate ticket to edit this faq: https://piwik.org/faq/how-to/faq_24536/ Or is it already edited?

sgiehl commented 7 years ago

Sorry, guess the cache wasn't purged. The FAQ should be fixed now.

RMastop commented 7 years ago

fixed it is 👍