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.