API Live.GetlastVisitsDetails


#1

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

Hi,

You can enable SQL logging as explained here:
https://matomo.org/faq/troubleshooting/faq_115/

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.


#3

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

Hi,

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


#5

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.