Creating a Report with Custom Dimension Values

I’d like to create a custom report with some of the columns from the matomo2_log_link_visit_action table - but I don’t know how to get the data?

I’m trying to get a table with idlink_va, and the values of my custom_dimensions. I have several custom dimensions, that are stored in 1 action and I want to see all those values grouped together.

Does anybody know how I can get this?

Hi Christina,
To get this data it may be easier to use the Live API, which will return all actions by visitors, including the dimension values for each action. You can also use showColumns/hideColumns to customise the output a bit. Learn more: Reporting API Reference: API Reference - Matomo Analytics (formerly Piwik Analytics) - Developer Docs - v3
The Live API output will include the idlink_va called pageId