Would someone be able to tell me the SQL statement that lies behind the API Live.GetLastVisitsDetails in Piwik 2.3.0 Thanks!
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.
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.
Have you tried combining filter_limit and filter_offset to only request a few visits at a time to not run into a timeout?
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.