Subtable ids different when calling Actions.getPageURLs using expanded=1 vs. not expanded

Feature Suggestions
1

Dear developers,

first of all happy new year and great thanks for all your work!

Unfortunately we have an issue calling the subtable of an expanded result set after calling http://oursite/index.php?module=API&method=Actions.getPageUrls&idSite=1&period=month&date=2012-12-20&token_auth=xxxxxxxxxxxxxxxxx&expanded=1

The expanded version returns a subtable id of 2:

<?xml version="1.0" encoding="utf-8" ?>
  • expertise 33912 43378 1859341 9508 31860 1512585 5242 9918 55 55% 29% 2

…

…whereas the not expanded version returns a subtable id of 2101 after calling
http://oursite/index.php?module=API&method=Actions.getPageUrls&idSite=1&period=month&date=2012-12-20&token_auth=xxxxxxxxxxxxxxxxx

<?xml version="1.0" encoding="utf-8" ?>
  • expertise 33912 43378 1859341 9508 31860 1512585 5242 9918 55 55% 29% 2101

Calling idSubtable=2101 works (http://oursite/index.php?module=API&method=Actions.getPageUrls&idSite=1&period=month&date=2012-12-20&token_auth=xxxxxxxxxxxxxxxxx&idSubtable=2101)

…whereas calling idSubtable=2 returns this empty xml result set:

<?xml version="1.0" encoding="utf-8" ?>

Could you please help us? We need the expanded version as we parse through the complete hierarchy and need to retrieve a special subtable having a specific label.

Thanks a lot and again thanks for your work.

The Webstat Guys.

2

For retrieving a specific label, please use &label=LABEL1,LABEL2 which should work for 1 or several labels.

Expanded=1 is not showing the right idsubdatatable IDs indeed (need to call without expanded=1 to see proper IDs)

3

Dear Matt,

thanks for Your response,
Unfortunately I could not retrieve data with the label option. Is there another way to reach data of subtables?
Will the problem get fixed in one of the next versions of piwik?

Thanks in advance for your answer

Wolfgang