API Live.GetlastVisitsDetails


Would someone be able to tell me the SQL statement that lies behind the API Live.GetLastVisitsDetails in Piwik 2.3.0 Thanks!

(Lukas Winkler) #2


You can enable SQL logging as explained here:

But I can’t promise it will work on 2.3.0 as you are 52 stable releases and nearly 5 years of development behind.


Hi Lukas,

We’ve tried SQL logging but as you said it’s such an old version it won’t work. We are planning to move to a hosted version of Matomo but in the meantime we need to access the data held in the database but the API call only brings back
a limited number of records because of the performance of the database.

Thanks for your help though.

(Lukas Winkler) #4


Have you tried combining filter_limit and filter_offset to only request a few visits at a time to not run into a timeout?


Hi Lukas,

Yes tried all that unfortunately. We can get a maximum of 2000 rows back (takes about 5 mins) but a day’s worth of visit data would be about 550000 rows so would take a very long time even if we could run continuous API calls.