search

matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.9k stars 2.65k forks source link

Hide the meta data field within the Reporting API #20062

Open Chardonneaur opened 1 year ago

Chardonneaur commented 1 year ago

Hi team, Would it be possible to hide the metadata field when using the reporting API? For example here: https://demo.matomo.cloud/index.php?module=API&format=html&idSite=1&period=day&date=yesterday&method=Actions.getPageUrls&expanded=1&translateColumnNames=1&language=fr&token_auth=anonymous&filter_limit=3&showColumns=nb_hits even by using the showColumns parameter, the meta data column still appearing. As a result we need to process back our result whereas the interest of using API parameters is to get a clean data feed.

bx80 commented 1 year ago

Hi @Chardonneaur, thanks for highlighting this :+1:

The _metadata column is a special column so it is being ignored by the showColumns / hideColumns parameters. I can't think of any reason why it shouldn't be possible to hide this column via the API parameters.

I've assigned this change for prioritization.

sgiehl commented 1 year ago

This might actually be something special in the html export only. Neither xml nor json export does contain the metadata.

Chardonneaur commented 4 months ago

This is happening on a custom report here: https://demo.matomo.cloud/index.php?module=API&format=JSON&idSite=1&period=range&date=2024-06-01,2024-06-26&method=Live.getLastVisitsDetails&filter_limit=10&expanded=1&token_auth=anonymous with JSON, HTML, XML etc

rcontiuk commented 4 months ago

We have another corporate user requesting the meta data to be hidden. @Stan-vw would it be possible to speed up this? It should be a quick fix to hide the column.

Chardonneaur commented 3 months ago

I got another use case this morning. In fact, this is really problematic for any web analysts doing automatic dashboarding with Matomo data.