Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
idhard opened this issue Jul 5, 2017 · 5 comments
Closed

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

idhard opened this issue Jul 5, 2017 · 5 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@idhard
Copy link

idhard commented Jul 5, 2017

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
Copy link
Contributor

RMastop commented Jul 5, 2017

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
Copy link
Member

sgiehl commented Jul 5, 2017

thx @RMastop for answering this.

@sgiehl sgiehl closed this as completed Jul 5, 2017
@sgiehl sgiehl added the answered For when a question was asked and we referred to forum or answered it. label Jul 5, 2017
@RMastop
Copy link
Contributor

RMastop commented Jul 5, 2017

@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
Copy link
Member

sgiehl commented Jul 5, 2017

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

@RMastop
Copy link
Contributor

RMastop commented Jul 5, 2017

fixed it is 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

3 participants