can I limit the columns returned by the API for getVisitInformationPerServerTime

Support & Bugs
1

I tried doing this but it does not change the output (I broke the url up to format it better):

http://XXXXXXX/piwik/index.php?module=API&method=VisitTime.getVisitInformationPerLocalTime&idSite=7&period=day&date=today&format=xml&token_auth=XXXXXXX
&columns[0]=label&columns[1]=nb_uniq_visitors&columns[2]=nb_visits&columns[3]=nb_actions

I am looking to just get a couple of columns so I can directly graph the output in another website that reads the data directly from the url

2

I’d actually like to expand this a bit…

http://demo.piwik.org/?module=API&method=UserSettings.getBrowserType&idSite=7&period=day&date=today&format=xml&token_auth=anonymous

With the above example you get all the attributes that UserSettings.getBrowserType has but I am only interested in the label and the unique visitor count… any way to only get those returned? I can query the database directly but would rather not…

thanks

3

No, you have to download and then only keep the data you need.

4

thanks… it might be a nice enhancement to the api… I found a way to only use the columns I want but thats not always possible…

5

See our new page, which lists the various limits on historical data, number of websites, users, database size, when using Piwik: Data Limits Analytics