Help, API call to Actions.getPageUrls


(husky) #1

structure
example.com/user/123
example.com/user/123/photo/1
example.com/user/123/photo/2

example.com/user/111
example.com/user/111/photo/5

i want to get the number of page view from exmaple.com/user/123/photo/* per day for the last 30 days.

i have to call to Actions.getPageUrls with "&filter_pattern=user&filter_column=label" to get the idsubtable and then i have to call method=Actions.getPageUrls&idSite=1&period=day&date=last30&idSubtable=$idsubtable&filter_pattern=123&filter_column=label"; to get the idsubtable and then call 30 times to method=Actions.getPageUrls&idSite=1&period=day&date=$day&idSubtable=$idsubtable1&filter_pattern=photo&filter_column=label"; with the idsubtable and the day, because the idsubtable can change for each day

Is there another way of doing this without making so many requests?

thanks


(Matthieu Aubry) #2

You can use
* filter_column_recursive ; defines the column to be searched for when recursively searching for a pattern filter_pattern_recursive
* filter_pattern_recursive ; defines the text we are searching for. Only the matching rows are returned. This filter is applied to recursive tables (Actions / Downloads / Outlinks tables)

http://dev.piwik.org/trac/wiki/API/Reference

Also I hear your frustration, this will be made easier when we implement http://dev.piwik.org/trac/ticket/1363