Events CSV: more than 1000 rows?

We're trying to download all the events from a 90 day period and it seems that the download to CSV cuts off at 1000 rows. Is this intentional?

If so, how can we download the full list?

Thanks.

hi youlookfab

yes, it is intentional.

* see clicky.com/help/faq/features/export/limit

.. Exporting more than 1000 items

.. For performance reasons, exporting via the web UI is limited to 1,000 items. If you wish to export more data than that for any report, you will need to use the API.


Here's a start on an API call that might work for you...

https_//api.clicky.com/api/stats/4?site_id=xxxxxx&sitekey=yyyyyyyyyyyyyyyy&type=events&date=last-90-days&output=csv

* you would need to replace xxxxxx with your site_id, and yyyyyyyyyyyyyyyy with your sitekey


Here's a working example for the clicky.com site that you can play with:

https://api.clicky.com/api/stats/4?site_id=32020&type=events&date=last-90-days&output=csv

hth

Thanks. Wow, 1000 isn't very useful.

And thanks for the examples, but in both cases they only get 10 rows. I think one has to set the "limit" query param and I'll experiment with that. If I read the doc page correctly the maximum I'll get is 5000, so that's unlikely to help either.

I'm afraid my answer is going to be something like a daily process that uses the API to download the previous day's activity and store it in my own DB.