New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
reporting API DevicesDetection.getOSVersions using showcolumns adds an extra column #6602
Comments
Hi @RMastop thanks for the report. |
Anyone working on this? do you need some more input on the bug? |
Hi @RMastop I'm moving this bug in next milestone so we take a look at it |
I didn't have a look yet but I think we recently talked about |
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 expected the result to contain only the requested columns. |
In the initial bug report, I used the parameter hideColumns=metadata_logo I guess I should use hideColumns=logo because metadata_ is added to the column label in the result. |
Neither |
Just tried in demo.piwik.org, hideColumns in live API is failing. |
I just tried http://demo.piwik.org/index.php?module=API&method=Live.getLastVisitsDetails&idSite=7&period=day&date=yesterday&expanded=0&translateColumnNames=0&hideColumns=idVisit,visitorId&format=xml and it seems to work. Which API are you using? |
Hi @tsteur Where I would like to retrieve the arrays of only the URL and pageTitle of every actionDetails row. |
This doesn't work by design since |
Hi,
API reporting features adds an extra column to the export, like the following:
http://demo.piwik.org/index.php?module=API&method=DevicesDetection.getOsVersions&format=TSV&idSite=7&period=day&date=yesterday&expanded=0&translateColumnNames=0&showColumns=label,nb_visits
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.
http://demo.piwik.org/index.php?module=API&method=DevicesDetection.getOsVersions&format=TSV&idSite=7&period=day&date=yesterday&expanded=0&translateColumnNames=0&showColumns=label,nb_visits&hideColumns=metadata_logo
Piwik version:2.8.3
The text was updated successfully, but these errors were encountered: