API limit: Actions.getPageUrls always returns only 100 rows, despite config and cache reset

Support & Bugs
1

Hello Matomo Community,

I am running a Matomo installation on shared hosting (ALL-INKL, Germany). I’m trying to export a full list of all event pages (approx. 4000 URLs, all starting with /veranstaltungen/) via the API.

However, I always receive only 100 rows in the export, no matter what I try.
Here’s what I have already done:

  • Adjusted config.ini.php (and/or global.ini.php) with:

ini

datatable_archiving_maximum_rows_actions = 500000
datatable_archiving_maximum_rows_subtable_actions = 500000


* Deleted the entire `tmp/` cache directory via FTP
* Used the API URL with a high `filter_limit`, e.g.:

sql


...module=API&method=Actions.getPageUrls&idSite=1&period=range&date=2000-01-01,today&format=CSV&flat=1&filter_column=label&filter_pattern=^/veranstaltungen/&filter_limit=500000&token_auth=MYTOKEN

No matter what I try, the result is always just 100 URLs.
There is no “Other” row in the results (no subtable ID), so I cannot drill down further.

My goal:
I want to build an automated “Top 10” list of the most popular event pages, based on real organic traffic (excluding paid traffic/campaigns like Google Ads etc.). The export should run regularly (via cron) and be used for an external site.
We do not want to use Google Analytics or other Google tools.

My questions:

  1. Is there any hard-coded limit in Matomo (or a known bug) that prevents exporting more than 100 rows, despite config settings and cache reset?
  2. Is there any recommended workaround to get the full list of page URLs (in my case, about 4000)?
  3. Is this behavior specific to some hosting environments (e.g. shared hosting)?
  4. If Matomo cannot provide more than 100 rows in this case, can you recommend a privacy-friendly alternative for tracking and exporting popular event pages (again, not Google Analytics)?

Any help or pointers would be highly appreciated!

Thank you very much!

Best regards,
Flo