API Live.GetlastVisitsDetails

doubleH · April 2, 2019, 2:19pm

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

Lukas · April 2, 2019, 4:16pm

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.

doubleH · April 2, 2019, 5:57pm

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 · April 3, 2019, 9:52am

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?

doubleH · April 4, 2019, 7:31am

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.