When you want to query your database, you can use an API call definition in Piwik PRO. The definition is available for each report inside Piwik PRO. Just make a few clicks and have your API call ready.
To fetch data directly from a report, follow these steps:
- Log in to Piwik PRO.
- Go to Menu > Analytics.
- Navigate to Reports, Custom reports, Goals or Ecommerce.
- On the left, select the report you want to work on.
- Click the ⋯ three-dot icon next to the report section that you want to use.
- Click View API call definition.
- Copy an API endpoint or API query.