Matomo API: How to query data in smaller chunks (e.g. per hour)?


#1

Hello everyone,

I have a problem with querying logging data via the Matomo API.

Basically, the data I try to query is too big, even if I try to query it for just one day. I get the following error message:

<b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes)

I guess, a possible solution would be to query data in smaller junks (e.g. per hour or one row after another). Does the Matomo API provide an option for this?

Thanks in advance!


(Lukas Winkler) #2

No matter which API you are using, you can always use the filter_limit and filter_offset parameters:

https://developer.matomo.org/api-reference/reporting-api


#3

Thank you! I didn’t saw the filter_offset option. I guess, this should solve my problem.

I’ll get back to you if any questions pop up if that’s okay. :slight_smile: