@RMastop opened this Issue on November 5th 2014 Contributor


API reporting features adds an extra column to the export, like the following:

What I expected was an export with 2 columns, named "label" and "nb_visits".

What I got was an export with 3 columns; "label", "nb_visits" and an extra, but unwanted "metadata_logo"

When adding the option hideColums for the unwanted column, the result stays the same.


Piwik version:2.8.3

@mattab commented on December 1st 2014 Owner

Hi @RMastop thanks for the report.

@RMastop commented on February 5th 2015 Contributor

Anyone working on this? do you need some more input on the bug?

@mattab commented on February 6th 2015 Owner

Hi @RMastop I'm moving this bug in next milestone so we take a look at it

@tsteur commented on February 13th 2015 Owner

I didn't have a look yet but I think we recently talked about showColumns/hideColumns not filtering metadata which would be kinda a bug. Just in case someone will work on this and applies the filtering to metadata as well be aware that this would be a breaking change and would most likely break all Piwik Mobile versions.

@RMastop commented on February 13th 2015 Contributor

I sometimes need to use both showColumns AND hideColums to ge the correct result. For instance when requesting page url data in a flat format, where I only need nb_hits and url.
I need to showColumns for nb_hits and url. But because I use flat=1 I get all subcolumns as well. I then use hideColumns to hide those unwanted culomns, like action name etc.

I expected the result to contain only the requested columns.

@RMastop commented on February 13th 2015 Contributor

In the initial bug report, I used the parameter hideColumns=metadatalogo I guess I should use hideColumns=logo because metadata is added to the column label in the result.

@tsteur commented on February 14th 2015 Owner

Neither logo nor metadata_logo will work from what I have seen so far. This will get worse with the next release as there will be another metadata entry (column) named segment. Problem will be to fix it without breaking the API. We might need to introduce API versions at some point.

@RMastop commented on January 4th 2016 Contributor

Just tried in demo.piwik.org, hideColumns in live API is failing.
Is this someting that might be solved in near future release? I only need some columns, but either showColumns or hideColumns does not seem to work. So now I need to download all data and than throw away unneeded data.

@tsteur commented on January 10th 2016 Owner
@RMastop commented on January 11th 2016 Contributor

Hi @tsteur
one of them would be:

Where I would like to retrieve the arrays of only the URL and pageTitle of every actionDetails row.
The result I get is a list of empty row values.

@tsteur commented on January 11th 2016 Owner

This doesn't work by design since showColumns currently only works on first level properties like actionDetails, idVisit, ... it doesn't apply it to "nested elements". This is a new feature would possibly require a new API parameter

@mattab commented on December 27th 2016 Owner

@RMastop this should now work after https://github.com/piwik/piwik/pull/11100 - please open new issue if you still experience a problem after 3.0.1-b1 (will be released in few hours)

This Issue was closed on December 27th 2016
Powered by GitHub Issue Mirror