Custom pivots API

The custom pivots API allows you to take existing list and pivot reports and represent them as JSON. This enables developers to pull related data from multiple types of records in a single API query.

There are two types of reports that you can pull via this API: list or pivot. See the documentation below for a full explanation of their formats.

The :report_id parameter is the ID of a saved view in Aha! To find the ID of an existing report, choose the report from the Views -> Saved views dropdown in Aha! Then take the large number at the end of the URL with the term custom_pivots in it. For example, /bookmarks/custom_pivots/6434552458299516367 has a :report_id of 6434552458299516367.

Select an API endpoint from the navigation to learn more.